Hello,
Having DB issue on my librenms. I think i might be pointing the db to somewhere else. Not sure how to check or verify/change? Can anyone help?
when open the web UI is says “Error connecting to database SQLSTATE[HY000] [2002] No such file or directory” when I check the librenmslog, shows this:
Jan 06 11:50:18 librenms mysqld[143181]: 2022-01-06 11:50:18 0 [Note] /usr/sbin/mysqld: ready for connections.
Jan 06 11:50:18 librenms mysqld[143181]: Version: '10.4.22-MariaDB-1:10.4.22+maria~focal-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 mariadb.org binary distribution
Jan 06 11:50:18 librenms systemd[1]: Started MariaDB 10.4.22 database server.
Jan 06 11:50:18 librenms mysqld[143181]: 2022-01-06 11:50:18 0 [Note] InnoDB: Buffer pool(s) load completed at 220106 11:50:18
Jan 06 11:50:18 librenms /etc/mysql/debian-start[143220]: Looking for 'mysql' as: /usr/bin/mysql
Jan 06 11:50:18 librenms /etc/mysql/debian-start[143220]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Jan 06 11:50:18 librenms /etc/mysql/debian-start[143220]: Version check failed. Got the following error when calling the 'mysql' command line client
Jan 06 11:50:18 librenms /etc/mysql/debian-start[143220]: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Jan 06 11:50:18 librenms /etc/mysql/debian-start[143220]: FATAL ERROR: Upgrade failed
Jan 06 11:50:18 librenms mysqld[143232]: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)