MySQL Connection over LAN problem

mlocicero88 · #1 19th August 2011, 12:56 AM

Hello,

I have a fedora 14 box and a windows box running on the same LAN. I can not connect to mysql from my windows box using the workbench GUI...

Here is what happens :

When I try to telnet my fedora box I get this :

SSH-2.0-OpenSSH_5.5
quirt
Protocol mismatch.

Connection to host lost.

C:\Users\Michael>telnet 192.168.1.2 3306
Connecting To 192.168.1.2...Could not open connection to the host, on port 3306:
Connect failed

C:\Users\Michael>^]^[
'↔←' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Michael>telnet 192.168.1.2 2329
Connecting To 192.168.1.2...Could not open connection to the host, on port 2329:
Connect failed

C:\Users\Michael>telnet 192.168.1.2 0
Connecting To 192.168.1.2...Could not open connection to the host, on port 0: Co
nnect failed

C:\Users\Michael>ipconfig

C:\Users\Michael>telnet 192.168.1.2 3306
Connecting To 192.168.1.2...Could not open connection to the host, on port 3306:
Connect failed

This leads me to believe there is no server running at port 3306(I can Ping the box fine though). Here is some information from my fedora box.

[root@localhost etc]# netstat -l | grep mysql
tcp 0 0 *:mysql *:* LISTEN
unix 2 [ ACC ] STREAM LISTENING 13101 /var/lib/mysql/mysql.sock

[root@localhost etc]# vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
bind-address=0.0.0.0
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

root@localhost etc]# service iptables status
Table: filter
Chain INPUT (policy ACCEPT)
num target prot opt source destination
1 ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:13101
2 ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:25
3 ACCEPT all -- 0.0.0.0/0 0.0.0.0/0 state RELATED,ESTABLISHED
4 ACCEPT icmp -- 0.0.0.0/0 0.0.0.0/0
5 ACCEPT all -- 0.0.0.0/0 0.0.0.0/0
6 ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 state NEW tcp dpt:22
7 REJECT all -- 0.0.0.0/0 0.0.0.0/0 reject-with icmp-host-prohibited
8 ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:3306
9 ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:3306

Chain FORWARD (policy ACCEPT)
num target prot opt source destination
1 REJECT all -- 0.0.0.0/0 0.0.0.0/0 reject-with icmp-host-prohibited

Chain OUTPUT (policy ACCEPT)
num target prot opt source destination

Please let me know if anyone has an idea what the problem is... it is driving me nuts

THANKS!

markkuk · #2 19th August 2011, 08:55 AM

Quote:

Originally Posted by mlocicero88

Code:

root@localhost etc]# service iptables status
Table: filter
Chain INPUT (policy ACCEPT)
num  target     prot opt source               destination
1    ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:13101
2    ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:25
3    ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0           state RELATED,ESTABLISHED
4    ACCEPT     icmp --  0.0.0.0/0            0.0.0.0/0
5    ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0
6    ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           state NEW tcp dpt:22
7    REJECT     all  --  0.0.0.0/0            0.0.0.0/0           reject-with icmp-host-prohibited
8    ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:3306
9    ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:3306

Please let me know if anyone has an idea what the problem is.

Iptables rules are applied in order. The rules that are supposed to accept connections to the MySQL port are after the REJECT rule, so they aren't ever reached.
Use system-config-firewall or some other firewall configuration GUI to set up your rule set.

mlocicero88 · #3 20th August 2011, 03:15 AM

That was it, thank you very much!!