vicidial.org

I was in a bind this morning so i installed Vicidialnow. What is the quickest way to enable remote mysql connections on a default install whereas the rest of my servers scripts rely on connecting to mysql on the dialer remotely?

What version of VicidialNOW are you using?

vicidialnow-ce-1.1

You can edit /etc/sysconfig/iptables and uncomment this entry:

#-A RH-Firewall-1-INPUT -m tcp -p tcp --dport 3306 -j ACCEPT

Restart iptables by running this:

service iptables restart

The drawback is this will allow anyone access to your mysql database. I recommend limiting the access to your hosts or network.

awesome thank you! i didnt even check to see if it was a firewall issue... it's been a long day already.

Im not used to iptables config,
i did a initial google search and wasn't clear on how i can limit this to just a certain network mask, any help here?
(thanks for the solution!)

gardo wrote:You can edit /etc/sysconfig/iptables and uncomment this entry:

#-A RH-Firewall-1-INPUT -m tcp -p tcp --dport 3306 -j ACCEPT

Restart iptables by running this:

service iptables restart

The drawback is this will allow anyone access to your mysql database. I recommend limiting the access to your hosts or network.

You can google more on how to achieve this. There are lots of articles on how to manipulate iptables. Here's an example entry:

-A RH-Firewall-1-INPUT -m tcp -p tcp -s IP_ADDRESS --dport 3306 -j ACCEPT

Where IP_ADDRESS is the IP address you want to allow access to your mysql.

gardo wrote:You can google more on how to achieve this. There are lots of articles on how to manipulate iptables. Here's an example entry:

-A RH-Firewall-1-INPUT -m tcp -p tcp -s IP_ADDRESS --dport 3306 -j ACCEPT

Where IP_ADDRESS is the IP address you want to allow access to your mysql.

thanks!