Nagiosxi tables

[lamin]

so why can i see some data in those tables?

[mguthrie]

I was reviewing the code, and those reports might actually draw from a different table for the availability and state history.

One other possibility that crossed by mind was checking for a time-syncing issue. If the PHP timezone settings were off, it's possible that the database maintenance script keeps pruning all of the data from it. In the Admin->Performance Settings->Database(tab) are the settings for how often that table should be trimmed. It's possible that if the time was out of sync somewhere it could be clearing all of the data on a regular basis.

Apart from that though, the only idea I can think of would be to rebuild those two tables. Thoughts?

[lamin]

ok, i remember changing some of those numbers because of disk space, however, attached are the screenshots for the current configuration. I guess I need to put them in default but i dont remember the default settings for the database. I really do not want to rebuild those tables because this server is real time production.

[mguthrie]

Just for testing purposes, can you crank up the numbers on the "host checks" and "service checks" table to 300 and see if the table starts to populate.

Also, lets make sure the system time is up to date.

Code: Select all

yum install ntp
ntpdate pool.ntp.org

And then take a look at your php settings for timezone and make sure that is set. This wiki post is for a different issue, but the solution is the same:
http://support.nagios.com/wiki/index.ph ... e.22_Error

[lamin]

I increase those numbers to 300 and i do a select statement but it still saying empty. by the way i restarted mysqld service. The time and date is correct.

[mguthrie]

Hey what version of XI is this system running?

[lamin]

Nagios XI 2011R1.1 Copyright © 2008-2011 Nagios Enterprises, LLC.

[mguthrie]

Ahh, ok. 1.1 had a patch to ndoutils to stop sending data to those tables. However, we realized that broke the check statistics, so all versions after that have that patch reverted. I would also suggest upgrading because 1.1 had a more serious bug in it that created a higher potential for DB corruption.

[lamin]

upgrade to what version and can you send me the step to updating nagios to the latest greatest stable version.

Thanks

[mguthrie]

The follow doc will cover an upgrade to the latest stable version.
http://assets.nagios.com/downloads/nagi ... ctions.pdf