patch available: http://git.subdir.eu/paul/dbmail/patch/?id=321ce395d28f13b36cdb7b857b89dfd36bd0954e
On 04/21/2011 03:27 PM, G Weaver wrote: > I seem to be able to reliably reproduce the dbmail-imapd crash by using > incorrect users/passwords. > > The mail.log contains "no value for TLS_CIPHERS in config file" which is > true, but it's the final line that looks strange: > Apr 21 14:03:33 xxxxxx dbmail/imap4d[18343]: [0xcf24c0] Debug:[imap] > dbmail_imap_session_handle_auth(+1210): [0x7f78dc037200] trying to > validate user [(null)], pass [(null)] > > Dbmail appears to be trying to authenticate against the database with > user and passwd set to null. > > I wonder if this is related to this bug: > http://www.dbmail.org/mantis/view.php?id=829 > > Any suggestions for a fix or workaround? > > Thanks > > G > > On Tue, 19 Apr 2011 12:11:23 +0100, G Weaver wrote: >> On Tue, 19 Apr 2011 12:36:07 +0200, Paul J Stevens wrote: >>> On 19-04-11 12:16, G Weaver wrote: >>>> I'd be very grateful if anyone could help me with this problem. >>>> I have dbmail_3.0.0-rc2 installed and working with Postfix under Ubuntu >>>> 10.04 (on a VPS). >>>> >>>> I am seeing dbmail-imapd crashes a bit too often (three times since >>>> Saturday). The dbmail-imapd process dies, but the pid file is left in >>>> place. I usually use roundcube to check my email and all three of the >>>> crashes have occurred whilst logging in with roundcube (most of the >>>> time >>>> it does work). >>>> >>>> The error message in /var/log/dbmail.err is: >>>> dbmail-imapd: authsql.c:138: auth_getencryption: Assertion `user_idnr > >>>> 0' failed. >>> >>> Not good. Sounds like you didn't setup things correctly. There should >>> never be a normal user with user_idnr=0. >> >> Thanks for your quick response. >> >> I've just checked and there are no users with user_idnr=0. >> select user_idnr from dbmail_users; >> +-----------+ >> | user_idnr | >> +-----------+ >> | 1 | >> | 2 | >> | 3 | >> | 4 | >> | 5 | >> | 6 | >> | 7 | >> +-----------+ >> 7 rows in set (0.00 sec) >> >>> >>>> >>>> And the error messages in the roundcube log look like this: >>>> [19-Apr-2011 09:38:25 +0100]: IMAP Error: Login failed for * from >>>> *.*.*.*(X-Forwarded-For: *.*.*.*). AUTHENTICATE CRAM-MD5: in >>>> /var/www/roundcube/program/include/rcube_imap.php on line 192 (POST >>>> /?_task=login&_action=login) >>> >>> >>> Try bumping up the loglevel in dbmail (syslog_logging_level=511) and run >>> such a login session from roundcube. >>> >> Wasn't sure if I should be should be using syslog_logging_level=511 >> or syslog_logging_levels=511, so I set both. I now have lots of output >> in the syslog. >> I couldn't see any glaring problems, but it does look like >> dbmail-imapd makes a lot of database connections when I log in. >> >>> grep db_con_get syslog | grep 11:48:53 | wc -l >> 127 >> >> This was also in the syslog: database connection pool created with >> maximum connections of [10] >> >>> I see you're using cram-md5 authentication, so there should not be any >>> encryption on the passwords in the database. >>> >> There doesn't appear to be, the passwords in the dbmail_users table >> are in plain text. I can normally log-in via roundcube without issue, >> the crashes are usually just when I first login in the morning. If I >> experience any crashes while logging in with another client >> (Thunderbird) I will report back. >> >>> >>>> >>>> The dbmail.err modification time tallies with the time of the attempted >>>> login. >>>> >>>> Have I made a mistake compiling and configuring dbmail? Is this a bug? >>> >>> I don't no yet. >> >> Thanks again. I'll report back again if and when dbmail-imapd dies next. >> >> G >> _______________________________________________ >> DBmail mailing list >> [email protected] >> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
