"<BLOCKED::http://www.xamo.com:61519>" is not actually part of the output from SHOW PROCESSLIST correct?
Have you tried starting MySQL with --skip-name-resolve ? If this is the issue I'm thinking it is, would you be able to run tcpdump through grep for DNS traffic and see if anything is going on. And how well or not do the resolvers in /etc/resolv.conf on the master server resolve the problematic slave's IP address, reverse and forward? Is the problem slave the one on the different network? -Daniel -----Original Message----- From: Michael Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, June 02, 2005 4:55 PM To: mysql@lists.mysql.com Subject: Unauthenticated User (lots of connections problem) There's very few solutions on this problem in my research. I recently discovered a connection issue I cannot debug for the life of me. I don't know if it's related to a network/dns problem, if its the client, or the db server. My slave client, MySQL 4.0.23a (tried upgrading to 4.1.10, no change) tries to connect to our MySQL 4.1.7 server via PHP5 using mysql_connect(). Upon the connection, it makes approximately 600 connection attempts until the server times out with max connections, then stops and says 'Could not connect to MySQL Server'. The connection attempts appear on the server as: 19331 | unauthenticated user | XXX.XXX.XXX.XXX <BLOCKED::http://www.xamo.com:61519> :61519 | NULL | Connect | NULL | Reading from net | NULL The even wierder part is that the IP address it says the connection is coming from isn't the IP address of where it's actually coming from, its a completely different IP on the local network. I don't get that at all. My 3 other slaves don't have this problem at all. I'm using PHP 5 to make the connections on each box, same specs on all slave boxes. The only difference is one is on a different network. All slaves are from external networks. Doesn't appear to be a firewall issue as the firewall is allowing the connections just like the other slaves. The problem slave can ping the database server and make other connections. I'm unsure if this is something on the Server, or if it's an issue related to the one problematic slave. It happens on the connection attempt, so it can't be a permissions issue with the server, or anything to do with SQL queries. Any insight into this at all? Michael Brown Xamo Entertainment Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
