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.
