Page 1 of 2
Monitoring Engine Process / Event Queue are empy
Posted: Thu Sep 22, 2011 3:47 am
by kariroman
We have two identical installs of Nagios XI (CentOS 5.7 XI 2011 R1.7) expet for the fact that machine Nr 1 was downloaded as vmware virtual machine but Nr 2 is installed on hardware. On machine Nr1 Monitoring Engine Process / Event Queue dashlets doesn´t return any data (see attached screenshot) but everything work on another. Also system status indicators are 3 on the 1st system (with empty dashlets) but they are 6 on another. Is it possible to research/fix it?
Regards, Kári
Re: Monitoring Engine Process / Event Queue are empy
Posted: Thu Sep 22, 2011 11:06 am
by mguthrie
Are either of these systems using SSL, NAT, or proxy?
Re: Monitoring Engine Process / Event Queue are empy
Posted: Thu Sep 22, 2011 11:09 am
by kariroman
No, nothing of that
Re: Monitoring Engine Process / Event Queue are empy
Posted: Thu Sep 22, 2011 11:17 am
by mguthrie
Can you run:
Code: Select all
rm -f /usr/local/nagiosxi/var/dbmaint.lock
/usr/local/nagiosxi/cron/dbmaint.php
And post the output? I'd like to verify that there isn't data corruption on the DB backend.
Re: Monitoring Engine Process / Event Queue are empy
Posted: Fri Sep 23, 2011 4:21 am
by kariroman
Code: Select all
/usr/local/nagiosxi/cron/dbmaint.php
CREATING: /usr/local/nagiosxi/var/dbmaint.lock
CLEANING ndoutils TABLE 'commenthistory'...
SQL: DELETE FROM nagios_commenthistory WHERE entry_time < FROM_UNIXTIME(1285233644)
CLEANING ndoutils TABLE 'processevents'...
SQL: DELETE FROM nagios_processevents WHERE event_time < FROM_UNIXTIME(1285233644)
CLEANING ndoutils TABLE 'externalcommands'...
SQL: DELETE FROM nagios_externalcommands WHERE entry_time < FROM_UNIXTIME(1316164844)
CLEANING ndoutils TABLE 'logentries'...
SQL: DELETE FROM nagios_logentries WHERE logentry_time < FROM_UNIXTIME(1285233644)
CLEANING ndoutils TABLE 'notifications'...
SQL: DELETE FROM nagios_notifications WHERE start_time < FROM_UNIXTIME(1308993644)
CLEANING ndoutils TABLE 'contactnotifications'...
SQL: DELETE FROM nagios_contactnotifications WHERE start_time < FROM_UNIXTIME(1308993644)
CLEANING ndoutils TABLE 'contactnotificationmethods'...
SQL: DELETE FROM nagios_contactnotificationmethods WHERE start_time < FROM_UNIXTIME(1308993644)
CLEANING ndoutils TABLE 'statehistory'...
SQL: DELETE FROM nagios_statehistory WHERE state_time < FROM_UNIXTIME(1253697644)
CLEANING ndoutils TABLE 'timedevents'...
SQL: DELETE FROM nagios_timedevents WHERE event_time < FROM_UNIXTIME(1316769344)
CLEANING ndoutils TABLE 'systemcommands'...
SQL: DELETE FROM nagios_systemcommands WHERE start_time < FROM_UNIXTIME(1316769344)
CLEANING ndoutils TABLE 'servicechecks'...
SQL: DELETE FROM nagios_servicechecks WHERE start_time < FROM_UNIXTIME(1316769344)
CLEANING ndoutils TABLE 'hostchecks'...
SQL: DELETE FROM nagios_hostchecks WHERE start_time < FROM_UNIXTIME(1316769344)
CLEANING ndoutils TABLE 'eventhandlers'...
SQL: DELETE FROM nagios_eventhandlers WHERE start_time < FROM_UNIXTIME(1316769344)
LASTOPT: 1316768103
INTERVAL: 60
NOW: 1316769644
OPTTIME: 1316771703
CLEANING nagiosxi TABLE 'commands'...
SQL: DELETE FROM xi_commands WHERE processing_time < 1316740844::abstime::timestamp without time zone
CLEANING nagiosxi TABLE 'events'...
SQL: DELETE FROM xi_events WHERE processing_time < 1316740844::abstime::timestamp without time zone
SQL1: SELECT xi_meta.meta_id FROM xi_meta LEFT JOIN xi_events ON xi_meta.metaobj_id=xi_events.event_id WHERE metatype_id='1' AND event_id IS NULL
SQL2: DELETE FROM xi_meta WHERE meta_id IN (SELECT xi_meta.meta_id FROM xi_meta LEFT JOIN xi_events ON xi_meta.metaobj_id=xi_events.event_id WHERE metatype_id='1' AND event_id IS NULL)
CLEANING nagiosql TABLE 'logbook'...
SQL: DELETE FROM tbl_logbook WHERE time < FROM_UNIXTIME(1316740844)
Repair Complete: Removing Lock File
Re: Monitoring Engine Process / Event Queue are empy
Posted: Fri Sep 23, 2011 9:18 am
by mguthrie
The database looks ok.
Do you have a file: /usr/local/nagiosxi/var/load_url.log on the system that's having an issue. If the file was created can you post it?
Also, are you using a DNS name to access the problematic server, or an IP address? If it's a DNS name, have you created a DNS entry in the /etc/hosts file for it?
Re: Monitoring Engine Process / Event Queue are empy
Posted: Fri Sep 23, 2011 9:53 am
by kariroman
1. /etc/hosts includes IP and hostname
2. I´m using hostname but also have tried IP - it changed nothing
3. /usr/local/nagiosxi/var/load_url.log is quite big, so I´ve it to archive it and attached to the message
Re: Monitoring Engine Process / Event Queue are empy
Posted: Fri Sep 23, 2011 12:16 pm
by nscott
kariroman,
Is this the same server that you are running with an offloaded MySQL database? Offloading the MySQL database without updating the the proper variables in the CCM can cause issues such as this.
Re: Monitoring Engine Process / Event Queue are empy
Posted: Sun Sep 25, 2011 5:59 am
by kariroman
Hi, yes, mysql database is offloaded accordance with the manual provided by Nagios. What CCM variables you want to take a look at?
Re: Monitoring Engine Process / Event Queue are empy
Posted: Mon Sep 26, 2011 9:37 am
by mguthrie
Can you try resetting your subsystem credentials from the Admin->Reset Security Credentials page? It looks like you're getting a 401 (unauthorized) error for that data.