DecimalPaul or Aron,
RoundCube Webmail now works fine, but i noticed something.
There one message that the body content doesn't apear, works great in OE,
thunderbird, squirrelmail, etc etc.
I've attached the raw message and the dbmail-imapd trace=5
Sinserely i don't find no error or warning message.
Can you see something?
If you say that all it's ok i go them contact the roundcube developer to see
what i can get.
if this is dbmail problem want me to write a bug report?
Jorge
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Message
serverchild.c,PerformChildTask: incoming connection from [192.168.1.221] by pid
[19386]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
serverchild.c,PerformChildTask: client info init complete, calling client
handler
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* OK dbmail imap
(protocol version 4r1) server 2.1 ready to run^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info COMMAND: [cp01 CAPABILITY]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Executing command capability...
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* CAPABILITY IMAP4
IMAP4rev1 AUTH=LOGIN ACL NAMESPACE CHILDREN SORT QUOTA^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [cp01 OK CAPABILITY
completed^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Finished command capability [0]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info COMMAND: [a001 LOGIN mypw
"mypw"]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[0]: 'mypw'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[1]: 'mypw'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Executing command login...
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,dbmail_imap_session_handle_auth: trying to validate user
[mypw], pass [XXXX]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT userid FROM dbmail_usermap WHERE 1 = 2]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c,db_use_usermap: enabling
usermap lookups
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c,db_usermap_resolve:
checking userid 'mypw' in usermap
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c,db_usermap_resolve:
client on inet socket [inet:192.168.1.222:143]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT login, sock_allow, sock_deny, userid FROM dbmail_usermap WHERE login in
('mypw','ANY') ORDER BY sock_allow, sock_deny]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c,db_usermap_resolve: login
'mypw' not found in usermap
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower('mypw')]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE user_idnr =
'15']
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug authsql.c,auth_validate:
validating using plaintext passwords
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[UPDATE dbmail_users SET last_login = '2006-09-06 10:03:16' WHERE user_idnr =
'15']
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Message
dbmail-imapsession.c,dbmail_imap_session_handle_auth: user (id:15, name mypw)
tries login
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Message
dbmail-imapsession.c,dbmail_imap_session_handle_auth: user (id 15, name mypw)
login accepted @ 2006-09-06 10:03:16
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [a001 OK LOGIN
completed^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Finished command login [0]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info COMMAND: [ns1 NAMESPACE]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Executing command namespace...
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* NAMESPACE ((""
"/")) (("#Users" "/")) (("#Public" "/"))^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [ns1 OK NAMESPACE
complete^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Finished command namespace [0]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info COMMAND: [ns1 NAMESPACE]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Executing command namespace...
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* NAMESPACE ((""
"/")) (("#Users" "/")) (("#Public" "/"))^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [ns1 OK NAMESPACE
complete^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Finished command namespace [0]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info COMMAND: [sel1 SELECT "INBOX"]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[0]: 'INBOX'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Executing command select...
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c,db_findmailbox: looking
for mailbox with FQN [INBOX].
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name LIKE 'INBOX' AND
owner_idnr='15']
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c,db_acl_has_right:
checking ACL [read_flag] for user [15] on mailbox [36]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '36']
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c, db_acl_has_right:
mailbox [36] is owned by user [15], is that also [15]?
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c, db_acl_has_right:
mailbox [36] is owned by user [15], giving all rights
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '36']
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '36']
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='36' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='36' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='36' AND (status='0' OR
status='1') AND recent_flag=1]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '36' AND status
IN ('0','1') ORDER BY message_idnr ASC]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c,db_getmailbox_count:
exists [17]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* 17 EXISTS^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* 0 RECENT^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* FLAGS (\Seen
\Answered \Deleted \Flagged \Draft \Recent)^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* OK
[PERMANENTFLAGS (\Seen \Answered \Deleted \Flagged \Draft \Recent)]^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* OK [UIDNEXT
390694] Predicted next UID^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* OK [UIDVALIDITY
36] UID value^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT MIN(message_idnr) FROM dbmail_messages WHERE mailbox_idnr = '36' AND
status < '2' AND seen_flag = '0']
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* OK [UNSEEN 6]
first unseen message^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE recent_flag = 1 AND
mailbox_idnr = '36']
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,dbmail_imap_session_mailbox_select_recent: recent [0] in
mailbox [36]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [sel1 OK
[READ-WRITE] SELECT completed^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Finished command select [0]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info COMMAND: [srch1 SEARCH UID
387465]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[0]: 'UID'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[1]: '387465'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Executing command search...
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c,db_acl_has_right:
checking ACL [read_flag] for user [15] on mailbox [36]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '36']
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c, db_acl_has_right:
mailbox [36] is owned by user [15], is that also [15]?
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c, db_acl_has_right:
mailbox [36] is owned by user [15], giving all rights
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '36' AND status
IN ('0','1') ORDER BY message_idnr]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-mailbox.c,append_search: [134798472] [1] type [2] field [] search [1:*]
at depth [1]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug misc.c,check_msg_set: [387465]
[ok]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-mailbox.c,append_search: [134802736] [0] type [2] field [] search
[387465] at depth [1]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-mailbox.c,dbmail_mailbox_get_set: [1:*]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug misc.c,g_tree_merge: a[0] [OR]
b[17] -> a[17]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmail-mailbox.c,_do_search:
[134798472] depth [1] type [2] rows [17]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-mailbox.c,dbmail_mailbox_get_set: [387465]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug misc.c,g_tree_merge: a[0] [OR]
b[1] -> a[1]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmail-mailbox.c,_do_search:
[134802736] depth [2] type [2] rows [1]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-mailbox.c,_merge_search: [134798472] depth [1] type [2]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug misc.c,g_tree_merge: a[17]
[AND] b[17] -> a[17]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-mailbox.c,_merge_search: [134802736] depth [2] type [2]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug misc.c,g_tree_merge: a[17]
[AND] b[1] -> a[1]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-mailbox.c,dbmail_mailbox_search: found [1] ids
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* SEARCH 9]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [^M srch1 OK SEARCH
completed^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Finished command search [0]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info COMMAND: [F1247 FETCH 9
(BODYSTRUCTURE)]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[0]: '9'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[1]: '('
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[2]: 'BODYSTRUCTURE'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[3]: ')'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Executing command fetch...
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c,db_acl_has_right:
checking ACL [read_flag] for user [15] on mailbox [36]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c, db_acl_has_right:
mailbox [36] is owned by user [15], is that also [15]?
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c, db_acl_has_right:
mailbox [36] is owned by user [15], giving all rights
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] =
[BODYSTRUCTURE]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] =
BODYSTRUCTURE (returning 3)
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] = [)]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug imapcommands.c,_ic_fetch:
fetch_start [8] fetch_end [8]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag,
recent_flag, DATE_FORMAT(internal_date, '%Y-%m-%d %T'), rfcsize, message_idnr
FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id =
msg.physmessage_id AND message_idnr BETWEEN '387465' AND '387465' AND
mailbox_idnr = '36' AND status IN ('0','1') ORDER BY message_idnr ASC]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* 9 FETCH (]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,_imap_cache_update: cache message [387465] filter [1]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '387465']
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT messageblk FROM dbmail_messageblks WHERE physmessage_id = '191396'
ORDER BY messageblk_idnr]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-message.c,_set_content_from_stream: parse message
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,_imap_cache_update: cache size [1413]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dm_imaputil.c,imap_get_structure: message type: [text/plain]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [BODYSTRUCTURE
("text" "plain" NIL NIL NIL "7BIT" 246 8 NIL NIL NIL NIL)]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [)^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [F1247 OK FETCH
completed^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Finished command fetch [0]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info COMMAND: [FUID FETCH 9 (UID)]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[0]: '9'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[1]: '('
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[2]: 'UID'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[3]: ')'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Executing command fetch...
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c,db_acl_has_right:
checking ACL [read_flag] for user [15] on mailbox [36]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c, db_acl_has_right:
mailbox [36] is owned by user [15], is that also [15]?
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c, db_acl_has_right:
mailbox [36] is owned by user [15], giving all rights
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] = [UID]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] = UID
(returning 3)
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] = [)]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug imapcommands.c,_ic_fetch:
fetch_start [8] fetch_end [8]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag,
recent_flag, DATE_FORMAT(internal_date, '%Y-%m-%d %T'), rfcsize, message_idnr
FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id =
msg.physmessage_id AND message_idnr BETWEEN '387465' AND '387465' AND
mailbox_idnr = '36' AND status IN ('0','1') ORDER BY message_idnr ASC]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* 9 FETCH (]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [UID 387465]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [)^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [FUID OK FETCH
completed^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Finished command fetch [0]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info COMMAND: [FUID FETCH 10 (UID)]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[0]: '10'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[1]: '('
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[2]: 'UID'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[3]: ')'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Executing command fetch...
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c,db_acl_has_right:
checking ACL [read_flag] for user [15] on mailbox [36]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c, db_acl_has_right:
mailbox [36] is owned by user [15], is that also [15]?
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c, db_acl_has_right:
mailbox [36] is owned by user [15], giving all rights
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] = [UID]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] = UID
(returning 3)
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] = [)]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug imapcommands.c,_ic_fetch:
fetch_start [9] fetch_end [9]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag,
recent_flag, DATE_FORMAT(internal_date, '%Y-%m-%d %T'), rfcsize, message_idnr
FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id =
msg.physmessage_id AND message_idnr BETWEEN '387820' AND '387820' AND
mailbox_idnr = '36' AND status IN ('0','1') ORDER BY message_idnr ASC]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* 10 FETCH (]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [UID 387820]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [)^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [FUID OK FETCH
completed^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Finished command fetch [0]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info COMMAND: [FUID FETCH 8 (UID)]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[0]: '8'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[1]: '('
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[2]: 'UID'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug arg[3]: ')'
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Executing command fetch...
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c,db_acl_has_right:
checking ACL [read_flag] for user [15] on mailbox [36]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c, db_acl_has_right:
mailbox [36] is owned by user [15], is that also [15]?
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug db.c, db_acl_has_right:
mailbox [36] is owned by user [15], giving all rights
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] = [UID]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] = UID
(returning 3)
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] = [)]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug imapcommands.c,_ic_fetch:
fetch_start [7] fetch_end [7]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug dbmysql.c,db_query: query
[SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag,
recent_flag, DATE_FORMAT(internal_date, '%Y-%m-%d %T'), rfcsize, message_idnr
FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id =
msg.physmessage_id AND message_idnr BETWEEN '386773' AND '386773' AND
mailbox_idnr = '36' AND status IN ('0','1') ORDER BY message_idnr ASC]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [* 8 FETCH (]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [UID 386773]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [)^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Debug RESPONSE: [FUID OK FETCH
completed^M ]
Sep 6 10:03:16 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Finished command fetch [0]
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Info COMMAND: [ghd LIST "" ""]
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Debug arg[0]: ''
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Debug arg[1]: ''
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Executing command list...
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Debug RESPONSE: [* LIST (\NoSelect)
"/" ""^M ]
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Debug RESPONSE: [ghd OK LIST
completed^M ]
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Finished command list [0]
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Info COMMAND: [I LOGOUT]
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Executing command logout...
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Message imapcommands.c,_ic_logout:
user (id:15) logging out @ [2006-09-06 10:03:17]
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Debug RESPONSE: [* BYE dbmail imap
server kisses you goodbye^M ]
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Info imap4.c,IMAPClientHandler:
Finished command logout [0]
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Debug RESPONSE: [I OK completed^M ]
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Message imap4.c,IMAPClientHandler:
Closing connection for client from IP [192.168.1.221]
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Debug
serverchild.c,PerformChildTask: client handling complete, closing streams
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Info serverchild.c,PerformChildTask:
connection closed
Sep 6 10:03:17 lira dbmail/imap4d[19386]: Info serverchild.c,PerformChildTask:
waiting for connection
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Message
serverchild.c,PerformChildTask: incoming connection from [192.168.1.221] by pid
[19388]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug
serverchild.c,PerformChildTask: client info init complete, calling client
handler
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug RESPONSE: [* OK dbmail imap
(protocol version 4r1) server 2.1 ready to run^M ]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info COMMAND: [cp01 CAPABILITY]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info imap4.c,IMAPClientHandler:
Executing command capability...
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug RESPONSE: [* CAPABILITY IMAP4
IMAP4rev1 AUTH=LOGIN ACL NAMESPACE CHILDREN SORT QUOTA^M ]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug RESPONSE: [cp01 OK CAPABILITY
completed^M ]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info imap4.c,IMAPClientHandler:
Finished command capability [0]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info COMMAND: [a001 LOGIN mypw
"mypw"]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug arg[0]: 'mypw'
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug arg[1]: 'mypw'
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info imap4.c,IMAPClientHandler:
Executing command login...
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug
dbmail-imapsession.c,dbmail_imap_session_handle_auth: trying to validate user
[mypw], pass [XXXX]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug dbmysql.c,db_query: query
[SELECT userid FROM dbmail_usermap WHERE 1 = 2]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug db.c,db_use_usermap: enabling
usermap lookups
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug db.c,db_usermap_resolve:
checking userid 'mypw' in usermap
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug db.c,db_usermap_resolve:
client on inet socket [inet:192.168.1.222:143]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug dbmysql.c,db_query: query
[SELECT login, sock_allow, sock_deny, userid FROM dbmail_usermap WHERE login in
('mypw','ANY') ORDER BY sock_allow, sock_deny]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug db.c,db_usermap_resolve: login
'mypw' not found in usermap
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug dbmysql.c,db_query: query
[SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower('mypw')]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug dbmysql.c,db_query: query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE user_idnr =
'15']
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug authsql.c,auth_validate:
validating using plaintext passwords
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug dbmysql.c,db_query: query
[UPDATE dbmail_users SET last_login = '2006-09-06 10:03:17' WHERE user_idnr =
'15']
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Message
dbmail-imapsession.c,dbmail_imap_session_handle_auth: user (id:15, name mypw)
tries login
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Message
dbmail-imapsession.c,dbmail_imap_session_handle_auth: user (id 15, name mypw)
login accepted @ 2006-09-06 10:03:17
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug RESPONSE: [a001 OK LOGIN
completed^M ]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info imap4.c,IMAPClientHandler:
Finished command login [0]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info COMMAND: [ns1 NAMESPACE]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info imap4.c,IMAPClientHandler:
Executing command namespace...
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug RESPONSE: [* NAMESPACE ((""
"/")) (("#Users" "/")) (("#Public" "/"))^M ]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug RESPONSE: [ns1 OK NAMESPACE
complete^M ]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info imap4.c,IMAPClientHandler:
Finished command namespace [0]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info COMMAND: [ns1 NAMESPACE]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info imap4.c,IMAPClientHandler:
Executing command namespace...
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug RESPONSE: [* NAMESPACE ((""
"/")) (("#Users" "/")) (("#Public" "/"))^M ]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug RESPONSE: [ns1 OK NAMESPACE
complete^M ]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info imap4.c,IMAPClientHandler:
Finished command namespace [0]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info COMMAND: [I LOGOUT]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info imap4.c,IMAPClientHandler:
Executing command logout...
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Message imapcommands.c,_ic_logout:
user (id:15) logging out @ [2006-09-06 10:03:17]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug RESPONSE: [* BYE dbmail imap
server kisses you goodbye^M ]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info imap4.c,IMAPClientHandler:
Finished command logout [0]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug RESPONSE: [I OK completed^M ]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Message imap4.c,IMAPClientHandler:
Closing connection for client from IP [192.168.1.221]
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Debug
serverchild.c,PerformChildTask: client handling complete, closing streams
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info serverchild.c,PerformChildTask:
connection closed
Sep 6 10:03:17 lira dbmail/imap4d[19388]: Info serverchild.c,PerformChildTask:
waiting for connection
Received: from smtp.decimal.pt (localhost.localdomain [127.0.0.1])
by smtp.decimal.pt (Postfix) with ESMTP id BE7D34DAD8
for <[EMAIL PROTECTED]>; Tue, 5 Sep 2006 03:02:52 +0100 (WEST)
Received: by smtp.decimal.pt (Postfix, from userid 1001) id B1B2C41735;
Tue, 5 Sep 2006 03:02:52 +0100 (WEST)
X-Spam-Checker-Version: SpamAssassin 3.1.4 (2006-07-26) on lira
X-Spam-Level:
X-Spam-Status: No, score=0.7 required=5.0
tests=AWL,BAYES_00,FORGED_RCVD_HELO,
NO_REAL_NAME,SUBJ_ILLEGAL_CHARS autolearn=no version=3.1.4
Received: from webserver.decimal.pt (web.decimal.pt [195.23.114.74])
by smtp.decimal.pt (Postfix) with SMTP id 41E744DAD8
for <[EMAIL PROTECTED]>; Tue, 5 Sep 2006 03:02:51 +0100 (WEST)
Received: (qmail 3826 invoked by uid 0); 5 Sep 2006 02:01:01 -0000
Date: 5 Sep 2006 02:01:01 -0000
Message-ID: <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Situação irregular com alojamento
From: [EMAIL PROTECTED]
X-Mailer: PHP mail client v69
X-Virus-Scanned: ClamAV using ClamSMTP
Return-Path: [EMAIL PROTECTED]
X-DBMail-PhysMessage-ID: 191396
MIME-Version: 1.0
O alojamento com os seguintes dados está em situação irregular, ou desistiu:
Utilizador do alojamento: merald.com
Nome empresa:
Email Contacto: [EMAIL PROTECTED]
O alojamento já ultrapassou -4 dias que deveria ter efectuado o pagamento.