Librenms: Directly querying mysql database
You can troubleshoot librenms alert rules directly inside of the mysql database.
To enter librenms mysql database, as root launch mysql, then enter the librenms database.
mysql
use librenms;
From here you can get your device ID, and then querry against that device. Alert rules use a ?, you have to replace this. ? is usually in place of a device id.
SELECT device_id, hostname FROM devices;
SELECT * FROM devices,services WHERE (devices.device_id = 61 AND devices.device_id = services.device_id) \G;
Full output
root@vm-librenms ~ # mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 46591
Server version: 10.11.6-MariaDB-0+deb12u1-log Debian 12
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> USE librenms;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [librenms]> SELECT device_id, hostname FROM devices;
+-----------+------------------------------+
| device_id | hostname |
+-----------+------------------------------+
| 61 | imail04.bnt.com |
+-----------+------------------------------+
1 row in set (0.001 sec)
MariaDB [librenms]> SELECT * FROM devices,services WHERE (devices.device_id = 61 AND devices.device_id = services.device_id) \G;
*************************** 1. row ***************************
device_id: 61
inserted: 2024-06-19 10:23:32
hostname: mail
sysName: mail_example
display: NULL
ip: 192.168.0.29
overwrite_ip:
community: NULL
authlevel: NULL
authname: NULL
authpass: NULL
authalgo: NULL
cryptopass: NULL
cryptoalgo: NULL
snmpver: v2c
port: 161
transport: udp
timeout: NULL
retries: NULL
snmp_disable: 1
bgpLocalAs: NULL
sysObjectID: NULL
sysDescr: NULL
sysContact: NULL
version: NULL
hardware:
features: NULL
location_id: NULL
os: windows
status: 1
status_reason:
ignore: 0
disabled: 0
uptime: NULL
agent_uptime: 0
last_polled: 2025-02-25 10:51:15
last_poll_attempted: NULL
last_polled_timetaken: 1.3264119625092
last_discovered_timetaken: 0
last_discovered: 2025-02-25 07:50:23
last_ping: 2025-02-25 10:51:15
last_ping_timetaken: 251
purpose: Server 2019
type: server
serial: NULL
icon: NULL
poller_group: 0
override_sysLocation: 0
notes: NULL
port_association_mode: 3
max_depth: 0
disable_notify: 0
ignore_status: 0
service_id: 2
device_id: 61
service_ip: 192.168.1.29
service_type: smtp
service_desc: Check if SMTP is alive
service_param:
service_ignore: 0
service_status: 0
service_changed: 1739752202
service_message: SMTP OK - 0.262 sec. response time
service_disabled: 0
service_ds: {"time":"s"}
service_template_id: 0
service_name: imail04 SMTP check
1 rows in set (0.001 sec)
MariaDB [librenms]>