Database Backend Status Red

[wspackaging]

I'm running NagiosXI on a VM. We had a hardware failure this morning that took down a lot of servers including Nagios.
Now that the hardware issue is resolved the Nagios server is showing Database Backend Red (!) in Admin > XI System Component Status.

I tried clicking on the gear to start the DB. that does nothing. I tried running a repair_databases.sh. The script says there are repairs but doesn't allow the DB to start.

I'm getting flooded with alerts. Not all services but most are showing "CHECK_NRPE State Critical: Socket timeout after 30 seconds.

Any suggestions?

-pete

[syang]

Can you show the output for this command (mariadb)? If it's mysqldb, use the second command.

Code: Select all

tail -n 20 /var/log/mariadb/mariadb.log

Code: Select all

tail -n 20 /var/log/mysqld.log

You can also try troubleshooting with this article:
https://support.nagios.com/kb/article/n ... s-617.html

Let me know if this helps!
Thanks.

[lmiltchev]

In addition to this, try the following:

Code: Select all

service nagios stop
service ndo2db stop
rm -f /usr/local/nagios/var/ndo.sock
service ndo2db start
service nagios start

Let us know if this helped.

[wspackaging]

removing the ndo.sock did the trick.
Thanks for your help.
-pete

[lmiltchev]

You are welcome, pete! I am glad I could help!