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? 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?
Thanks for your help!
Marc-André