State History not displaying

[remedsys]

I am having an issue with my Nagios XI install. I'm not sure if this was before or after updating to 5.3.

I am unable to view the "State History" report for any hosts and services. Even though I know states have changed, the report remains empty when I run it. Also, if I check a host or service history using the small icon under the name of the host/service, that also returns blank.

I have attached my System Profile.

[tgriep]

The log file from the profile shows that the Mysql statehistory table is corrupt and needs to be repaired.
Login as root to the XI server and run the following to repair it.

Code: Select all

cd /usr/local/nagiosxi/scripts
./repair_databases.sh

This should fix the table and then the State History report should have data.

[remedsys]

That worked, thanks!

[dwhitfield]

Glad to hear it is resolved. I am going to lock the thread. Please feel free to post again if you have you another issue. Thank you for using the Nagios forums!