Nagios Support Forum

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

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

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

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

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.

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

Are you using ssl?

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

I'm wondering if there is some table corruption for that particular table. Can you post the output from the following?
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

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

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