JohnKerr995 0 Posted July 11, 2023 Share Posted July 11, 2023 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 More sharing options...
Administrators Marcos 5,259 Posted July 11, 2023 Administrators Share Posted July 11, 2023 Please raise a support ticket for help with further troubleshooting of the issue. Link to comment Share on other sites More sharing options...
Ricardoleubeck 0 Posted July 14, 2023 Share Posted July 14, 2023 Has anyone managed to find a solution for this problem? i am having this problem too. Link to comment Share on other sites More sharing options...
Ivanoff Capetillo 0 Posted July 22, 2023 Share Posted July 22, 2023 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 More sharing options...
Administrators Marcos 5,259 Posted July 23, 2023 Administrators Share Posted July 23, 2023 Please raise a support ticket and follow the instructions provided by technical support. Link to comment Share on other sites More sharing options...
Recommended Posts