Here's the trace level 5 log from trying to read the message:
Dec 21 12:48:15 [dbmail/imap4d] Info:[serverchild]
serverchild.c,select_and_accept(+252):
received connection
Dec 21 12:48:15 [dbmail/imap4d] Info:[serverchild]
serverchild.c,select_and_accept(+275):
connection accepted
Dec 21 12:48:15 [dbmail/imap4d] Message:[serverchild]
serverchild.c,PerformChildTask(+339):
incoming connection from [154.5.40.236 (d154-5-40-236.bchsia.telus.net)] by
pid [30318]
Dec 21 12:48:15 [dbmail/imap4d] Debug:[serverchild]
serverchild.c,PerformChildTask(+365):
client info init complete, calling client handler
Dec 21 12:48:15 [dbmail/imap4d] Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1301):
RESPONSE: [* OK dbmail imap (protocol version 4r1) server 2.2 ready to
run__]
Dec 21 12:48:15 [dbmail/imap4d] Info:[imap] imap4.c,IMAPClientHandler(+200):
COMMAND: [1 capability]_
Dec 21 12:48:15 [dbmail/imap4d] Info:[imap] imap4.c,IMAPClientHandler(+313):
Executing command capability..._
Dec 21 12:48:15 [dbmail/imap4d] Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1303):
RESPONSE: [* CAPABILITY IMAP4 IMAP4rev1 AUTH=LOGIN ACL NAMESPACE CHILDREN
SORT QUOTA THREAD=ORDEREDSUBJECT UNS...]
Dec 21 12:48:15 [dbmail/imap4d] Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1301):
RESPONSE: [1 OK CAPABILITY completed__]
Dec 21 12:48:15 [dbmail/imap4d] Info:[imap] imap4.c,IMAPClientHandler(+341):
Finished command capability [0]_
Dec 21 12:48:15 [dbmail/imap4d] Info:[imap] imap4.c,IMAPClientHandler(+200):
COMMAND: [2 authenticate login]_
Dec 21 12:48:15 [dbmail/imap4d] Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2125):
arg[0]: 'login'_
Dec 21 12:48:15 [dbmail/imap4d] Info:[imap] imap4.c,IMAPClientHandler(+313):
Executing command authenticate..._
Dec 21 12:48:15 [dbmail/imap4d] Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1301):
RESPONSE: [+ dXNlcm5hbWUNCg==__]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1301):
RESPONSE: [+ cGFzc3dvcmQNCg==__]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_handle_auth(+1382):
trying to validate user [recipient], pass [XXXX]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[sql] dbpgsql.c,db_query(+279):
[SELECT userid FROM dbmail_usermap WHERE 1 = 2]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[db] db.c,db_use_usermap(+161):
enabling usermap lookups
Dec 21 12:48:16 [dbmail/imap4d] Debug:[db] db.c,db_usermap_resolve(+4401):
checking userid [recipient] in usermap
Dec 21 12:48:16 [dbmail/imap4d] Debug:[db] db.c,db_usermap_resolve(+4412):
client on inet socket [inet:70.70.206.15:143]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[sql] dbpgsql.c,db_query(+279):
[SELECT login, sock_allow, sock_deny, userid FROM dbmail_usermap WHERE login
in ('recipient','ANY') ORDER BY sock_allow, sock_deny]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[db] db.c,db_usermap_resolve(+4438):
login [recipient] not found in usermap
Dec 21 12:48:16 [dbmail/imap4d] Debug:[sql] dbpgsql.c,db_query(+279):
[SELECT user_idnr FROM dbmail_users WHERE lower(userid) =
lower('recipient')]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[sql] dbpgsql.c,db_query(+279):
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE user_idnr
= 3]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[auth] authsql.c,auth_validate(+413):
validating using plaintext passwords
Dec 21 12:48:16 [dbmail/imap4d] Debug:[sql] dbpgsql.c,db_query(+279):
[UPDATE dbmail_users SET last_login = '2006-12-21 12:48:16' WHERE user_idnr
= 3]
Dec 21 12:48:16 [dbmail/imap4d] Message:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_handle_auth(+1387):
user (id:3, name recipient) tries login
Dec 21 12:48:16 [dbmail/imap4d] Message:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_handle_auth(+1408):
user (id 3, name recipient) login accepted
Dec 21 12:48:16 [dbmail/imap4d] Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1301):
RESPONSE: [2 OK AUTHENTICATE completed__]
Dec 21 12:48:16 [dbmail/imap4d] Info:[imap] imap4.c,IMAPClientHandler(+341):
Finished command authenticate [0]_
Dec 21 12:48:16 [dbmail/imap4d] Info:[imap] imap4.c,IMAPClientHandler(+200):
COMMAND: [3 select "INBOX"]_
Dec 21 12:48:16 [dbmail/imap4d] Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2125):
arg[0]: 'INBOX'_
Dec 21 12:48:16 [dbmail/imap4d] Info:[imap] imap4.c,IMAPClientHandler(+313):
Executing command select..._
Dec 21 12:48:16 [dbmail/imap4d] Debug:[db] db.c,db_findmailbox(+2296):
looking for mailbox with FQN [INBOX].
Dec 21 12:48:16 [dbmail/imap4d] Debug:[sql] dbpgsql.c,db_query(+279):
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name ILIKE 'INBOX' AND
owner_idnr=3]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[db] db.c,db_acl_has_right(+3956):
checking ACL [read_flag] for user [3] on mailbox [1]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[sql] dbpgsql.c,db_query(+279):
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = 1]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[db] db.c,db_acl_has_right(+3966):
mailbox [1] is owned by user [3], is that also [3]?
Dec 21 12:48:16 [dbmail/imap4d] Debug:[db] db.c,db_acl_has_right(+3970):
mailbox [1] is owned by user [3], giving all rights
Dec 21 12:48:16 [dbmail/imap4d] Debug:[sql] dbpgsql.c,db_query(+279):
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = 1]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[sql] dbpgsql.c,db_query(+279):
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = 1]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[sql] dbpgsql.c,db_query(+279):
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=1 AND (status <
2) UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=1 AND
(status < 2) AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages
WHERE mailbox_idnr=1 AND (status < 2) AND recent_flag=1]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[sql] dbpgsql.c,db_query(+279):
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = 1 AND status
< 2 ORDER BY message_idnr ASC]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[db] db.c,db_getmailbox_count(+2668):
exists [10]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[sql] dbpgsql.c,db_query(+279):
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT
1]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[sql] dbpgsql.c,db_query(+279):
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = 1 AND status
IN (0,1) ORDER BY message_idnr]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1301):
RESPONSE: [* 10 EXISTS__]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1301):
RESPONSE: [* 0 RECENT__]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1301):
RESPONSE: [* FLAGS (\Seen \Answered \Deleted \Flagged \Draft \Recent)__]
Dec 21 12:48:16 [dbmail/imap4d] Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1301):
RESPONSE: [* OK [PERMANENTFLAGS (\Seen \Answered \Deleted \Flagged \Draft
\Recent)]__]
Thanks for the help,
David
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
