User not logged in - login - register
Home Calendar Books School Tool Photo Gallery Message Boards Users Statistics Advertise Site Info
go to bottom | |
 Message Boards » » mysqld/iptables question Page [1]  
mouseanony
Veteran
105 Posts
user info
edit post

Hullo. I can connect to my mysqld running on fedora locally. However, if I telnet to port 3306 from another machine (directly connected via a x-over cable), or port scan that port, it doesn't connect. Looks like "skip-networking" is off in the mysqld config, so I'm guessing it's an iptables configuration issue, but I'm not an iptables guru...yet. Any guidance?

Thanks.

snipped from "netstat -atn"
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

[root@localhost ~]# iptables -L
Chain FORWARD (policy ACCEPT)
target prot opt source destination
RH-Firewall-1-INPUT all -- anywhere anywhere

Chain INPUT (policy ACCEPT)
target prot opt source destination
RH-Firewall-1-INPUT all -- anywhere anywhere

Chain OUTPUT (policy ACCEPT)
target prot opt source destination

Chain RH-Firewall-1-INPUT (2 references)
target prot opt source destination
ACCEPT all -- anywhere anywhere
ACCEPT icmp -- anywhere anywhere icmp any
ACCEPT ipv6-crypt-- anywhere anywhere
ACCEPT ipv6-auth-- anywhere anywhere
ACCEPT udp -- anywhere 224.0.0.251 udp dpt:5353
ACCEPT udp -- anywhere anywhere udp dpt:ipp
ACCEPT all -- anywhere anywhere state RELATED,ESTABLISHED
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:ssh
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:http
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:ftp
ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:smtp
REJECT all -- anywhere anywhere reject-with icmp-host-prohibited
[root@localhost ~]#

5/6/2006 7:53:55 PM

mouseanony
Veteran
105 Posts
user info
edit post

I think I needed this line:
ACCEPT tcp -- anywhere anywhere tcp dpt:mysql state NEW

I'm still running into an error, but at least it's a different error now.

Thanks.

5/6/2006 8:20:02 PM

mouseanony
Veteran
105 Posts
user info
edit post

W00!!

W00!!

Thanks.

5/7/2006 10:44:41 AM

 Message Boards » Tech Talk » mysqld/iptables question Page [1]  
go to top | |
Admin Options : move topic | lock topic

© 2024 by The Wolf Web - All Rights Reserved.
The material located at this site is not endorsed, sponsored or provided by or on behalf of North Carolina State University.
Powered by CrazyWeb v2.39 - our disclaimer.