This is my SHOW FULL PROCESSLIST:
+-------+----------+-----------+----------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+----------+-----------+----------+---------+------+-------+-----------------------+
| 10098 | vpopmail | localhost | vpopmail | Sleep | 5400 | NULL | NULL |
| 10099 | vpopmail | localhost | vpopmail | Sleep | 4783 | NULL | NULL |
| 10121 | vpopmail | localhost | vpopmail | Sleep | 3054 | NULL | NULL |
| 10129 | vpopmail | localhost | vpopmail | Sleep | 1155 | NULL | NULL |
| 10149 | vpopmail | localhost | vpopmail | Sleep | 7197 | NULL | NULL |
| 10267 | vpopmail | localhost | vpopmail | Sleep | 1147 | NULL | NULL |
| 10268 | vpopmail | localhost | vpopmail | Sleep | 4789 | NULL | NULL |
| 10269 | vpopmail | localhost | vpopmail | Sleep | 3613 | NULL | NULL |
| 10365 | vpopmail | localhost | vpopmail | Sleep | 3054 | NULL | NULL |
| 10366 | vpopmail | localhost | vpopmail | Sleep | 3054 | NULL | NULL |
| 10464 | vpopmail | localhost | vpopmail | Sleep | 1260 | NULL | NULL |
| 10517 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST |
+-------+----------+-----------+----------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+----------+-----------+----------+---------+------+-------+-----------------------+
| 10098 | vpopmail | localhost | vpopmail | Sleep | 5400 | NULL | NULL |
| 10099 | vpopmail | localhost | vpopmail | Sleep | 4783 | NULL | NULL |
| 10121 | vpopmail | localhost | vpopmail | Sleep | 3054 | NULL | NULL |
| 10129 | vpopmail | localhost | vpopmail | Sleep | 1155 | NULL | NULL |
| 10149 | vpopmail | localhost | vpopmail | Sleep | 7197 | NULL | NULL |
| 10267 | vpopmail | localhost | vpopmail | Sleep | 1147 | NULL | NULL |
| 10268 | vpopmail | localhost | vpopmail | Sleep | 4789 | NULL | NULL |
| 10269 | vpopmail | localhost | vpopmail | Sleep | 3613 | NULL | NULL |
| 10365 | vpopmail | localhost | vpopmail | Sleep | 3054 | NULL | NULL |
| 10366 | vpopmail | localhost | vpopmail | Sleep | 3054 | NULL | NULL |
| 10464 | vpopmail | localhost | vpopmail | Sleep | 1260 | NULL | NULL |
| 10517 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST |
+-------+----------+-----------+----------+---------+------+-------+-----------------------+
This SQL server is not a busy server. It hosts a PHP Nuke site, which gets about 5 hits a month, and that's about it.
No errors in the MySQL log files. Additionally, I've run Qmail-toaster this way for well over a year, with no problems. The issues occured when I upgraded to the lastest versions of everything from the
Qmailtoaster.com site - I then upgraded to the next version of vpopmail from the devel.qmailtoaster.com site in an atttempt to fix the problem.
I could make a cron job to just restart qmail, but that doesn't seem like an elegant nor long term solution... it's just avoiding the inevitable problem...
On 8/25/06, Ray Van Dolson <[EMAIL PROTECTED]> wrote:
On Fri, Aug 25, 2006 at 12:08:30PM -0700, Nolan Garrett wrote:
> I'm using the Qmail Toaster package from www.qmailtoaster.com. Approximately
> every 24 hours, clients are unable to connect to vpopmail/Qmail, and the
> following error is in my /var/log/qmail/authlib/current file:
>
> vmysql: sql error[3]: MySQL server has gone away
>
> Stopping and starting Qmail fixes the problem. I've performed the steps listed
> at: http://qmailwiki.inter7.com/Vpopmail#
> When_using_MySQL_for_authentication.2C_I_get_the_error_vmysql:_sql_error.5B3.5D_MySQL_server_has_gone_away
> and everything seems to be fine.
I'm assuming you've confirmed that MySQL is running?
Any errors in /var/lib/mysql/*.err?
If you connect to MySQL locally what do you see with a SHOW FULL
PROCESSLIST? I wonder if you're exceeding the max connections will handle?
Busy server?
Ray
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]