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]