I have this problem the question is the user the asteric and freepbx make on conflict in the mysql whe yo restart the server the mysql is down Here there any solution please if no work POST THE CORRECT SOLUTION
Some CDR troubleshooting and default mysql root password
Hey everyone…I wanted to just give out a quick tutorial on CDR troubleshooting. I had a client who recently changed the user=asteriskuser in the /etc/asterisk/cdr_mysql.conf file to the root user instead of asteriskuser. After doing a bit of troubleshooting, I ended up changing the mysql root password to match the password set in that file. So, here is how to change the mysql root password and use it for CDR (even though asteriskuser is used by default).
From the Linux CLI, go to /etc/asterisk and nano the cdr_mysql.conf file:
Find the line that says ‘password=amp109′ and change the amp109 to your desired password. Also note what user is used. By default, this file uses ‘asteriskuser.’ This is perfectly acceptable…you would want to change the password= line to your asteriskuser password. If, however, you want to use ‘root’ instead, change the line to user=root, and change the password to your mysql root password (or what we are about to change your mysql root password to).
CTRL+X to exit nano and then Y when asked if you want to save.
Now we have changed the CDR conf file, but we still need to change the password in mysql. Do the following:
mysqladmin -u root -p password new_password_here
It will now prompt you for a password…what it is prompting you for is the default root password which is ‘passw0rd’ (with a zero). If you enter it in and get no errors, you have successfully changed your mysql root password. Now let’s restart mysql and Asterisk.
service mysqld restart
To test CDR connectivity, let’s get into the Asterisk CLI:
Now, to see if CDR is working…type the following at the Asterisk CLI prompt:
cdr mysql status
You should see something like:
Connected to [email protected] using table cdr for 8 minutes, 32 seconds.
Wrote 0 records since last restart.
If you see ‘Not currently connected to a MySQL server.’ then you most likely still have a password mismatch…and if at first you don’t succeed, try try again!