Thanks @murrant .I didn’t change my Database configuration. I can see on the config.php that it stays intact. I upgrade my Ubuntu server from 16.04 to 18.04 and I remember there was prompt during the upgrade about the mariaDB which I chose the option to go with the newer version or something of that sort
Which my.cnf you referring to ? The /opt/librenms/config.php ?
MySQL and MariaDB packages after the upgrade shows the following:
ii libdbd-mysql-perl 4.046-1 amd64 Perl5 database interface to the MariaDB/MySQL database
ii libmysqlclient20:amd64 5.7.25-0ubuntu0.18.04.2 amd64 MySQL database client library
ii mariadb-client 1:10.1.34-0ubuntu0.18.04.1 all MariaDB database client (metapackage depending on the latest version)
rc mariadb-client-10.0 10.0.36-0ubuntu0.16.04.1 amd64 MariaDB database client binaries
ii mariadb-client-10.1 1:10.1.34-0ubuntu0.18.04.1 amd64 MariaDB database client binaries
ii mariadb-client-core-10.1 1:10.1.34-0ubuntu0.18.04.1 amd64 MariaDB database core client binaries
ii mariadb-common 1:10.1.34-0ubuntu0.18.04.1 all MariaDB common metapackage
ii mariadb-server 1:10.1.34-0ubuntu0.18.04.1 all MariaDB database server (metapackage depending on the latest version)
rc mariadb-server-10.0 10.0.36-0ubuntu0.16.04.1 amd64 MariaDB database server binaries
ii mariadb-server-10.1 1:10.1.34-0ubuntu0.18.04.1 amd64 MariaDB database server binaries
ii mariadb-server-core-10.1 1:10.1.34-0ubuntu0.18.04.1 amd64 MariaDB database core server files
ii mysql-common 5.8+1.0.4 all MySQL database common files, e.g. /etc/mysql/my.cnf
rc php7.0-mysql 7.0.32-0ubuntu0.16.04.1 amd64 MySQL module for PHP
ii python-mysqldb 1.3.10-1build1 amd64 Python interface to MySQL
MySQL status shows this:
mariadb.service - MariaDB 10.1.34 database server
I tried to use the credentials in /opt/librenms/config.php for “mysql -u username -p” and came up with this error
ERROR 1045 (28000): Access denied for user ‘username’@‘localhost’ (using password: YES)
Don’t long in with root, log in with the credentials in the files (.env & config.php). You said that failed earlier. You need to check to see if they actually work.