[Dovecot] Re: MySQL client out of memory error

[Roger Weeks]

Alexander -

We had this exact same issue with MySQL authentication.  We resolved  
it by changing this entry in the auth section of the dovecot.conf:

   # Number of authentication processes to create
   #count = 1

We set count=20, and then through testing lowered it to count=10.   
This starts 10 auth-worker processes and to this point we have not  
had problems with the out of memory condition.

--
Roger J. Weeks
Systems & Network Administrator
Mendocino Community Network
Now offering DSL across California

On Feb 7, 2006, at 2:00 AM, dovecot-request at dovecot.org wrote:

> Message: 6
> Date: Tue, 7 Feb 2006 11:33:23 +0200
> From: Alexander Shikoff <minotaur at crete.org.ua>
> Subject: [Dovecot] MySQL client out of memory error
> To: dovecot at dovecot.org
> Message-ID: <20060207093323.GA31385 at crete.org.ua>
> Content-Type: text/plain; charset=koi8-u
>
> Hi,
>
> I'm using Dovecot 1.0-alpha5 as POP3 server with MySQL DB of users.
> Sometimes clients get an authentication errors. In this time dovecot
> writes to log file next lines:
> Feb  7 11:14:30 orion dovecot: auth-worker(default): sql 
> (user at mydomain.com.ua,192.168.3.36): Password query failed: MySQL  
> client run out of memory
> Feb  7 11:14:30 orion dovecot: auth-worker(default): sql 
> (user at mydomain.com.ua,192.168.3.36): Password query failed: MySQL  
> client run out of memory
> Feb  7 11:14:33 orion dovecot: auth-worker(default): sql 
> (user at mydomain.com.ua,192.168.3.36): Password query failed: MySQL  
> client run out of memory
> Feb  7 11:14:33 orion dovecot: auth-worker(default): sql 
> (user at mydomain.com.ua,192.168.3.36): Password query failed: MySQL  
> client run out of memory
>
> Can anybody say is there a bug in dovecot or this this issue is
> mysql-specific problem?
>
> Thanks in advance, Alexander
>
> -- 
> Kind Regards,	Alexander Shikoff
> minotaur at crete.org.ua