Could not connect to database, check logs/librenms.log. Need some help

[jasonloong]

Hi @Korvo

Thank you for the logs

@Korvo

[2023-04-07T20:07:35.154979+02:00] local.ERROR: PDOException: SQLSTATE[HY000] [1045] Access denied for user ‘librenms’@‘172.17.0.13’ (using password: YES) in /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40
Stack trace:
[2023-04-07T22:37:47.122224+02:00] production.ERROR: PDOException: SQLSTATE[HY000] [1045] Access denied for user ‘librenms’@‘172.17.0.13’ (using password: YES) in /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40

It seems like a permissions issue

1. Can you confirm that you have setup the sql user “librenms” with the correct permissions? (Replace libre_password with your_password)

CREATE DATABASE librenms CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE USER 'librenms'@'%' IDENTIFIED BY 'libre_password';
CREATE USER 'librenms'@'localhost' IDENTIFIED BY 'libre_password';
GRANT ALL PRIVILEGES ON librenms.* TO 'librenms'@'%';
FLUSH PRIVILEGES;
exit

2. Your MariaDB container volume mount has no persistent storage , volume is linked to the sql conf.d ~ unless you’ve setup the permissions above in the confd, the sql container starts from “fresh” whenever you restart the container