I think that error is given when it cannot connect at all to the mysql
server, and gives up.. we were getting it when we were trying to connect to
a mysql server on another box then realized it was only listening on
localhost on that box.

-David

> -----Original Message-----
> From: ISP Lists [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 24, 2005 8:24 AM
> To: vchkpw@inter7.com
> Subject: [vchkpw] Spotty behavior authenticating: MySQL server has gone
> away
> 
> Something peculiar happened to mysql during a reboot and now vpopmail
> authdaemond is having trouble completing authentications....
> 
> /var/log/maillog says:
> 
> Aug 24 08:36:15 hostname authdaemond: vmysql: sql error[3]: MySQL server
> has gone away
> 
> 
> This problem is spotty though.  I have several successful authentications
> before this error occurs.  I then have to restart mysqld before I can get
> any other authentications to succeed.  I am still able to use the mysql
> client to connect to the server for an interactive session.
> 
> What seems strange to me is that there are only two mysql daemons running:
> 
> root     23923  0.0  0.1  5060 1108 pts/0    S    09:13   0:00 /bin/sh
> /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf
> --pid-file=/var/run/mysqld/mysqld.pid
> 
> mysql    23956  0.0  0.5 38620 5656 pts/0    Sl   09:13   0:00
> /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/var/lib
> --datadir=/var/lib/mysql --user=mysql
> --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
> 
> 
> Every other instance of mysql 3.23.x I've ever run has about 10 child
> threads running, so this seems strange to see only one child thread.
> 
> I have not updated any packages on this box recently.  None at all, I
> swear.
> 
> Suggestions to investigate?  Googling on the "MySQL server has gone away"
> is a wild goose chase.
> 
> 
> 
> 
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.338 / Virus Database: 267.10.14/79 - Release Date: 8/22/2005
> 

Reply via email to