MySQL Forums
Forum List  »  Security

Unauthenticated user issues?
Posted by: Brandon Laing
Date: May 23, 2005 10:22AM

Hey all,

Having some issues with a new MySQL system. We're running the 64-bit version of MySQL 4.1.11, installed from RPMs, on a dual Opteron system, 4 gigs of memory, 15k RPM SCSI drives, gig network, etc. We replaced our old server, which was running version 4.0.17 with this box. For the most part, things have been working great (and very fast!) so far. However, a couple times we've had everything hang on us while waiting for mysql to authenticate a new connection. Running a show processlist shows the strings like this:

| 108160 | unauthenticated user | 192.168.XXX.XXX:3449 | NULL | Connect | NULL | login | NULL
| 108162 | unauthenticated user | 192.168.XXX.XXX:39610 | NULL | Connect | NULL | login | NULL |
| 108163 | unauthenticated user | 192.168.XXX.XXX:39611 | NULL | Connect | NULL | login | NULL |
| 108164 | unauthenticated user | 192.168.XXX.XXX:39612 | NULL | Connect | NULL | login | NULL |
| 108165 | unauthenticated user | 192.168.XXX.XXX:39613 | NULL | Connect | NULL | login | NULL |
| 108166 | unauthenticated user | 192.168.XXX.XXX:39614 | NULL | Connect | NULL | login | NULL |
| 108167 | unauthenticated user | 192.168.XXX.XXX:39615 | NULL | Connect | NULL | login | NULL |


We'll have 20-30 of these within a couple of minutes, and they just keep piling up. During this time, no new connections can be made. All new connections are coming from our internal network as well. About the only thing we've been able to do is start killing these processes until finding the one that's causing the problem, at which time everything else goes through.

So, I've looked around a bit and have seen that this issue shows up from time to time, but nobody ever has a resolution for it. I'm hoping that someone has some ideas to try to attempt to work through this problem. I can provide my.cnf configuratons if they will help any.

Any suggestions would really be appreciated here.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Unauthenticated user issues?
44334
May 23, 2005 10:22AM
17020
March 01, 2007 10:35PM
15396
March 02, 2007 05:08AM
17184
June 18, 2008 08:57AM
9962
July 07, 2008 06:06AM
9570
November 19, 2008 09:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.