Page 1 of 4
Nagiosxi tables
Posted: Fri Dec 02, 2011 2:34 pm
by lamin
Hey guys,
My nagiosxi table (nagios_servicechecks) is empty and I want to know is it the way it suppose to be.
Thanks
Re: Nagiosxi tables
Posted: Fri Dec 02, 2011 2:48 pm
by mguthrie
Try running the database repair procedure, you might have corruption in that table.
http://assets.nagios.com/downloads/nagi ... tabase.pdf
Re: Nagiosxi tables
Posted: Mon Dec 05, 2011 8:44 am
by lamin
i did run the script to repair the database and it was complete successfully, however, i am still not seeing data in the nagios_servicechecks table.
Re: Nagiosxi tables
Posted: Mon Dec 05, 2011 10:20 am
by mguthrie
Can you post the output from the following?
Code: Select all
cd /usr/local/nagiosxi/scripts
rm -f ../var/dbmaint.lock
./dbmaint.php
Re: Nagiosxi tables
Posted: Mon Dec 05, 2011 10:33 am
by lamin
Do you want me to run the command above?
By the way I did not see DBmaint.php command in the scripts directory.
Re: Nagiosxi tables
Posted: Mon Dec 05, 2011 10:42 am
by mguthrie
Oops, sorry about that. Wrong directory.
Code: Select all
cd /usr/local/nagiosxi/cron
rm -f ../var/dbmaint.lock
./dbmaint.php
Re: Nagiosxi tables
Posted: Mon Dec 05, 2011 10:45 am
by lamin
there is no dbmaint.lock in the cron directory.
my nagios_servicechecks and nagios_hostchecks tables still did not get any data. is that normal or is there a solution for it?
Re: Nagiosxi tables
Posted: Tue Dec 06, 2011 10:20 am
by mguthrie
there is no dbmaint.lock in the cron directory.
Indeed, the dbmaint.lock file is located in /usr/local/nagiosxi/var, hence the "../var"
my nagios_servicechecks and nagios_hostchecks tables still did not get any data
We still need to see the
output from that script.
I would also suggest running the following:
Code: Select all
service mysqld stop
myisamchk -r -f /var/lib/mysql/nagios_*.MYI
service mysqld start
service nagios restart
service ndo2db restart
Re: Nagiosxi tables
Posted: Tue Dec 06, 2011 11:44 am
by lamin
Here is the output of the repaimysql.sh script. As you see it went successful but I am still not seeing data.
Re: Nagiosxi tables
Posted: Tue Dec 06, 2011 12:47 pm
by mguthrie
What I need to know is whether or not the repair run is actually succeeding. The way that I can identify that is by seeing the output from the below commands:
Code: Select all
cd /usr/local/nagiosxi/cron
rm -f ../var/dbmaint.lock
./dbmaint.php
The above message is the output from the actual repair run, which doesn't always succeed.