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.

Replies (1)

Are you using the same password that Observium is?

Reply 1

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.