Page 1 of 1
No host/service details in any of the Views
Posted: Wed Apr 04, 2012 2:45 pm
by jglass
Hello,
I logged in to find that none of my host/service details are able to be viewed within my Nagios XI system. I have attached screen shots to help us understand the issue.
If I view the Service Group Status/Summary View, it shows that I have many services defined, but when I drill down there is no data in the Host and Service Status Summary.
I'm not sure where to even begin on this, so any help would be greatly appreciated!
Thanks,
Jason
Re: No host/service details in any of the Views
Posted: Wed Apr 04, 2012 3:00 pm
by scottwilkerson
Are you logged in as the nagiosadmin?
Re: No host/service details in any of the Views
Posted: Wed Apr 04, 2012 3:06 pm
by jglass
Yes.
Re: No host/service details in any of the Views
Posted: Wed Apr 04, 2012 3:13 pm
by scottwilkerson
First can we verify that on
Admin -> XI System Component Status
everything is green.
If that is the case, can you run
And report any recent errors
Re: No host/service details in any of the Views
Posted: Thu Apr 05, 2012 8:22 am
by jglass
Everything is green, and I have restarted the monitoring engine and database component in hopes that this would fix my issue.
I ran: tail -f /var/log/httpd/error_log. Here is what I'm seeing (see attached to see that these errors are repeating):
[Thu Apr 05 07:57:42 2012] [error] [client inf_server2] PHP Notice: Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 108, referer: http://nagiosxi_srv/nagiosxi/
[Thu Apr 05 07:57:43 2012] [error] [client inf_server2] PHP Warning: strtotime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Chicago' for 'CDT/-5.0/DST' instead in /usr/local/nagiosxi/html/includes/utils-status.inc.php on line 70, referer: http://nagiosxi_srv/nagiosxi/
[Thu Apr 05 08:07:40 2012] [error] [client inf_server2] PHP Notice: Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 105, referer: http://nagiosxi_srv/nagiosxi/admin/
[Thu Apr 05 08:07:40 2012] [error] [client inf_server2] PHP Notice: Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 108, referer: http://nagiosxi_srv/nagiosxi/admin/
Thanks,
Jason
Re: No host/service details in any of the Views
Posted: Thu Apr 05, 2012 8:32 am
by scottwilkerson
Newer releases of PHP require this setting for your server to reflect the correct system time and timezone. To change this setting, edit the /etc/php.ini file with the following line:
Change the timezone to match your location. These zones are listed at the following URL.
http://nz.php.net/manual/en/timezones.php
PHP Timezones After changing the setting, restart your apache server:
Re: No host/service details in any of the Views
Posted: Thu Apr 05, 2012 9:09 am
by jglass
I updated /etc/php.ini with: date.timezone = America/Chicago
That suppressed, rather fixed, all of the time errors in the log, although, the web interface still doesnt show host/service details.
Here is what the error_log is showing now:
[Thu Apr 05 08:57:28 2012] [error] [client int_server2] PHP Notice: Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 109, referer: http://nagiosxi_srv/nagiosxi/
[Thu Apr 05 08:57:59 2012] [error] [client int_server2] PHP Notice: Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 110, referer: http://nagiosxi_srv/nagiosxi/
[Thu Apr 05 08:58:10 2012] [error] [client int_server2] PHP Notice: Trying to get property of non-object in /usr/local/nagiosxi/html/includes/components/xicore/ajaxhelpers-servicestatus.inc.php on line 408, referer: http://nagiosxi_srv/nagiosxi/includes/components/xicore/status.php?show=services
More attached.
Thank you.
Re: No host/service details in any of the Views
Posted: Thu Apr 05, 2012 9:26 am
by mguthrie
This is a database issue. There's either corruption in the ndoutils database, or the connection limit is being hit. Try the following:
Code: Select all
service ndoutils stop
service nagios stop
service mysqld stop
cd /usr/local/nagiosxi/scripts
./repairmysql.sh nagios
service mysqld start
service ndoutils start
service mysqld start
Re: No host/service details in any of the Views
Posted: Thu Apr 05, 2012 10:05 am
by jglass
The database repair was the trick! Lots of indexes were repaired and everything is back online. Thank You!!
I believe the cause of this may have been due to our vmware host server being restarted before shutting down the nagios Vm.
Thanks again for everyone's input!
Jason
Re: No host/service details in any of the Views
Posted: Thu Apr 05, 2012 12:08 pm
by scottwilkerson
jglass wrote:I believe the cause of this may have been due to our vmware host server being restarted before shutting down the nagios Vm.
I would say you are probably right, MySQL doesn't like it when the plug is pulled out from under it when it is writing to disk...