Page 1 of 1

Database connection error

Posted: Sun Jul 05, 2015 11:19 am
by 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.

Re: Database connection error

Posted: Mon Jul 06, 2015 8:30 am
by 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

Re: Database connection error

Posted: Wed Jul 08, 2015 1:51 pm
by eddiez
Issue resolved, thanks.