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.