[Dovecot] mysql auth failover failing

[Robert Schetterer]

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