thr3ads.net - dovecot - [Dovecot] MySql Server Has gone [Feb 2006]

If this information is useful, please help other people find it:
Share via:

Marc-André Joyal

2006-Feb-20 16:59 UTC

[Dovecot] MySql Server Has gone

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<pre>Hi,
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspI'm
running Dovecot v. 0.99.14 without any problems except this one: It seems
that Dovecot loses the connection with MySQl after a certain amount of time and
I got
this message in /var/log/maillog:
<b>Feb 19 09:37:14 localhost dovecot-auth: MySQL: Error executing query
"SELECT userpassword FROM
virtual_users WHERE username = 'bob'": MySQL server has gone
away</b>

I looked in the MySql docs and, by default, after 8 hours of inactivity, the
Mysql
server closes the connection with the client (and it's probably this that
causes the
error above).

So, I know that I can change the <code
class="literal"><i>wait_timeout</i> option in MySql but
is there a way to
specify an unlimited time connection only from Dovecot to MySql? And by the way,
what's
exactly the purpose of Dovecot's <i>db_client_flags</i> option?
Would it be possible to specify
the timeout via this option?

Thanks for your help!

Marc-Andr&eacute;
</code></pre>
</body>
</html>

Timo Sirainen

2006-Feb-20 17:23 UTC

head link

[Dovecot] MySql Server Has gone

On Mon, 2006-02-20 at 11:59 -0500, Marc-Andr? Joyal
wrote:> Hi,
> 	I'm running Dovecot v. 0.99.14 without any problems except this one:
It seems
> that Dovecot loses the connection with MySQl after a certain amount of time
and I got
> this message in /var/log/maillog:
> Feb 19 09:37:14 localhost dovecot-auth: MySQL: Error executing query
"SELECT userpassword FROM
> virtual_users WHERE username = 'bob'": MySQL server has gone
away
> 
> I looked in the MySql docs and, by default, after 8 hours of inactivity,
the Mysql
> server closes the connection with the client (and it's probably this
that causes the
> error above).
> 
> So, I know that I can change the wait_timeout option in MySql but is there
a way to
> specify an unlimited time connection only from Dovecot to MySql? 
As far as I know, it's not possible. But if you upgraded to 1.0betas,
Dovecot would reconnect and retry the query automatically.
> And by the way, what's 
> exactly the purpose of Dovecot's db_client_flags option? Would it be
possible to specify
> the timeout via this option?
They're listed here:

http://dev.mysql.com/doc/refman/5.0/en/mysql-real-connect.html

The parameter is there just in case someone would want to change it, but
it's rarely wanted..
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20060220/1c705492/attachment.bin>

Possibly Parallel Threads

Search for more seemingly similar threads

dovecot - Feb 2006 - MySql Server Has gone

[Dovecot] MySql Server Has gone

[Dovecot] MySql Server Has gone

Possibly Parallel Threads