I have one device (Debian Linux server) that has no Event Log at all.
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.
./validate.php and also run
SELECT COUNT(*) FROM eventlog;
$ cd /opt/librenms
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
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
([email protected]:librenms) mysql> select count(*) from eventlog;
| count(*) |
| 428 |
1 row in set (0.00 sec)
Can you check
logs/librenms.log to see if there are any bad queries in there related to eventlog and post them?
$ grep -c eventlog /opt/librenms/logs/librenms.log*
Are you sure there should be any events for this device? Remember the eventlog is purged after a period of time.
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.
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.