Ispconfig 3 Mysql Firewall rule

Discussion in 'Installation/Configuration' started by matthisk, Aug 8, 2012.

  1. matthisk

    matthisk New Member

    Hi!

    I am trying to configure my server for remote mysql access to a database. However I am not able to open up the port: 3306. I tried configuring the firewall settings in the web admin panel of ispconfig 3, with no luck. I checked on the iptables (which do not seem to have a process running when I search for it trough ''ps''), iptables -L gives me this:

    ...
    PAROLE tcp -- anywhere anywhere tcp dpt:mysql
    ...

    Then I found out ispconfig uses the bastille firewall (which uses iptables i guess?). The bastille netfilter status sais this about port 3306:


    6 304 PAROLE tcp -- * * 0.0.0.0/0 0.0.0.0/0 tcp dpt:3306

    Restarting the bastille-firewall did not have any effect either. I can not seem to figure out where the problem lies, any ideas?

    Kind Regards,
    Matthisk
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The firewall port is already open when you see this line. Check the mysql my.cnf file and ensure that mysql listens on all interfaces and not just localhost.
     
  3. matthisk

    matthisk New Member

    I was totally confinced it was a firewall issue, but you were right. Changing the listening address from localhost to 0.0.0.0 fixed my issue. Thanx!
     

Share This Page