One of my servers has no Event Log

Help
1

I have one device (Debian Linux server) that has no Event Log at all.
I ran select distinct device_id from eventlog; on the database and there’s nothing there.

Any ideas how I could further debug this issue?

My LibreNMS installation is up to date with no validate errors and the server in question is identical (OS, snmp settings etc.) to several others that don’t have this issue.

2

./validate.php and also run SELECT COUNT(*) FROM eventlog;

3 
$ cd /opt/librenms
$ ./validate.php 
====================================
Component | Version
--------- | -------
LibreNMS  | 1.33
DB Schema | 213
PHP       | 5.6.31-1~dotdeb+7.1
MySQL     | 5.5.58-0+deb7u1
RRDTool   | 1.4.7
SNMP      | NET-SNMP 5.4.3
====================================

[OK]    Database connection successful
[OK]    Database schema correct
[WARN]  Your local git contains modified files, this could prevent automatic updates.
	[FIX] You can fix this with ./scripts/github-remove
	Modified Files:
	 html/includes/common/availability-map.inc.php
	 html/includes/graphs/application/postfix_rejects.inc.php
	 html/includes/print-menubar.php
	 html/pages/device/overview/services.inc.php
	 includes/polling/applications/nginx.inc.php
	 includes/polling/applications/postfix.inc.php

The changed files are to be expected, those are either PRs that are not merged (yet), or local changes that I made for layout purposes or special needs.

$ mysql librenms

(root@localhost:librenms) mysql> select count(*) from eventlog;
+----------+
| count(*) |
+----------+
|      428 |
+----------+
1 row in set (0.00 sec)
4

Can you check logs/librenms.log to see if there are any bad queries in there related to eventlog and post them?

5

Nope, nothing:

$ grep -c eventlog /opt/librenms/logs/librenms.log*
/opt/librenms/logs/librenms.log:0
/opt/librenms/logs/librenms.log.1:0
/opt/librenms/logs/librenms.log.2.gz:0
/opt/librenms/logs/librenms.log.3.gz:0
/opt/librenms/logs/librenms.log.4.gz:0
/opt/librenms/logs/librenms.log.5.gz:0
/opt/librenms/logs/librenms.log.6.gz:0
6

Are you sure there should be any events for this device? Remember the eventlog is purged after a period of time.

7

Yes, it is one of the VMs on a Proxmox host and a recent reboot of the host machine triggered event messages for all of them, except this one.

8

I’d say try to trigger another event and then run the poller with debug to see what is going on.

I’d say initially it wouldn’t have to be the same event, but might have to be to narrow down the issue.