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