LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 02-20-2003, 05:47 PM   #1
sewer_monkey
Member
 
Registered: May 2002
Location: Toronto, ON, Canada
Distribution: Ubuntu, Debian, RedHat/CentOS
Posts: 624

Rep: Reputation: 31
Question MySQL connections from 0.0.0.0 got me baffled!


Hiya all!

I have a MySQL server (RedHat 8.0 standard updated RPMs mysql-3.23.54a-4 and mysql-server-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!!!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
2000 MySQL connections, still "too many connections" newlinuxnewbie Linux - General 0 11-07-2005 01:03 PM
Bash and mysql connections. tia24 Linux - Newbie 1 04-13-2004 01:15 PM
mysql connections srikz Red Hat 1 01-17-2004 07:39 AM
MySQL too many connections problem NetScripter Linux - Software 0 12-10-2003 02:36 AM
MySQL not allowing connections from Applet peteABK Linux - Newbie 1 11-04-2003 09:29 PM


All times are GMT -5. The time now is 03:11 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration