Monitoring Engine Process / Event Queue are empy

[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

[mguthrie]

Are either of these systems using SSL, NAT, or proxy?

[kariroman]

No, nothing of that

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

[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

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

[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

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

[kariroman]

Hi, yes, mysql database is offloaded accordance with the manual provided by Nagios. What CCM variables you want to take a look at?

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