Access asteriskcdrdb remotely

1

Trying to access the mysql asteriskcdrdb remotely. Think I have port 3306 open in firewall, added custom port.
Still can not access remotely.

2

You need to setup MySQL ACL’s to allow access to that database from that “remote” host.

You will also need to edit your /etc/mysql/my.cnf to reflect that

bind-address = 127.0.0.1

is actually

bind-address = YOUR_NETWORK_INTERFACE_IP_ADDRESS

if that screws up FreePBX, then

bind-address = 0.0.0.0

but if you do that you would need to set secure passwords :wink:

3

He’s not kidding. if you open up your MySQL server to the world and leave the root password as the default, you are just asking for trouble.