Hi all. I’ve updated to 1.41 and for some reason, alerts stopped sending (to my email and other transport). I checked and run test transport, which sent alright.
Then i checked Librenms logs and found some errors:
2018-07-01 01:05:00 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…
I’m not sure if this is caused by the update (logs showed similar errors before). Couldn’t see any issue with mysql logs too. Aside from having no alerts, the service seems to be running just fine.
Anyone had the same issue and can help please?
LibreNMS | 1.41-8-gd9ceaf7
DB Schema | 253
PHP | 7.0.30
MySQL | 5.5.52-MariaDB
Update:
Reading through old topics, I checked alerts.php. There’s a locked file that I have now removed. And there are two processes running, the first one most likely a result of cron.
/bin/sh -c /opt/librenms/alerts.php >> /dev/null 2>&1
php /opt/librenms/alerts.php
Running “/opt/librenms/alerts.php -d” sends alert just fine. I killed above processes and restarted cron but now it hasn’t run/started alerts.php anymore.