Event Log stopped working -- no events listed

[murdock]

Home > Monitoring Process > Event Log >
Select any Period and click Run; headers display but no data.

I've searched the KB and found nothing applicable.

I searched forums...

Nagios XI Event Log Empty
https://support.nagios.com/forum/viewto ... +Log+Empty

Nagios Event Log Empty
https://support.nagios.com/forum/viewto ... +Log+Empty

One suggestion was to run the repair databases script:
/usr/local/nagiosxi/scripts/repair_databases.sh
...however, this did not fix the problem.

In reference to
"Tip: How To Get Fast Resolution To Your XI Issues"
https://support.nagios.com/forum/viewto ... =16&t=1273

1. Linux Distribution and version?
cat /etc/*release* | head -1
CentOS release 6.9 (Final)

2. 32 or 64bit?
uname -a
Linux ... 2.6.32-754.el6.x86_64 #1 SMP Tue Jun 19 21:26:04 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

3. VMware Image or Manual Install of XI?
Manual

4.1 Are there special configurations on your system?
No, nothing special I can think of.

4.2 Is Gnome installed?
CentOS "minimal" (no GUI) but many gnome libraries installed to satisfy package dependencies.

4.3 Are you using a proxy?
No.

4.4 Are you using SSL?
Yes.

5. If you are encountering multiple issues that may not be related, start a thread for each issue
Just this one issue.

Admin > System Config > System Profile output is attached.

[scottwilkerson]

There was no attachment but one possibility is a corrupt database.

Run

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

IF that doesn't work, please PM profile.zip

[murdock]

Sorry, I forgot to upload the attachment on the initial submission; I've attached it to this reply.

As I mentioned, I ran the database repair script but that did not fix the problem.

I should mention that I did do the PostgreSQL conversion / removal procedure, and the Event Log problem appeared shortly after.
https://support.nagios.com/kb/article.php?id=560

However, this is the 4th time I've removed PostgreSQL in XI and I did not have this problem on the other servers.

I don't suppose there is any documentation that explains which [PostgreSQL?] table(s) the Event Log records are in so I can extract them from a backup...? Still, I would have expected new events from MySQL...

Rob

[murdock]

PS, I do not have the option to PM; the FAQ says I need to have an Admin enable that option (but I can't PM to make the reqeust?)...

[scottwilkerson]

You should be able to PM now.

Looking at the submitted profile I see there was crashed tables in your mysqld.log file and it was the nagios_logentries table that was affected.

It does however look like the repair may have fixed that issue, is the event log still blank?

I don't suppose there is any documentation that explains which [PostgreSQL?] table(s) the Event Log records are in so I can extract them from a backup...? Still, I would have expected new events from MySQL...

The event log has always been in MySQL, so there is nothing to extract.