Jump to content

Eset Protect Virtual Appliance v 10.0.2133 MySQL Not starting


Recommended Posts

On prem install of Eset Protect Virtual Appliance v 10.0.2133 suddenly won't allow login get error below:

Login failed: Connection has failed with state "loginConnectionStateNotConnected" 

Webmin works but show MySQL not running

Error!  MySQL is not running on your system - database list could not be retrieved.
MySQL error message
The full MySQL error message was : connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

trace.log shows

2023-07-11 05:53:11 Error: CDatabaseModule [Thread 7f3a29f3e740]: Probing database connection failed. Next connection attempt will be in 10 seconds. 11 more attempts will be made. The database access layer reported: [unixODBC][MySQL][ODBC 8.0(w) Driver]Can't connect to MySQL server on '127.0.0.1' (111) (2003)

odbc 8.0 has worked in the past - see below 2 failed attempts and then success.

2023-04-09 01:01:23 Information: CDatabaseModule [Thread 7f12d136a740]: Startup configuration builder builds successfully ...
2023-04-09 01:01:24 Error: CDatabaseModule [Thread 7f12d136a740]: Probing database connection failed. Next connection attempt will be in 10 seconds. 11 more attempts will be made. The database access layer reported: [unixODBC][MySQL][ODBC 8.0(w) Driver]Can't connect to MySQL server on '127.0.0.1' (111) (2003)
2023-04-09 01:01:34 Error: CDatabaseModule [Thread 7f12d136a740]: Probing database connection failed. Next connection attempt will be in 10 seconds. 10 more attempts will be made. The database access layer reported: [unixODBC][MySQL][ODBC 8.0(w) Driver]Can't connect to MySQL server on '127.0.0.1' (111) (2003)
2023-04-09 01:01:46 Information: CDatabaseModule [Thread 7f12d136a740]: Startup connection pool created ...

I have tried to upgrade to ODBC version 8.0.16 and roll back to v5.3 both with the same error.

2023-07-11 09:00:12 Error: CDatabaseModule [Thread 7f370a157740]: Probing database connection failed. Next connection attempt will be in 10 seconds. 11 more attempts will be made. The database access layer reported: [unixODBC][MySQL][ODBC 5.3(w) Driver]Can't connect to MySQL server on '127.0.0.1' (111) (2003)

Not sure if db is corrupt.  I have a /root/era-backup.sql backup but with the MySQL server running I am not sure how to restore.

 

Any suggestions ?

John.

Link to comment
Share on other sites

  • Administrators

Please raise a support ticket for help with further troubleshooting of the issue.

Link to comment
Share on other sites

Any update to this problem ? we have the same issue ...

2023-07-22 17:56:35 Error: CDatabaseModule [Thread 7f20ba81d740]: Probing database connection failed. Next connection attempt will be in 10 seconds. 11 more attempts will be made. The database access layer reported: [unixODBC][MySQL][ODBC 8.0(w) Driver]Can't connect to MySQL server on '127.0.0.1' (111) (2003)
2023-07-22 17:56:45 Error: CDatabaseModule [Thread 7f20ba81d740]: Probing database connection failed. Next connection attempt will be in 10 seconds. 10 more attempts will be made. The database access layer reported: [unixODBC][MySQL][ODBC 8.0(w) Driver]Can't connect to MySQL server on '127.0.0.1' (111) (2003)
2023-07-22 17:56:55 Error: CDatabaseModule [Thread 7f20ba81d740]: Probing database connection failed. Next connection attempt will be in 10 seconds. 9 more attempts will be made. The database access layer reported: [unixODBC][MySQL][ODBC 8.0(w) Driver]Can't connect to MySQL server on '127.0.0.1' (111) (2003)
 

Link to comment
Share on other sites

  • Administrators

Please raise a support ticket and follow the instructions provided by technical support.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...