<!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,
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:
<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é
</code></pre>
</body>
</html>