Page 1 of 1

Corrupt SQL Database?

Posted: Wed Jul 01, 2015 10:06 pm
by djastv
Hi,

I've recently installed Nagios XI, licensed it and configured it. However when I click on the host overview I just get an SQL database error. I've attached a screenshot of the issue I'm having.

The install of nagios details are:

CentOS 6
Bare metal install (Not running on VM)
Static IP
Time synced to local NTP server

If somebody can advise me on how to fix this I'd appreciate it.

Thanks

Re: Corrupt SQL Database?

Posted: Thu Jul 02, 2015 8:29 am
by lmiltchev
Run the following command from the command line:

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh
then check the mysqld.log for errors (corrupt tables):

Code: Select all

tail /var/log/mysqld.log
Let me know if this helped.

Re: Corrupt SQL Database?

Posted: Thu Jul 02, 2015 9:27 pm
by djastv
Worked a treat!

Thanks a lot.

Re: Corrupt SQL Database?

Posted: Fri Jul 03, 2015 4:56 pm
by tmcdonald
I'll be closing this thread now, but feel free to open another if you need anything in the future!