I'm trying to route packets from 2 locations to a MySQL server sitting
behind a firewall running iptables.  The MySQL server has a ip address
of 192.168.1.12.  
Basically I want packets destined to port 3306 to be forwarded or
redirected to 192.168.1.12.

# MySQL
/sbin/iptables -A PREROUTING -t nat -i ppp0 -p tcp --dport 3306 -j DNAT
--to-destination 192.168.1.12
iptables -A INPUT -p tcp --dport mysql -j ACCEPT
iptables -A FORWARD -p tcp -s 192.168.1.12 --sport mysql -j ACCEPT
iptables -A FORWARD -p tcp -s $PRIVIP_1 --dport mysql -j ACCEPT
iptables -A FORWARD -m state --state ESTABLISHED,RELATED -j ACCEPT
iptables -A FORWARD -p tcp -s $PRIVIP_2 --dport mysql -j ACCEPT

Thanks
-- 
Jon Miller <[EMAIL PROTECTED]>
MMT Networks Pty Ltd



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to