Corrupt SQL Database?

[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

[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.

[djastv]

Worked a treat!

Thanks a lot.

[tmcdonald]

I'll be closing this thread now, but feel free to open another if you need anything in the future!