LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
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, 06: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 02:03 PM
Bash and mysql connections. tia24 Linux - Newbie 1 04-13-2004 02:15 PM
mysql connections srikz Red Hat 1 01-17-2004 08:39 AM
MySQL too many connections problem NetScripter Linux - Software 0 12-10-2003 03:36 AM
MySQL not allowing connections from Applet peteABK Linux - Newbie 1 11-04-2003 10:29 PM


All times are GMT -5. The time now is 08:15 AM.

Main Menu
Advertisement
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