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
Alexander Shikoff wrote:> 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?There was a memory leak fixed in the mysql driver, so you might want to use the CVS current, wait for beta3 (better than use alphax, anyway), or fix it yourself (should be not that hard).
Alexander Shikoff wrote:>> > Can anybody say is there a bug in dovecot or this this issue is >> > mysql-specific problem? >> There was a memory leak fixed in the mysql driver, so you might want to >> use the CVS current, wait for beta3 (better than use alphax, anyway), or >> fix it yourself (should be not that hard). > Thanks a lot! > /me is going to download one of the latest CVS snapshots.You are welcome. I'd say they are usually quite stable and a good way to check if your problem was fixed, even if you only look into the changelog. PS: Please keep list traffic on the list and honour other people's Reply-To header.
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