Hi,
Here's a bit of a followup:
I've narrowed my problem down to one of our servers, the one running mySQL
3.22.27.
The server is listening to port 3306, but is taking a very long time to
respond to requests sent to that port. It seems to hang but it eventually
responds after a few minutes.
Any ideas why it would be taking so long? This is on a RH 6.0 system.
Thank you!
Kurt Hansen
[EMAIL PROTECTED]
> > Subject: ERROR 2013: Lost connection to MySQL server during query
> >
> >
> > Hello,
> >
> > I'm getting the error message above whenever I try to connect from a
> remote
> > host to a MySQL server. I issue the following command:
> >
> > mysql --host=host_name -u user_name -ppass_word
> >
> > and get the ERROR 2013 back as a response.
> >
> > We have two servers, both running MySQL. I get the same message going
both
> > ways. I have all the privileges set up properly. When I don't, I just
get
> > the "host_name not set up for access" message. I've duplicated the setup
> on
> > our local LAN, and I connect with no problem. It is only our Web servers
> > that are having this problem.
> >
> > We are only having this problem after our ISP moved our servers to a
new,
> > "better" network and gave us new IPs. The servers have been talking to
> each
> > other with no problems for almost 1.5 years, but have not been able to
> since
> > the move. I've updated the privilege information, but it appears that
the
> > client is not getting a complete response from the server.
> >
> > Any ideas on what to do to fix this? Troubleshooting clues? The request
> from
> > the remote server is not showing up in the log; anyway I could capture
> this?
> >
> > I can telnet between the systems so I'm pretty sure the TCP/IP is
working.
> >
> > MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2.
> > The mysqld variables are set to their default except for
> max_allowed_packet,
> > which has been increased to 10048512 on the 3.22.21 system in a vain
> attempt
> > to solve the error.
> >
> > Thanks!
> >
> > Kurt Hansen
> > [EMAIL PROTECTED]
`
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
