TIPS Connecting to Mysql

[Tom Jackson]

I am trying to replicate the CDR table to another server. I am having a difficult time establishing a connection to the Mysql database. PBXinaflash and the phone system are working perfectly.

I am unclear as to the proper credentials. I setup a new user in the asteriskcdrdb database. I am not able to connect.


Please help.

Thanks,

 

[wardmundy]

If it's a PIAF server, the MySQL credentials are root:passw0rd (with a zero).

 

[Jay Deal]

If it's a PIAF server, the MySQL credentials are root:passw0rd (with a zero).

Usually unless it's on RASPBX for Raspberry Pi or Beaglebone Black then it's 'raspberry'. I wish someone had not done that. It meant transferring backups from RASPBX to other platforms running the same PIAF or IPBX Asterisk/Freepbx version is very cumbersome.

 

[wardmundy]

Agreed. Unfortunately, we inherited that setup from RasPBX and stupidly kept it going. A new build for the RasPi 2 with FreePBX is still a possibility.

 

[Tom Jackson]

Thanks! I have never used the More/Replicate feature in phpMyAdmin. It stated that this server is not configured as a master in the replication process. Before I configure as such, my question is, is there a reason not to? Can I simply set this up as a master, and have a slave on a different machine without causing issues? The slave will be read only. I'd really like to avoid making a mess of things.

 

[matthew]

In something as hefty as replicating databases, I'd be a bit reluctant to go clicking around in gui tools if not sure what it all does or means. You might be better following a tutorial. Still simple to follow, but you see what is happening under the hood and will help to both understand and trouble shoot the process. Try these guys. Their stuff is generally useful. https://www.howtoforge.com/mysql_database_replication