Event log on home page not working..

[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

[scottwilkerson]

What do you get with this?

Code: Select all

tail /var/log/mysqld.log

[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

[scottwilkerson]

I thought that might be the problem, please repair the databases with the following instructions:

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

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

[scottwilkerson]

Glad to hear the issue is solved