Event Log Not Showing

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
rentsys
Posts: 98
Joined: Wed Oct 16, 2013 11:57 am

Event Log Not Showing

Post by rentsys »

The event log isn't showing up.
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: Event Log Not Showing

Post by tmcdonald »

We're going to need a lot more info than that.

What version of XI are you running?
What OS and version is it running on?
Is it not showing up at all? Or is it just blank?
Are you looking at the right time period?
Do you see anything in /var/log/httpd/error_log?

tail -20 /var/log/httpd/error_log
Former Nagios employee
rentsys
Posts: 98
Joined: Wed Oct 16, 2013 11:57 am

Re: Event Log Not Showing

Post by rentsys »

Nagios XI 2012R2.9

Code: Select all

[root@blvmmon ~]# uname -a
Linux blvmmon.rdr.pvt 2.6.32-431.3.1.el6.i686 #1 SMP Fri Jan 3 18:53:30 UTC 2014 i686 i686 i386 GNU/Linux
It is blank.
I am looking at the right time period.

Code: Select all

[root@blvmmon ~]# tail -20 /var/log/httpd/error_log
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 110, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 115, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 116, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 117, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 118, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 119, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 120, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 105, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 106, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 107, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 108, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 109, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 110, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 115, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 116, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 117, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 118, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 119, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:50:01 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 120, referer: http://10.149.149.38/nagiosxi/includes/components/ccm/xi-index.php
[Tue Apr 01 15:54:48 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined index: developer in /usr/local/nagiosxi/html/admin/updates.php on line 247, referer: http://10.149.149.38/nagiosxi/admin/updates.php
I also noticed that if i cat the log file i get this

Code: Select all

No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
sreinhardt
-fno-stack-protector
Posts: 4366
Joined: Mon Nov 19, 2012 12:10 pm

Re: Event Log Not Showing

Post by sreinhardt »

Are you referring to the core\XI event log, an snmp event log, or something else? I'm not sure what specifically you are referring to, but it seems to have something to do with snmp due to the ipv6 mib error. Could you post the commands that you are running to see that error? A much more detailed idea of what you feel is not logging and where you are expecting it to log would be much appreciated.
Nagios-Plugins maintainer exclusively, unless you have other C language bugs with open-source nagios projects, then I am happy to help! Please pm or use other communication to alert me to issues as I no longer track the forum.
rentsys
Posts: 98
Joined: Wed Oct 16, 2013 11:57 am

Re: Event Log Not Showing

Post by rentsys »

The Event log under Monitoring processes.
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: Event Log Not Showing

Post by abrist »

Are you rotating the nagios logs in a non-standard way?
Pull up the event log, set some overly broad search criteria, submit it, and then get a long tail of:

Code: Select all

tail -50 /var/log/httpd/error_log
tail 25 /var/log/messages
Looking at your previous log, you could be timing out if the nagios_logentries table and the nagios.log files are too large. Increase the php.ini limits:
http://support.nagios.com/wiki/index.ph ... _Completes
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
rentsys
Posts: 98
Joined: Wed Oct 16, 2013 11:57 am

Re: Event Log Not Showing

Post by rentsys »

Code: Select all

[root@blvmmon ~]# tail -50 /var/log/httpd/error_log
[Tue Apr 01 16:05:11 2014] [error] [client 10.160.1.70] PHP Notice:  Undefined variable: dashletmode in /usr/local/nagiosxi/html/includes/components/xicore/dashlets-perfdata.inc.php on line 182, referer: http://10.149.149.38/nagiosxi/perfgraphs/?&host=10.148.27.2&service=_HOST_&source=1&view=1&start=&end=&startdate=&enddate=&mode=2&host_id=315
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
[Wed Apr 02 14:04:26 2014] [notice] caught SIGTERM, shutting down
No log handling enabled - turning on stderr logging
Cannot find module (IPV6-UDP-MIB): At line 0 in (none)
[Wed Apr 02 14:04:27 2014] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Wed Apr 02 14:04:27 2014] [notice] Digest: generating secret for digest authentication ...
[Wed Apr 02 14:04:27 2014] [notice] Digest: done
[Wed Apr 02 14:04:28 2014] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.0-fips configured -- resuming normal operations
[root@blvmmon ~]# tail -25 /var/log/messages
Apr  2 14:06:55 blvmmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Apr  2 14:07:05 blvmmon nagios: Warning: Check result queue contained results for host '10.150.50.5', but the host could not be found!  Perhaps you forgot to define the host in your config files?
Apr  2 14:07:05 blvmmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1396465625), entry_time=FROM_UNIXTIME(1396465625), entry_time_usec='437875', logentry_type='2', logentry_data='Warning: Check result queue contained results for host \'10\.150\.50\.5\', but the host could not be found!  Perhaps you forgot to define the host in your config files\?', realtime_data='1', inferred_data_extracted='1''
Apr  2 14:07:05 blvmmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Apr  2 14:07:05 blvmmon nagios: Warning: Check result queue contained results for host '10.150.50.5', but the host could not be found!  Perhaps you forgot to define the host in your config files?
Apr  2 14:07:05 blvmmon nagios: Warning: Check result queue contained results for service 'NetBIOS' on host '10.160.1.65', but the service could not be found!  Perhaps you forgot to define the service in your config files?
Apr  2 14:07:05 blvmmon nagios: Warning: Check result queue contained results for service 'NetBIOS' on host '10.160.1.65', but the service could not be found!  Perhaps you forgot to define the service in your config files?
Apr  2 14:07:05 blvmmon nagios: Warning: Check result queue contained results for service 'RDP' on host '10.150.50.20', but the service could not be found!  Perhaps you forgot to define the service in your config files?
Apr  2 14:07:05 blvmmon nagios: Warning: Check result queue contained results for service 'Datastore usage for VMHost' on host 'daSerenaESXi', but the service could not be found!  Perhaps you forgot to define the service in your config files?
Apr  2 14:07:05 blvmmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1396465625), entry_time=FROM_UNIXTIME(1396465625), entry_time_usec='469634', logentry_type='2', logentry_data='Warning: Check result queue contained results for host \'10\.150\.50\.5\', but the host could not be found!  Perhaps you forgot to define the host in your config files\?', realtime_data='1', inferred_data_extracted='1''
Apr  2 14:07:05 blvmmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Apr  2 14:07:05 blvmmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1396465625), entry_time=FROM_UNIXTIME(1396465625), entry_time_usec='471103', logentry_type='2', logentry_data='Warning: Check result queue contained results for service \'NetBIOS\' on host \'10\.160\.1\.65\', but the service could not be found!  Perhaps you forgot to define the service in your config files\?', realtime_data='1', inferred_data_extracted='1''
Apr  2 14:07:05 blvmmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Apr  2 14:07:05 blvmmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1396465625), entry_time=FROM_UNIXTIME(1396465625), entry_time_usec='473417', logentry_type='2', logentry_data='Warning: Check result queue contained results for service \'NetBIOS\' on host \'10\.160\.1\.65\', but the service could not be found!  Perhaps you forgot to define the service in your config files\?', realtime_data='1', inferred_data_extracted='1''
Apr  2 14:07:05 blvmmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Apr  2 14:07:05 blvmmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1396465625), entry_time=FROM_UNIXTIME(1396465625), entry_time_usec='475565', logentry_type='2', logentry_data='Warning: Check result queue contained results for service \'RDP\' on host \'10\.150\.50\.20\', but the service could not be found!  Perhaps you forgot to define the service in your config files\?', realtime_data='1', inferred_data_extracted='1''
Apr  2 14:07:05 blvmmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Apr  2 14:07:05 blvmmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1396465625), entry_time=FROM_UNIXTIME(1396465625), entry_time_usec='481624', logentry_type='2', logentry_data='Warning: Check result queue contained results for service \'Datastore usage for VMHost\' on host \'daSerenaESXi\', but the service could not be found!  Perhaps you forgot to define the service in your config files\?', realtime_data='1', inferred_data_extracted='1''
Apr  2 14:07:05 blvmmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Apr  2 14:07:15 blvmmon nagios: Warning: Check result queue contained results for service 'RDP' on host '10.150.50.20', but the service could not be found!  Perhaps you forgot to define the service in your config files?
Apr  2 14:07:15 blvmmon nagios: Warning: Check result queue contained results for service 'Datastore usage for VMHost' on host 'daSerenaESXi', but the service could not be found!  Perhaps you forgot to define the service in your config files?
Apr  2 14:07:15 blvmmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1396465635), entry_time=FROM_UNIXTIME(1396465635), entry_time_usec='151983', logentry_type='2', logentry_data='Warning: Check result queue contained results for service \'RDP\' on host \'10\.150\.50\.20\', but the service could not be found!  Perhaps you forgot to define the service in your config files\?', realtime_data='1', inferred_data_extracted='1''
Apr  2 14:07:15 blvmmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Apr  2 14:07:15 blvmmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1396465635), entry_time=FROM_UNIXTIME(1396465635), entry_time_usec='153385', logentry_type='2', logentry_data='Warning: Check result queue contained results for service \'Datastore usage for VMHost\' on host \'daSerenaESXi\', but the service could not be found!  Perhaps you forgot to define the service in your config files\?', realtime_data='1', inferred_data_extracted='1''
Apr  2 14:07:15 blvmmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
[root@blvmmon ~]#
I noticed that the error log said

Code: Select all

mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
so I found this http://assets.nagios.com/downloads/nagi ... tabase.pdf I did what the pdf said to do and it worked. My problem is fixed. This can be closed.
Locked