No data Reports/Event log

[tatka]

Hi, after installing the 1.5 update does not work in writing Reports - Event logs. Please help. Petr

[lmiltchev]

Can you run the following command in terminal and post the output?

# ls -l /usr/local/nagios/var/nagios.log

[tatka]

-rw-r--r-- 1 nagios nagios 6340400 Jul 20 15:06 /usr/local/nagios/var/nagios.log

[lmiltchev]

Your permissions of the "nagios.log" file look OK, so let's dig a little deeper...
Did you activate your license after the upgrade to 1.5?
Can you send us a little bit more info on the exact problem you are having, such as steps to recreate it, error messages (in any)?
Please, send us a screenshot, so we can take a look at it.

[tatka]

We have not activated the license.
Before updating to 1.5 in the event log pile data. What should I check?

[lmiltchev]

Are you using ssl?

[tatka]

No not connecting using SSL. Even over https not get data from event log. Any other suggestions?

[mguthrie]

I'm wondering if there is some table corruption for that particular table. Can you post the output from the following?

Code: Select all

cd /usr/local/nagiosxi/cron
rm -f ../dbmaint.lock
./dbmaint.php

If you get any messages about data or table corruption, run the repair procedure outlined in the below document.
http://library.nagios.com/library/produ ... i-database

[tatka]

send an extract from the. / dbmaint.php after repair MySQL:

CREATING: /usr/local/nagiosxi/var/dbmaint.lock
CLEANING ndoutils TABLE 'commenthistory'...
SQL: DELETE FROM nagios_commenthistory WHERE entry_time < FROM_UNIXTIME(1280047164)
CLEANING ndoutils TABLE 'processevents'...
SQL: DELETE FROM nagios_processevents WHERE event_time < FROM_UNIXTIME(1280047164)
CLEANING ndoutils TABLE 'externalcommands'...
SQL: DELETE FROM nagios_externalcommands WHERE entry_time < FROM_UNIXTIME(1310978364)
CLEANING ndoutils TABLE 'logentries'...
SQL: DELETE FROM nagios_logentries WHERE logentry_time < FROM_UNIXTIME(1303807164)
SQL: SQL Error [ndoutils] :</b> Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failedCLEANING ndoutils TABLE 'notifications'...
SQL: DELETE FROM nagios_notifications WHERE start_time < FROM_UNIXTIME(1303807164)
CLEANING ndoutils TABLE 'contactnotifications'...
SQL: DELETE FROM nagios_contactnotifications WHERE start_time < FROM_UNIXTIME(1303807164)
CLEANING ndoutils TABLE 'contactnotificationmethods'...
SQL: DELETE FROM nagios_contactnotificationmethods WHERE start_time < FROM_UNIXTIME(1303807164)
CLEANING ndoutils TABLE 'statehistory'...
SQL: DELETE FROM nagios_statehistory WHERE state_time < FROM_UNIXTIME(1248511164)
CLEANING ndoutils TABLE 'timedevents'...
SQL: DELETE FROM nagios_timedevents WHERE event_time < FROM_UNIXTIME(1311582864)
CLEANING ndoutils TABLE 'systemcommands'...
SQL: DELETE FROM nagios_systemcommands WHERE start_time < FROM_UNIXTIME(1311582864)
CLEANING ndoutils TABLE 'servicechecks'...
SQL: DELETE FROM nagios_servicechecks WHERE start_time < FROM_UNIXTIME(1311582864)
CLEANING ndoutils TABLE 'hostchecks'...
SQL: DELETE FROM nagios_hostchecks WHERE start_time < FROM_UNIXTIME(1311582864)
CLEANING ndoutils TABLE 'eventhandlers'...
SQL: DELETE FROM nagios_eventhandlers WHERE start_time < FROM_UNIXTIME(1311582864)
LASTOPT: 1311581105
INTERVAL: 60
NOW: 1311583164
OPTTIME: 1311584705
CLEANING nagiosxi TABLE 'commands'...
SQL: DELETE FROM xi_commands WHERE processing_time < 1311554364::abstime::timestamp without time zone
CLEANING nagiosxi TABLE 'events'...
SQL: DELETE FROM xi_events WHERE processing_time < 1311554364::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(1311554364)
Repair Complete: Removing Lock File

event log still does not work

[tatka]

Sorry. I cleaned the table nagios_logentries and event log started work . Thank you very much for your help .....