Dear Team,
Greetings.
Librenms stopped plotting graphs today from 12 am, real time graphs are showing, but not hourly graphs. There are no errors in rrd or validation. Screen shot of errors is given.
Please support
Thanks
Please, paste your ./validate.php
Are you running cron or dispatcher? Does your librenms.log shows any error?
Please run daily.sh.
Ur not at the last version
IT containers a bug
PS u sould never run as root the validate.
Validate results are already given in the link. Re-posting the same. I run cron
I am getting devices unpolled.
updated, still not working
Sorry, didnt noticed it was a link.
What about your librenms.log file? Is there any error?
If not, try to manually run the poller-wrapper script like it does in your crontab
Yust updated mine to the same version.
Still working tho. , again validate shouldnot run as root.
But we need more info off debug what you did and what u got.
1st step is like @TheGreatDoc discribe.
Can you please share how to look at librenms.log file?
To view last 150 lines (real-time)
tail -f -n 150 /opt/librenms/logs/librenms.log
https://pastebin.com/raw/vgBBAHQM
The output is given in the above link. I see only one error
"
[2020-05-16 10:39:10] production.ERROR: SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from users where users.user_id = 493 limit 1) {“exception”:"[object] (Illuminate\Database\QueryException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from users where users.user_id = 493 limit 1) at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Doctrine\DBAL\Driver\PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:31, PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:27)
[stacktrace]"
Issue got resolved after changing , in config.php the following
$config[‘db_host’] = ‘localhost’;
to
$config[‘db_host’] = ‘127.0.0.1’;
Also add
$config[‘db_socket’] = ‘/var/lib/mysql/mysql.sock’;
Glad you got is sorted