Software Version 220.127.116.11 (build 40)
OS Sourcefire Linux OS 5.4.0 (build126)
Hello! I have a problem! I hope for your help!
When a try to apply settings to Sensor in FireSight - i have error - "Unable to connect to DB". FireSight and FirePower see each other in lan.
How i can solve this problem? What am I doing wrong?
Is this a new installation? or it was registered to different FMC and now registered to another one? this looks like could be issue with database corruption.
It could end up with re-image but I would suggest to open TAC case for it.
Rate if helps.
If its a hardware , you can also check the LCD panel if that shows any hardware error (click on next button ).
Other than that , is there any sudden power loss occurred in the device? . If the device gets powered off suddenly , this will mess up the database.
Looks like the mysql will be in a shutdown mode or unresponsive mode. Its just because of the database error only , this error will occur.
Could you please verify the status of the following :-
pmtool status |grep mysqld
Other than this , to troubleshoot this you need to contact the TAC team since starting from version 5.4 we are not supposed to make any alterations to the database without the TAC assistance.
Rate if this post helps you.
Yep, same issue here!
Aug 9 09:11:35 firepower SF-IMS:  (none):MySQLDatastore [ERROR] MySQLDatastore.c:620:Connect(): Unable to connect to database after 60 seconds: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111)
Aug 9 09:11:35 firepower SF-IMS:  hm_notifyd:DatastoreClient [ERROR] Unable to connect to datastore: Unhandled database error
Aug 9 09:11:35 firepower SF-IMS:  hm_notifyd:HMNOTIFY_ReadConfig [ERROR] Unable to create DB connection: Unhandled database error
Aug 9 09:11:35 firepower SF-IMS:  hm_notifyd:main [ERROR] Error reading configuration on the database