Cannot get cdr password to update after restore

Distro Discussion & Help
1

Freepbx 12.0.76.2

Did a restore from backup. CDR module not working, disabled because it needs an upgrade.

When I try to upgrade CDR, I get the following:

Module cdr successfully downloaded
[FATAL] SQLSTATE[28000] [1045] Access denied for user ‘freepbxuser’@‘localhost’ (using password: YES) SQLSTATE[28000] [1045] Access denied for user ‘freepbxuser’@‘localhost’ (using password: YES)

Trace Back:

/var/www/html/admin/libraries/BMO/Database.class.php:70 PDO->__construct()
[0]: mysql:host=localhost;port=3306;dbname=asteriskcdrdb
[1]: freepbxuser
[2]: 14axxxxxxxab

/var/www/html/admin/modules/cdr/Cdr.class.php:35 Database->__construct()
[0]: mysql:host=localhost;port=3306;dbname=asteriskcdrdb
[1]: freepbxuser
[2]: 14axxxxxxxab

I’ve made sure all the passwords are proper (the 14xxxx is the old one). cdr_mysql.conf does NOT have that password. freepbx.conf is also proper.

Where am I missing one that has to be changed???

2

Hi!

Have you tried this: Restore from FreePBX 12.0.76 server to a test server - CDR issues ?

Good luck and have a nice day!

Nick

3

That wasn’t the solution directly, but it did lead me to uncover the hidden settings in advanced, and I found the old password still stuck in there.

Thanks!

4

Hi!

If it was there it was because you had overidden them…

For a normal configuration they are supposed to be empty…

Unless you need them to be different from the default, clear them…

At least that’s what is supposed to be the reason, mine where also set there and I don’t remember ever setting them but Rob is a FreePBX developer and said they should only be filled in if you need something different from the default…

Have a nice day!

Nick