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
