[Dovecot] Problems with dovecot 1.0rc5 + MySQL 5.0.24
Hi all,
I'm having an intermittent problem logging users in through a webmail client (RoundCube). My maillog reports this:
auth(default): vmysql: sql error[3]: MySQL server has gone away imap-login: Disconnected: user=sales@coppersinkdepot.com, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
The MySQL server hasn't gone anywhere, I can log into it fine and other apps report no problems with it.
Restarting Dovecot fixes this issue, but it'll just happen again later.
I'm on OpenBSD 3.9 using vpopmail.
I've looked through the mailing list archives but can't find any info on this specific problem.
Any ideas?
Daniel,
The "MySQL server has gone away" error message usually means the connection to the server was lost. This can happen if your MySQL server gets restarted or the TCP connection is dropped or closed.
That being said, I've tried to replicate this problem with Dovecot 1.0rc7 and MySQL 5.0.24 and was unable to. Dovecot gracefully reconnects to the database server and authentication works fine.
Is your MySQL server on the same box? Is there something that could be causing the database connections to get reset or dropped?
-Vince
On Wed, August 23, 2006 7:50 am, Daniel Torreblanca wrote:
Hi all,
I'm having an intermittent problem logging users in through a webmail client (RoundCube). My maillog reports this:
auth(default): vmysql: sql error[3]: MySQL server has gone away imap-login: Disconnected: user=sales@coppersinkdepot.com, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
The MySQL server hasn't gone anywhere, I can log into it fine and other apps report no problems with it.
Restarting Dovecot fixes this issue, but it'll just happen again later.
I'm on OpenBSD 3.9 using vpopmail.
I've looked through the mailing list archives but can't find any info on this specific problem.
Any ideas?
You need to look at your mysql error log. The defaults on OpenBSD 3.9 are rather low and you may be running out of file descriptors for the mysql process or some other wierdness. I use mysql 5.0 with openbsd 4.0 (snapshot) and it works great, but I increase openfiles-cur in the daemon class (see /etc/login.conf) to 8192 and kern.maxfiles to 16384 (see /etc/sysctl.conf)
Daniel Torreblanca [regulatethis@gmail.com] wrote:
Hi all,
I'm having an intermittent problem logging users in through a webmail client (RoundCube). My maillog reports this:
auth(default): vmysql: sql error[3]: MySQL server has gone away imap-login: Disconnected: user=sales@coppersinkdepot.com, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
The MySQL server hasn't gone anywhere, I can log into it fine and other apps report no problems with it.
Restarting Dovecot fixes this issue, but it'll just happen again later.
I'm on OpenBSD 3.9 using vpopmail.
I've looked through the mailing list archives but can't find any info on this specific problem.
Any ideas?
-- Theatre is life Film is art Television is furniture
I'll give that a shot, thanks guys.
This is all running on one box for now. The problems might rest fully with MySQL.
On 8/23/06, Chris Cappuccio chris@nmedia.net wrote:
You need to look at your mysql error log. The defaults on OpenBSD 3.9 are rather low and you may be running out of file descriptors for the mysql process or some other wierdness. I use mysql 5.0 with openbsd 4.0 (snapshot) and it works great, but I increase openfiles-cur in the daemon class (see /etc/login.conf) to 8192 and kern.maxfiles to 16384 (see /etc/sysctl.conf)
Daniel Torreblanca [regulatethis@gmail.com] wrote:
Hi all,
I'm having an intermittent problem logging users in through a webmail client (RoundCube). My maillog reports this:
auth(default): vmysql: sql error[3]: MySQL server has gone away imap-login: Disconnected: user=sales@coppersinkdepot.com, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
The MySQL server hasn't gone anywhere, I can log into it fine and other apps report no problems with it.
Restarting Dovecot fixes this issue, but it'll just happen again later.
I'm on OpenBSD 3.9 using vpopmail.
I've looked through the mailing list archives but can't find any info on this specific problem.
Any ideas?
-- Theatre is life Film is art Television is furniture
-- "Never attribute to malice that which is adequately explained by stupidity"
participants (3)
-
Chris Cappuccio
-
Daniel Torreblanca
-
Vince Valenti