Page 1 of 1

Nagios XI Database Errors

Posted: Thu Nov 19, 2015 5:54 am
by proquibas
Hi all,

I'm having problems with Nagios Database. I recieve this error:

Code: Select all

Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.

Run the following from the CLI as root to attempt to repair the DB
/usr/local/nagiosxi/scripts/repair_databases.sh

This error appear in the gui. I check the /var/log/mysqld.log and /var/log/messages but no errors found. I have Nagios XI 5.2.2.
When I run the command /usr/local/nagiosxi/scripts/repair_databases.sh it repair the database and the script ends succesfully. It works for a few hours and then it the message appear again. The GUI start to show the message, but in the logs all is working correctly.

Can you help me about this please?

Thanks a lot!

Re: Nagios XI Database Errors

Posted: Thu Nov 19, 2015 10:39 am
by rkennedy
To help assist you a bit more, I have a few questions -

1. What are the resources of this machine?
2. How many hosts / services are being monitored?
3. Has it been turned off / on during the period of time where SQL crashes?
4. Is your SQL local, or offloaded?