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.
> -----Original Message-----
> From: ISP Lists [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 24, 2005 8:24 AM
> To: firstname.lastname@example.org
> Subject: [vchkpw] Spotty behavior authenticating: MySQL server has gone
> 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: 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
> 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
> 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