cdr_mysql.c:203 mysql_log: Cannot connect to database server localhost

When restoring FreePBX from backup, you may find the CDR database is not updated. This is because the cdr_mysql.conf file is not overwritten by the restore, and so the password for the CDR database is incorrect.

You can resolve it like this:

SSH onto the server
nano /etc/freepbx.conf

Find the lines:

$amp_conf['AMPDBUSER']  = 'freepbxuser';
$amp_conf['AMPDBPASS']  = '3098SADFSLa';​​

Copy the password, quit nano

- See more...