Hi
We recently transfered over a bunch of users (as you might expect by
now) from cucimail into dbmail.
However we get some users mailclients somehow not loggin in right,
meaning APOP fails, but then the client reconnects with plain login
and succeeds.
Is this a client bug ( I presume them using outlook express) or is it
something in dbmail.
Passwords are plaintext in the db.
Some log exports here:
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug
serverchild.c,PerformChildTask: client info init complete, calling
client handler
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug
misc.c,create_unique_id: created: 0aab1f0181beb2d8c0c09b7f7be91854
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug pop3.c,pop3:
incoming buffer: [APOP vanhoorn 6af00b4e4f64ffc00021ce6b8eaaf1]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug pop3.c,pop3:
command issued :cmd [APOP], value [vanhoorn
6af00b4e4f64ffc00021ce6b8eaaf1]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug pop3.c,pop3:
command looked up as commandtype 11
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug module pgsql file
dbpgsql.c func db_query line 281: [SELECT user_idnr FROM dbmail_users
WHERE lower(userid) = lower('vanhoorn')]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Error
authsql.c,auth_getencryption: got (0) as userid
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug pop3.c,pop3: APOP
auth, username [vanhoorn], md5_hash [6af00b4e4f64ffc00021ce6b8eaaf1]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug module pgsql file
dbpgsql.c func db_query line 281: [SELECT user_idnr FROM dbmail_users
WHERE lower(userid) = lower('vanhoorn')]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug module pgsql file
dbpgsql.c func db_query line 281: [SELECT passwd,user_idnr FROM
dbmail_users WHERE user_idnr = 0]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Error pop3.c,pop3: user
[vanhoorn] tried to login with wrong password
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug
pop3.c,pop3_error: an invalid command was issued
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug pop3.c,pop3:
incoming buffer: [USER vanhoorn]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug pop3.c,pop3:
command issued :cmd [USER], value [vanhoorn]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug pop3.c,pop3:
command looked up as commandtype 1
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug pop3.c,pop3:
incoming buffer: [PASS XXXXX]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug pop3.c,pop3:
command issued :cmd [PASS], value [XXXXX]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug pop3.c,pop3:
command looked up as commandtype 2
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug module db file
db.c func db_usermap_resolve line 4389: checking userid [vanhoorn] in
usermap
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug module db file
db.c func db_usermap_resolve line 4400: client on inet socket [inet:
212.125.128.10:110]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug module pgsql file
dbpgsql.c func db_query line 281: [SELECT login, sock_allow,
sock_deny, userid FROM dbmail_usermap WHERE login in
('vanhoorn','ANY') ORDER BY sock_allow, sock_deny]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug
misc.c,dm_sock_compare: clientsock [inet:212.125.128.10:110]
sock_allow[], sock_deny [] => [0]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug
misc.c,dm_sock_score: base[inet:212.125.128.10:110] test[inet:
10.0.0.6:110] => [0]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug
misc.c,dm_sock_compare: clientsock [inet:212.125.128.10:110]
sock_allow[], sock_deny [] => [0]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug
misc.c,dm_sock_score: base[inet:212.125.128.10:110] test[inet:
212.125.128.10:110] => [32]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug
misc.c,dm_sock_compare: clientsock [inet:212.125.128.10:110]
sock_allow[], sock_deny [] => [0]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug
misc.c,dm_sock_score: base[inet:212.125.128.10:110] test[inet:
212.125.128.6:110] => [0]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug module db file
db.c func db_usermap_resolve line 4451: bestscore [32]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug module db file
db.c func db_usermap_resolve line 4459: best match: [ANY] -> [%
[EMAIL PROTECTED]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug module db file
db.c func db_usermap_resolve line 4470: [vanhoorn] maps to
[EMAIL PROTECTED]
Nov 4 22:56:11 hercules dbmail/pop3d[21191]: Debug module pgsql file
dbpgsql.c func db_query line 281: [SELECT user_idnr FROM dbmail_users
WHERE lower(userid) = lower('[EMAIL PROTECTED]')]
Nov 4 22:56:12 hercules dbmail/pop3d[21191]: Debug module pgsql file
dbpgsql.c func db_query line 281: [SELECT user_idnr, passwd,
encryption_type FROM dbmail_users WHERE user_idnr = 6391]
Nov 4 22:56:12 hercules dbmail/pop3d[21191]: Debug
authsql.c,auth_validate: validating using plaintext passwords
Nov 4 22:56:12 hercules dbmail/pop3d[21191]: Debug module pgsql file
dbpgsql.c func db_query line 281: [UPDATE dbmail_users SET last_login
= '2006-11-04 22:56:12' WHERE user_idnr = 6391]
Nov 4 22:56:12 hercules dbmail/pop3d[21191]: Debug pop3.c,pop3:
validation OK, building a session for user [vanhoorn]
Nov 4 22:56:12 hercules dbmail/pop3d[21191]: Debug module db file
db.c func db_findmailbox line 2284: looking for mailbox with FQN
[INBOX].
Nov 4 22:56:12 hercules dbmail/pop3d[21191]: Debug module pgsql file
dbpgsql.c func db_query line 281: [SELECT mailbox_idnr FROM
dbmail_mailboxes WHERE name ILIKE 'INBOX' AND owner_idnr
=6391]
Nov 4 22:56:12 hercules dbmail/pop3d[21191]: Debug module db file
db.c func db_find_create_mailbox line 3117: mailbox [INBOX] found
Nov 4 22:56:12 hercules dbmail/pop3d[21191]: Debug module pgsql file
dbpgsql.c func db_query line 281: [SELECT pm.messagesize,
msg.message_idnr, msg.status, msg.unique_id FROM dbmail_me
ssages msg, dbmail_physmessage pm WHERE msg.mailbox_idnr = 2206 AND
msg.status < 2 AND msg.physmessage_id = pm.id ORDER BY
msg.message_idnr ASC]
Nov 4 22:56:12 hercules dbmail/pop3d[21191]: Message pop3.c,pop3:
user vanhoorn logged in [messages=0, octets=0]
Met vriendelijke groet,
Marc Dirix
Electronics Design
Graaf Wolter Hoenstraat 2
6243 BE Geulle
Tel. 06 27056985
[EMAIL PROTECTED]
