I have LibreNMS installation and validation is OK:
====================================
Component | Version
--------- | -------
LibreNMS | 1.42-3-g5b24934
DB Schema | 257
PHP | 7.0.30-0ubuntu0.16.04.1
MySQL | 10.0.34-MariaDB-0ubuntu0.16.04.1
RRDTool | 1.5.5
SNMP | NET-SNMP 5.7.3
====================================
[OK] Composer Version: 1.7.0
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
After daily.sh upgrades alert system stopped working.
I converted all default alert templates to new syntax and test transport from GUI works fine.
How fix/tshoot this?
./scripts/test-alert.php -r 1 -d -h localhost
SQL[SELECT device_id
FROM devices
WHERE hostname
= ‘localhost’]
SQL[SELECT alerts.id, alerts.device_id, alerts.rule_id, alerts.state, alerts.note FROM alerts WHERE alerts.device_id = && alerts.rule_id = 1]
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘&& alerts.rule_id = 1’ at line 1 (SELECT alerts.id, alerts.device_id, alerts.rule_id, alerts.state, alerts.note FROM alerts WHERE alerts.device_id = && alerts.rule_id = 1)
No active alert found, please check that you have the correct ids