Am 15.09.2011 12:53, schrieb Timo Sirainen:
On Fri, 2011-09-09 at 19:33 -0700, Paul B. Henson wrote:
Sep 9 15:47:34 tweak dovecot: auth: Error: mysql(mysql-1.unx.csupomona.edu): Connect failed to database (idmgmt): Can't connect to MySQL server on 'mysql-1.unx.csupomona.edu' (111) - waiting for 1 seconds before retry
I did several fixes related to this in v2.0 hg.
And postfix starts to fail authentications:
Sep 9 15:47:35 tweak postfix/smtpd[5119]: warning: bender.iitsys.csupomona.edu[134.71.250.134]: SASL DIGEST-MD5 authentication failed: Connection lost to authentication server
The reason why it kept failing with Postfix was because Dovecot had 10 second timeout for SQL connecting, and Postfix had 10 second timeout before failing authentication. So Postfix never waited long enough for Dovecot to attempt a second connection to the second MySQL server. I dropped Dovecot's SQL connect timeout to 5 seconds.
Now and again the authentication process dies:
Sep 9 15:47:39 tweak dovecot: auth: Panic: file auth-request-handler.c: line 697 (auth_request_handler_flush_failures): assertion failed: (auth_request->state == AUTH_REQUEST_STATE_FINISHED)
This happened only with non-plaintext authentication (e.g. DIGEST-MD5). Fixed also.
Hi Timo, silly question is there really a native failover mysql in dovecot ? cant remember this , i only remember this as part of dovecot proxiing
-- Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria