Page 3 of 4

Re: XI reporting not working properly

Posted: Mon Jun 09, 2014 9:30 am
by slansing
Try:

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

Re: XI reporting not working properly

Posted: Mon Jun 09, 2014 11:46 am
by 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 ..?

Re: XI reporting not working properly

Posted: Mon Jun 09, 2014 4:42 pm
by 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?

Re: XI reporting not working properly

Posted: Tue Jun 10, 2014 2:19 am
by 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.

Re: XI reporting not working properly

Posted: Tue Jun 10, 2014 2:50 pm
by 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).

Re: XI reporting not working properly

Posted: Wed Jun 11, 2014 1:53 am
by 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

Re: XI reporting not working properly

Posted: Wed Jun 11, 2014 9:55 am
by 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.

Re: XI reporting not working properly

Posted: Wed Jun 11, 2014 9:57 am
by scottwilkerson
anil_kumarv wrote: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

Re: XI reporting not working properly

Posted: Wed Jun 11, 2014 12:35 pm
by 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

Re: XI reporting not working properly

Posted: Wed Jun 11, 2014 1:23 pm
by 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