I have a MySQL server (RedHat 8.0 standard updated RPMs mysql-3.23.54a-4
) running on my box. I also have a NAT firewall running on my 192.168.1.0/24 subnet (my Linux server is
my NAT firewall).
I have been able to use the MySQL normally without any problems from any outside computer (just connected to my IP address to port 3306). Right now, however I can't. I can't even telnet to port 3306. When I try to telnet in, my connection gets dropped after
I connect. This is behaviour typical to tcpd when something goes wrong. A successful TCP connection is made, but it's dropped quickly before the daemon has a chance to say anything.
Since I am not running mysqld from xinetd, I have no idea why it does it. The only clue I have is that this started happening when I upgraded rom RedHat 7.2 to RedHat 8.0. Possibly the RedHat 8.0 version of the RPMs has some stupid security lockout in the mysqld startup script that RedHat likes to put in their RPMs for some reason (ever tried enabling XDMCP on RedHat?
To rule out other possibilities, I have done the following:
- Added the line mysqld: 0.0.0.0 to my /etc/hosts.allow file to rule out the tcpd TCP wrapper (even though since I am running mysqld as a standalone daemon, this should not have any effects). This had no effect.
- Disabled iptables alltogether. No effect.
- Forwarded port 3307 from my outside IP to 192.168.1.1 (the server's NATted IP) port 3306. No effect.
That last test actually makes me even more suspicious of tcpd-like activity...
I would also like to add that the RedHat startup script for MySQL uses safe_mysqld
rather than just running the mysqld
binary directly. I am now suspicious that this is the cause. Before I start messingwith the scripts further, however, I'd appreciate any input you may have on this... Thanks!!!