Marios's picture

I want to transfer my old observium configuration to a new appliance installation.

I have downloaded the latest version of the appliance and I have copied the config.php and RRD directory to the new appliance.

I have also created a mysqldump of one of the database and imported it in the new system.

When I try to login to the web interface I get the following error:

DB Error 1045: Access denied for user 'observium'@'localhost' (using password: YES).

When I login through cli to the mysql database with 'observium' user I don't have any issue.

Now everytime I open the web interface I see the error message and not the login page.

Forum: 
Tags: 
Jeremy Davis's picture

Whilst you may be able to log into MySQL with the Observium account ok, are you using the same password that Observium is using? I.e. the password in '/opt/observium/config.php'?

Regardless, probably the easiest way to fix this up is to rerun the Observium "regen secrets" firstboot script like this:

/usr/lib/inithooks/firstboot.d/20regen-observium-secrets

(requires root)

That will regenerate a new random password for the Observium MySQL user and update the config file.

Add new comment