Database Maintenance ??

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
hhlodge
Posts: 206
Joined: Tue Mar 08, 2011 2:13 pm

Database Maintenance ??

Post by hhlodge »

My system status page under Admin has a red "bang" icon on Database Maintenance with a mouse-over saying it hasn't run in 4+ days. I read the database optimization and repair manuals and forum search all show nothing about this. crond is running so if something is suppose to happen there, it should. What needs to be done? Here's a screenshot..
Admin.png
You do not have the required permissions to view the files attached to this post.
- Kyle
hhlodge
Posts: 206
Joined: Tue Mar 08, 2011 2:13 pm

Re: Database Maintenance ??

Post by hhlodge »

After a bit of digging, I found this error.

[root@psm-itmon log]# cat /usr/local/nagiosxi/var/dbmaint.log
LOCKFILE '/usr/local/nagiosxi/var/dbmaint.lock' IS OLD - REMOVING
PHP Fatal error: Call to undefined function unlinke() in /usr/local/nagiosxi/cron/dbmaint.php on line 30

So I changed unlinke to unlink, ran this job I found in /var/log/cron

/usr/bin/php -q /usr/local/nagiosxi/cron/dbmaint.php > /usr/local/nagiosxi/var/dbmaint.log 2>&1

and the LED has gone to green.
- Kyle
tonyyarusso
Posts: 1128
Joined: Wed Mar 03, 2010 12:38 pm
Location: St. Paul, MN, USA
Contact:

Re: Database Maintenance ??

Post by tonyyarusso »

Thanks for the report! Turns out someone else stumbled across this as well, and it is now fixed in the code trunk for inclusion in the next point release.
Tony Yarusso
Technical Services
___
TIES
Web: http://ties.k12.mn.us/
Locked