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 memoryCan 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