Page 1 of 1

Event log on home page not working..

Posted: Fri Jun 22, 2018 9:43 am
by rjmon
Home -> Montioring Process -> Event log

Tried last 24 hours, last month, last week NO data is showing from it.


------------------------------------------------------------------------------------------------------
A system profile makes it easier for our support techs to understand the system that you are running on. Including a downloaded system profile with your support ticket is always a good idea.


Nagios XI - System Info
System:
Nagios XI Version : 5.4.7
nagio02aplqa.rjf.com 3.10.0-862.3.3.el7.x86_64 x86_64
Red Hat Enterprise Linux Server release 7.5 (Maipo)
Gnome is not installed
Apache Information
PHP Version: 5.4.16
Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
Server Name: nagiosqa.rjf.com
Server Address: 10.97.0.166
Server Port: 443
Date/Time
PHP Timezone: US/Eastern
PHP Time: Fri, 22 Jun 2018 10:40:57 -0400
System Time: Fri, 22 Jun 2018 10:40:57 -0400
Nagios XI Data
License ends in: TMOTNN

nagios (pid 73402) is running...
NPCD running (pid 13405).
ndo2db (pid 13489) is running...
CPU Load 15: 2.23
Total Hosts: 765
Total Services: 4205
Function 'get_base_uri' returns: https://nagiosqa.rjf.com/nagiosxi/
Function 'get_base_url' returns: https://nagiosqa.rjf.com/nagiosxi/
Function 'get_backend_url(internal_call=false)' returns: https://nagiosqa.rjf.com/nagiosxi/inclu ... rofile.php
Function 'get_backend_url(internal_call=true)' returns: http://localhost/nagiosxi/back

Re: Event log on home page not working..

Posted: Fri Jun 22, 2018 10:29 am
by scottwilkerson
What do you get with this?

Code: Select all

tail /var/log/mysqld.log

Re: Event log on home page not working..

Posted: Fri Jun 22, 2018 12:17 pm
by rjmon

Code: Select all

nagadm@nagio02aplqa ~]$ sudo tail -f /var/log/mariadb/mariadb.log
[sudo] password for nagadm:
180622 13:15:02 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180622 13:15:15 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180622 13:15:26 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180622 13:15:26 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180622 13:15:26 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180622 13:15:26 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180622 13:15:26 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180622 13:15:26 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180622 13:16:06 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed
180622 13:16:06 [ERROR] mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed

Re: Event log on home page not working..

Posted: Fri Jun 22, 2018 12:55 pm
by scottwilkerson
I thought that might be the problem, please repair the databases with the following instructions:

https://assets.nagios.com/downloads/nag ... tabase.pdf

Re: Event log on home page not working..

Posted: Mon Jun 25, 2018 8:47 am
by rjmon
The issue is resolved. I tried the repair it did`nt work because database cannot be stopped via "systemctl stop mariadb.service". I have to kill and restart the service. That resolved it. Thanks again.

Re: Event log on home page not working..

Posted: Mon Jun 25, 2018 9:04 am
by scottwilkerson
Glad to hear the issue is solved