I’m currently using a test server (1.1010.210.62-5) and am trying to copy the settings over onto the (not yet deployed) production server (3.211.63-3). Everything seems to be restored as expected, with the exception of the mysql cdr database, which gives and error:
ERROR[3908][C-00000001]: cdr_mysql.c:203 mysql_log: Cannot connect to database server localhost: (1045) Access denied for user ‘freepbxuser’@‘localhost’ (using password: YES)
Here is a snippet from my cdr_mysql.conf:
hostname = localhost
dbname=asteriskcdrdb
password = psLNjgbfXats
user = freepbxuser
and from mysql:
mysql> select host, user, password from user where user = ‘freepbxuser’;
±----------±------------±------------------------------------------+
| host | user | password |
±----------±------------±------------------------------------------+
| localhost | freepbxuser | *B35EE120468EEEB8C25AE6FE0B44A108D43879F6 |
±----------±------------±------------------------------------------+
1 row in set (0.00 sec)