Page 1 of 1

Database Backend Status Red

Posted: Thu Aug 30, 2018 3:09 pm
by 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

Re: Database Backend Status Red

Posted: Thu Aug 30, 2018 3:42 pm
by 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.

Re: Database Backend Status Red

Posted: Thu Aug 30, 2018 4:03 pm
by 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.

Re: Database Backend Status Red

Posted: Sat Sep 01, 2018 7:08 am
by wspackaging
removing the ndo.sock did the trick.
Thanks for your help.
-pete

Re: Database Backend Status Red

Posted: Tue Sep 04, 2018 8:23 am
by lmiltchev
You are welcome, pete! I am glad I could help! :)