dovecot - Aug 2006 - 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 at 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 at 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 at 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 at 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