Page 1 of 1

State History not displaying

Posted: Fri Dec 02, 2016 3:21 pm
by 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.

Re: State History not displaying

Posted: Mon Dec 05, 2016 9:44 am
by 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.

Re: State History not displaying

Posted: Mon Dec 05, 2016 2:18 pm
by remedsys
That worked, thanks!

Re: State History not displaying

Posted: Mon Dec 05, 2016 3:33 pm
by 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!