Database connection error

[eddiez]

I am getting the following when trying to access my Nagios system.

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.

I ran the script listed and still get this message. At this point my production system is down.

[lmiltchev]

Sometimes one needs to run the database repair script a few times before ALL of the errors are fixed. Did you check the mysql log for errors (crashed tables) after you ran the script?

Code: Select all

tail /var/log/mysqld.log

Do you still see some errors?

Also, it is possible that the problem is not related to mysql database but postgres. Can you restart postgres and check if it is running?

Code: Select all

service postgresql restart
service postgresql status

Did you run out of disk space? What is the output of the following commands?

Code: Select all

df -h
df -i

[eddiez]

Issue resolved, thanks.