No host/service details in any of the Views

[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

[scottwilkerson]

Are you logged in as the nagiosadmin?

[jglass]

Yes.

[scottwilkerson]

First can we verify that on
Admin -> XI System Component Status
everything is green.

If that is the case, can you run

Code: Select all

tail -f /var/log/httpd/error_log

And report any recent errors

[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

[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:

Code: Select all

 date.timezone = Etc/GMT-13

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:

Code: Select all

 service httpd restart

[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.

[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

[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

[scottwilkerson]

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...