Hi there,
I was having this issue not so long ago(Here), but somehow it got resolved by itself. Yesterday I noticed librenms was not responding so I sshd to it to find out is out of space, the librenms.log file has grown to 142gb. So I ran daily.sh and validate.php with no issues.
[librenms@librenms ~]$ ./validate.php
====================================
Component | Version
--------- | -------
LibreNMS | 21.12.0
DB Schema | 2021_11_29_165436_improve_ports_search_index (229)
PHP | 7.4.6
Python | 3.6.8
MySQL | 10.5.13-MariaDB
RRDTool | 1.4.8
SNMP | 5.7.2
====================================
[OK] Composer Version: 2.2.1
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
the errors i see in the log file are as follows :
production.ERROR: PDOException: SQLSTATE[HY000] [2002] Permission denied in /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40
Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000] [2002] Permission denied in /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Next Illuminate\Database\QueryException: SQLSTATE[HY000] [2002] Permission denied (SQL: select * fromconfig
where (config_name
= rrdtool_version) limit 1) in /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:703
I can connect just fine to the database, I also ran mysqlcheck librenms -p --auto-repair
in case something got broken. But still the problem persists.
I have added a crontab job to clear files larger than 5gb every 24h, but this is not a real solution to the problem. Im looking forward to any suggestions resolving this.