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@dovecot.org wrote:

Message: 6 Date: Tue, 7 Feb 2006 11:33:23 +0200 From: Alexander Shikoff minotaur@crete.org.ua Subject: [Dovecot] MySQL client out of memory error To: dovecot@dovecot.org Message-ID: 20060207093323.GA31385@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@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@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@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@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@crete.org.ua