XI reporting not working properly

[slansing]

Try:

http://---- Snip ---/nagios

[anil_kumarv]

Okay, reports in Nagios Core seems to be working fine. I tested pulling Top Alert producers for the past 7 days and filtered them for hostgroup. Even the filtered reports are showing data matching the hosts/services in Non-Filtered report. So is it just an filtering issue within NDOUtils db ..?

[lmiltchev]

Try stopping/starting services in case you have some sync issues:

Code: Select all

service nagios stop
killall nagios
service ndo2db stop
service ndo2db start
service nagios start

Can you filter the "Top Alert Producers" by a hostgroup now in Nagios XI?

[anil_kumarv]

Stopped/Started the services in order as given below, but still same issue. Nothing shows in Top Alert producers when filtered with any hostgroup for any time period.

[abrist]

This is interesting as the reports work fine on my 2012r2.9 and 2014r1.1 test boxes.
Right click on the top alert producer link and open in a new tab. Choose your hostgroup from the dropdown and then click "update". Now copy the url and post it here (obfuscate if necessary).

[anil_kumarv]

Here are couple of URL's filtered for Class-Artemis & Raiden

http://---- Snip ---/nagiosxi/reports/topalertproducers.php?host=&service=&reportperiod=last24hours&startdate=&enddate=&reporttimesubmitbutton=Go&hostgroup=class-artemis&servicegroup=&statetype=hard&page=1&records=25

http://---- Snip ---/nagiosxi/reports/topalertproducers.php?host=&service=&reportperiod=last24hours&startdate=&enddate=&reporttimesubmitbutton=Go&hostgroup=class-raiden&servicegroup=&statetype=hard&page=1&records=25

[anil_kumarv]

After that post we increased the values to 7 days for Max Log Entries Age, Max Notifications Age, Max State History Age. That's when we started getting Top Alert producers report. But when filtered to any hostgroup, we dont get anything showing 0 records.

[scottwilkerson]

After that post we increased the values to 7 days for Max Log Entries Age, Max Notifications Age, Max State History Age. That's when we started getting Top Alert producers report. But when filtered to any hostgroup, we dont get anything showing 0 records.

Sorry, I deleted my post after I was re-reading the thread and saw this to be the case...


To make sure we are comparing apples to apples, can you post the corresponding URL's for the reports you saw in Core that worked?

I just want to make sure we have all the same settings, groups, timeframes, statetypes, etc.

Also, can you confirm that you do not have any database errors

Code: Select all

tail -200 /var/log/mysqld.log

[anil_kumarv]

In core, I go to Summary on the left-> Under Custom reports-> Top Alert Producers -> Last 7 days -> filter by Class-Artemis ->Create summary report. Takes me to the following URL :

[url]http://----%20Snip%20---/nagios/[/url]

But the URL contains all the report I need.

Attached mysqld logs

[lmiltchev]

You have some database errors...

Code: Select all

130730 21:08:14 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './nagios/nagios_servicestatus.MYI'; try to repair it

Run the database repair scripts, and check the mysqld.log again to make sure the errors were fixed.

Code: Select all

cd /usr/local/nagiosxi/scripts
./repairmysql.sh nagios
./repairmysql.sh nagiosql
tail -50 /var/log/mysqld.log