On Thu, Mar 09, 2006 at 04:08:26PM -0600, Matthew Sayler wrote: > I'm wondering if anyone has heard reports of Mail.app (OS X 10.4) > crashing on reading from dbmail 2.1.5 (did not happen in 2.0.9). I have > a couple of users for whom this is true, and I'm currently looking for a > replication scenario. > > Obviously dbmail should not be able to cause Mail.app to crash (== > Mail.app bug) but I'm curious if anyone else has seen this. I'll follow > up once I can reproduce the problem.
More details: I have a L5 IMAP trace and some DB dumps for (what I think is) the message in question. Any thoughts? The trace continues in the exact same pattern for about 7 minutes while Mail.app requests the same info over and over. I assume at some point an internal buffer blows up. This message was added to the system by 2.0.7 (I think) and was processed dbmail -by when I upgraded to 2.1.5 from 2.0.9. Requests for more information will be answered promptly -- potential answers with gratitude. Regards, Matt
Mar 9 16:59:25 octo dbmail/imap4d[14495]: pool.c,child_reg_connected: [14495] Mar 9 16:59:25 octo dbmail/imap4d[14495]: serverchild.c,PerformChildTask: incoming connection from [206.126.251.167 (justicebork.speedsite.com)] by pid [14495] Mar 9 16:59:25 octo dbmail/imap4d[14495]: serverchild.c,PerformChildTask: client info init complete, calling client handler Mar 9 16:59:25 octo dbmail/imap4d[14495]: RESPONSE: [* OK dbmail imap (protocol version 4r1) server 2.1 ready to run ] Mar 9 16:59:25 octo dbmail/imap4d[14495]: COMMAND: [1 LOGIN sayler XXXXXX] Mar 9 16:59:25 octo dbmail/imap4d[14495]: arg[0]: 'sayler' Mar 9 16:59:25 octo dbmail/imap4d[14495]: arg[1]: 'XXXXXX' Mar 9 16:59:25 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command login... Mar 9 16:59:25 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_handle_auth: trying to validate user [sayler], pass [XXXX] Mar 9 16:59:25 octo dbmail/imap4d[14495]: db.c,db_usermap_resolve: checking userid 'sayler' in usermap Mar 9 16:59:25 octo dbmail/imap4d[14495]: db.c,db_usermap_resolve: client on inet socket [inet:206.126.224.5:144] Mar 9 16:59:25 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT login, sock_allow, sock_deny, userid FROM dbmail_usermap WHERE login in ('sayler','ANY') ORDER BY sock_allow, sock_deny] Mar 9 16:59:25 octo dbmail/imap4d[14495]: db.c,db_usermap_resolve: login 'sayler' not found in usermap Mar 9 16:59:25 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower('sayler')] Mar 9 16:59:25 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE user_idnr = '4'] Mar 9 16:59:25 octo dbmail/imap4d[14495]: authsql.c,auth_validate: validating using plaintext passwords Mar 9 16:59:25 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [UPDATE dbmail_users SET last_login = '2006-03-09 16:59:25' WHERE user_idnr = '4'] Mar 9 16:59:25 octo dbmail/imap4d[14495]: dbmysql.c,db_query: res was not freed after the previous query! Mar 9 16:59:25 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_handle_auth: user (id:4, name sayler) tries login Mar 9 16:59:25 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_handle_auth: user (id 4, name sayler) login accepted @ 2006-03-09 16:59:25 Mar 9 16:59:25 octo dbmail/imap4d[14495]: RESPONSE: [1 OK LOGIN completed ] Mar 9 16:59:25 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command login [0] Mar 9 16:59:25 octo dbmail/imap4d[14495]: COMMAND: [2 CAPABILITY] Mar 9 16:59:25 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command capability... Mar 9 16:59:25 octo dbmail/imap4d[14495]: RESPONSE: [* CAPABILITY IMAP4 IMAP4rev1 AUTH=LOGIN ACL NAMESPACE CHILDREN SORT QUOTA ] Mar 9 16:59:25 octo dbmail/imap4d[14495]: RESPONSE: [2 OK CAPABILITY completed ] Mar 9 16:59:25 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command capability [0] Mar 9 16:59:25 octo dbmail/imap4d[14495]: COMMAND: [3 LIST "" ""] Mar 9 16:59:25 octo dbmail/imap4d[14495]: arg[0]: '' Mar 9 16:59:25 octo dbmail/imap4d[14495]: arg[1]: '' Mar 9 16:59:25 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command list... Mar 9 16:59:25 octo dbmail/imap4d[14495]: RESPONSE: [* LIST (\NoSelect) "/" "" ] Mar 9 16:59:25 octo dbmail/imap4d[14495]: RESPONSE: [3 OK LIST completed ] Mar 9 16:59:25 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command list [0] Mar 9 16:59:25 octo dbmail/imap4d[14495]: COMMAND: [4 STATUS Drafts (MESSAGES UIDNEXT)] Mar 9 16:59:25 octo dbmail/imap4d[14495]: arg[0]: 'Drafts' Mar 9 16:59:25 octo dbmail/imap4d[14495]: arg[1]: '(' Mar 9 16:59:25 octo dbmail/imap4d[14495]: arg[2]: 'MESSAGES' Mar 9 16:59:25 octo dbmail/imap4d[14495]: arg[3]: 'UIDNEXT' Mar 9 16:59:25 octo dbmail/imap4d[14495]: arg[4]: ')' Mar 9 16:59:25 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command status... Mar 9 16:59:25 octo dbmail/imap4d[14495]: db.c,db_findmailbox: looking for mailbox with FQN [Drafts]. Mar 9 16:59:25 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Drafts' AND owner_idnr='4'] Mar 9 16:59:25 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [136] Mar 9 16:59:25 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '136' AND owner_idnr = '4'] Mar 9 16:59:25 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = '136'] Mar 9 16:59:25 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='136' AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='136' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='136' AND (status='0' OR status='1') AND recent_flag=1] Mar 9 16:59:25 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] Mar 9 16:59:25 octo dbmail/imap4d[14495]: RESPONSE: [* STATUS "Drafts" (MESSAGES 0 UIDNEXT 625883) ] Mar 9 16:59:25 octo dbmail/imap4d[14495]: RESPONSE: [4 OK STATUS completed ] Mar 9 16:59:25 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command status [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: COMMAND: [5 STATUS INBOX.Drafts (UNSEEN UIDNEXT)] Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[0]: 'INBOX.Drafts' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[1]: '(' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[2]: 'UNSEEN' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[3]: 'UIDNEXT' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[4]: ')' Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command status... Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_findmailbox: looking for mailbox with FQN [INBOX.Drafts]. Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX.Drafts' AND owner_idnr='4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [142] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '142' AND owner_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = '142'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='142' AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='142' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='142' AND (status='0' OR status='1') AND recent_flag=1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* STATUS "INBOX.Drafts" (UNSEEN 0 UIDNEXT 625883) ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [5 OK STATUS completed ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command status [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: COMMAND: [6 STATUS INBOX.Sent (UNSEEN UIDNEXT)] Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[0]: 'INBOX.Sent' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[1]: '(' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[2]: 'UNSEEN' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[3]: 'UIDNEXT' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[4]: ')' Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command status... Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_findmailbox: looking for mailbox with FQN [INBOX.Sent]. Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX.Sent' AND owner_idnr='4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [140] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '140' AND owner_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = '140'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='140' AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='140' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='140' AND (status='0' OR status='1') AND recent_flag=1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* STATUS "INBOX.Sent" (UNSEEN 0 UIDNEXT 625883) ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [6 OK STATUS completed ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command status [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: COMMAND: [7 STATUS INBOX.Trash (UNSEEN UIDNEXT)] Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[0]: 'INBOX.Trash' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[1]: '(' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[2]: 'UNSEEN' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[3]: 'UIDNEXT' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[4]: ')' Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command status... Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_findmailbox: looking for mailbox with FQN [INBOX.Trash]. Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX.Trash' AND owner_idnr='4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [141] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '141' AND owner_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = '141'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='141' AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='141' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='141' AND (status='0' OR status='1') AND recent_flag=1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* STATUS "INBOX.Trash" (UNSEEN 0 UIDNEXT 625883) ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [7 OK STATUS completed ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command status [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: COMMAND: [8 STATUS INBOX/cron (UNSEEN UIDNEXT)] Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[0]: 'INBOX/cron' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[1]: '(' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[2]: 'UNSEEN' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[3]: 'UIDNEXT' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[4]: ')' Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command status... Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_findmailbox: looking for mailbox with FQN [INBOX/cron]. Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX/cron' AND owner_idnr='4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [7] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '7' AND owner_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = '7'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='7' AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='7' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='7' AND (status='0' OR status='1') AND recent_flag=1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* STATUS "INBOX/cron" (UNSEEN 0 UIDNEXT 625883) ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [8 OK STATUS completed ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command status [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: COMMAND: [9 STATUS INBOX/Drafts (UNSEEN UIDNEXT)] Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[0]: 'INBOX/Drafts' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[1]: '(' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[2]: 'UNSEEN' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[3]: 'UIDNEXT' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[4]: ')' Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command status... Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_findmailbox: looking for mailbox with FQN [INBOX/Drafts]. Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX/Drafts' AND owner_idnr='4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [4] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '4' AND owner_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='4' AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='4' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='4' AND (status='0' OR status='1') AND recent_flag=1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '4' AND status < '2' ORDER BY message_idnr ASC] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_getmailbox: exists [1] num_rows [1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* STATUS "INBOX/Drafts" (UNSEEN 1 UIDNEXT 625883) ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [9 OK STATUS completed ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command status [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: COMMAND: [10 STATUS INBOX/Sent (UNSEEN UIDNEXT)] Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[0]: 'INBOX/Sent' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[1]: '(' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[2]: 'UNSEEN' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[3]: 'UIDNEXT' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[4]: ')' Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command status... Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_findmailbox: looking for mailbox with FQN [INBOX/Sent]. Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX/Sent' AND owner_idnr='4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [9] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '9' AND owner_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = '9'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='9' AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='9' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='9' AND (status='0' OR status='1') AND recent_flag=1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '9' AND status < '2' ORDER BY message_idnr ASC] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_getmailbox: exists [9] num_rows [9] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* STATUS "INBOX/Sent" (UNSEEN 0 UIDNEXT 625883) ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [10 OK STATUS completed ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command status [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: COMMAND: [11 STATUS INBOX/spam (UNSEEN UIDNEXT)] Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[0]: 'INBOX/spam' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[1]: '(' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[2]: 'UNSEEN' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[3]: 'UIDNEXT' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[4]: ')' Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command status... Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_findmailbox: looking for mailbox with FQN [INBOX/spam]. Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX/spam' AND owner_idnr='4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [6] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '6' AND owner_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = '6'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='6' AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='6' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='6' AND (status='0' OR status='1') AND recent_flag=1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '6' AND status < '2' ORDER BY message_idnr ASC] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_getmailbox: exists [58] num_rows [58] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* STATUS "INBOX/spam" (UNSEEN 58 UIDNEXT 625883) ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [11 OK STATUS completed ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command status [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: COMMAND: [12 STATUS INBOX/Test (UNSEEN UIDNEXT)] Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[0]: 'INBOX/Test' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[1]: '(' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[2]: 'UNSEEN' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[3]: 'UIDNEXT' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[4]: ')' Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command status... Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_findmailbox: looking for mailbox with FQN [INBOX/Test]. Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX/Test' AND owner_idnr='4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [8] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '8' AND owner_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = '8'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='8' AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='8' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='8' AND (status='0' OR status='1') AND recent_flag=1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '8' AND status < '2' ORDER BY message_idnr ASC] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_getmailbox: exists [21] num_rows [21] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* STATUS "INBOX/Test" (UNSEEN 19 UIDNEXT 625883) ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [12 OK STATUS completed ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command status [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: COMMAND: [13 STATUS INBOX/Trash (UNSEEN UIDNEXT)] Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[0]: 'INBOX/Trash' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[1]: '(' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[2]: 'UNSEEN' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[3]: 'UIDNEXT' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[4]: ')' Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command status... Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_findmailbox: looking for mailbox with FQN [INBOX/Trash]. Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX/Trash' AND owner_idnr='4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [5] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '5' AND owner_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = '5'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='5' AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='5' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='5' AND (status='0' OR status='1') AND recent_flag=1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* STATUS "INBOX/Trash" (UNSEEN 0 UIDNEXT 625883) ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [13 OK STATUS completed ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command status [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: COMMAND: [14 LIST "" "*"] Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[0]: '' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[1]: '*' Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command list... Mar 9 16:59:26 octo dbmail/imap4d[14495]: imapcommands.c,_ic_list: search with pattern: [*] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mbx.name, mbx.mailbox_idnr, mbx.owner_idnr FROM dbmail_mailboxes mbx LEFT JOIN dbmail_acl acl ON mbx.mailbox_idnr = acl.mailbox_id LEFT JOIN dbmail_users usr ON acl.user_id = usr.user_idnr WHERE ((mbx.owner_idnr = '4') OR (acl.user_id = '4' AND acl.lookup_flag = '1') OR (usr.userid = 'anyone' AND acl.lookup_flag = '1'))] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_findmailbox_by_regex: found [11] mailboxes Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '136'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '4' AND name LIKE 'Drafts/%' ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* LIST (\hasnochildren) "/" "Drafts" ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '3'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '4' AND name LIKE 'INBOX/%' ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* LIST (\haschildren) "/" "INBOX" ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '142'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '4' AND name LIKE 'INBOX.Drafts/%' ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* LIST (\hasnochildren) "/" "INBOX.Drafts" ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '140'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '4' AND name LIKE 'INBOX.Sent/%' ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* LIST (\hasnochildren) "/" "INBOX.Sent" ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '141'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '4' AND name LIKE 'INBOX.Trash/%' ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* LIST (\hasnochildren) "/" "INBOX.Trash" ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '4' AND name LIKE 'INBOX/Drafts/%' ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* LIST (\hasnochildren) "/" "INBOX/Drafts" ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '9'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '4' AND name LIKE 'INBOX/Sent/%' ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* LIST (\hasnochildren) "/" "INBOX/Sent" ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '8'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '4' AND name LIKE 'INBOX/Test/%' ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* LIST (\hasnochildren) "/" "INBOX/Test" ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '5'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '4' AND name LIKE 'INBOX/Trash/%' ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* LIST (\hasnochildren) "/" "INBOX/Trash" ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '7'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '4' AND name LIKE 'INBOX/cron/%' ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* LIST (\hasnochildren) "/" "INBOX/cron" ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '6'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '4' AND name LIKE 'INBOX/spam/%' ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* LIST (\hasnochildren) "/" "INBOX/spam" ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [14 OK LIST completed ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command list [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: COMMAND: [15 SELECT INBOX/Drafts] Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[0]: 'INBOX/Drafts' Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command select... Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_findmailbox: looking for mailbox with FQN [INBOX/Drafts]. Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX/Drafts' AND owner_idnr='4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [4] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '4' AND owner_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='4' AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='4' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='4' AND (status='0' OR status='1') AND recent_flag=1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '4' AND status < '2' ORDER BY message_idnr ASC] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_getmailbox: exists [1] num_rows [1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='4' AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='4' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='4' AND (status='0' OR status='1') AND recent_flag=1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '4' AND status < '2' ORDER BY message_idnr ASC] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_getmailbox: exists [1] num_rows [1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* 1 EXISTS ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* 0 RECENT ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* FLAGS (\Seen \Answered \Deleted \Flagged \Draft \Recent) ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* OK [PERMANENTFLAGS (\Seen \Answered \Deleted \Flagged \Draft \Recent)] ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* OK [UIDNEXT 625883] Predicted next UID ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* OK [UIDVALIDITY 4] UID value ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT MIN(message_idnr) FROM dbmail_messages WHERE mailbox_idnr = '4' AND status < '2' AND seen_flag = '0'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* OK [UNSEEN 1] first unseen message ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr FROM dbmail_messages WHERE recent_flag = 1 AND mailbox_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_mailbox_select_recent: recent [0] in mailbox [4] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [15 OK [READ-WRITE] SELECT completed ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command select [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='4' AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='4' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='4' AND (status='0' OR status='1') AND recent_flag=1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '4' AND status < '2' ORDER BY message_idnr ASC] Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_getmailbox: exists [1] num_rows [1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] Mar 9 16:59:26 octo dbmail/imap4d[14495]: COMMAND: [16 FETCH 1 (UID FLAGS)] Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[0]: '1' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[1]: '(' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[2]: 'UID' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[3]: 'FLAGS' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[4]: ')' Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command fetch... Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [4] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '4' AND owner_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] = [UID] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] = UID (returning 3) Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] = [FLAGS] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 3] = FLAGS (returning 4) Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[4] = [)] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imapcommands.c,_ic_fetch: hdrparse_needed [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imapcommands.c,_ic_fetch: msgparse_needed [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imapcommands.c,_ic_fetch: fetch_start [0] fetch_end [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing 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 '16251' AND '16251' AND mailbox_idnr = '4' AND status < '2' ORDER BY message_idnr ASC] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* 1 FETCH (] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [FLAGS ()] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [ ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [UID 16251] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [) ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [16 OK FETCH completed ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command fetch [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: COMMAND: [17 FETCH 1 (UID FLAGS)] Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[0]: '1' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[1]: '(' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[2]: 'UID' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[3]: 'FLAGS' Mar 9 16:59:26 octo dbmail/imap4d[14495]: arg[4]: ')' Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command fetch... Mar 9 16:59:26 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [4] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '4' AND owner_idnr = '4'] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] = [UID] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] = UID (returning 3) Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] = [FLAGS] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 3] = FLAGS (returning 4) Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[4] = [)] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imapcommands.c,_ic_fetch: hdrparse_needed [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imapcommands.c,_ic_fetch: msgparse_needed [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imapcommands.c,_ic_fetch: fetch_start [0] fetch_end [0] Mar 9 16:59:26 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing 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 '16251' AND '16251' AND mailbox_idnr = '4' AND status < '2' ORDER BY message_idnr ASC] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [* 1 FETCH (] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [FLAGS ()] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [ ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [UID 16251] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [) ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: RESPONSE: [17 OK FETCH completed ] Mar 9 16:59:26 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command fetch [0] Mar 9 16:59:27 octo dbmail/imap4d[14495]: COMMAND: [18 FETCH 1 (UID FLAGS)] Mar 9 16:59:27 octo dbmail/imap4d[14495]: arg[0]: '1' Mar 9 16:59:27 octo dbmail/imap4d[14495]: arg[1]: '(' Mar 9 16:59:27 octo dbmail/imap4d[14495]: arg[2]: 'UID' Mar 9 16:59:27 octo dbmail/imap4d[14495]: arg[3]: 'FLAGS' Mar 9 16:59:27 octo dbmail/imap4d[14495]: arg[4]: ')' Mar 9 16:59:27 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command fetch... Mar 9 16:59:27 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [4] Mar 9 16:59:27 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '4' AND owner_idnr = '4'] Mar 9 16:59:27 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] = [UID] Mar 9 16:59:27 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] = UID (returning 3) Mar 9 16:59:27 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] = [FLAGS] Mar 9 16:59:27 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 3] = FLAGS (returning 4) Mar 9 16:59:27 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[4] = [)] Mar 9 16:59:27 octo dbmail/imap4d[14495]: imapcommands.c,_ic_fetch: hdrparse_needed [0] Mar 9 16:59:27 octo dbmail/imap4d[14495]: imapcommands.c,_ic_fetch: msgparse_needed [0] Mar 9 16:59:27 octo dbmail/imap4d[14495]: imapcommands.c,_ic_fetch: fetch_start [0] fetch_end [0] Mar 9 16:59:27 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing 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 '16251' AND '16251' AND mailbox_idnr = '4' AND status < '2' ORDER BY message_idnr ASC] Mar 9 16:59:27 octo dbmail/imap4d[14495]: RESPONSE: [* 1 FETCH (] Mar 9 16:59:27 octo dbmail/imap4d[14495]: RESPONSE: [FLAGS ()] Mar 9 16:59:27 octo dbmail/imap4d[14495]: RESPONSE: [ ] Mar 9 16:59:27 octo dbmail/imap4d[14495]: RESPONSE: [UID 16251] Mar 9 16:59:27 octo dbmail/imap4d[14495]: RESPONSE: [) ] Mar 9 16:59:27 octo dbmail/imap4d[14495]: RESPONSE: [18 OK FETCH completed ] Mar 9 16:59:27 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command fetch [0] Mar 9 16:59:27 octo dbmail/imap4d[14495]: COMMAND: [19 FETCH 1 (UID FLAGS)] Mar 9 16:59:27 octo dbmail/imap4d[14495]: arg[0]: '1' Mar 9 16:59:27 octo dbmail/imap4d[14495]: arg[1]: '(' Mar 9 16:59:27 octo dbmail/imap4d[14495]: arg[2]: 'UID' Mar 9 16:59:27 octo dbmail/imap4d[14495]: arg[3]: 'FLAGS' Mar 9 16:59:27 octo dbmail/imap4d[14495]: arg[4]: ')' Mar 9 16:59:27 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Executing command fetch... Mar 9 16:59:27 octo dbmail/imap4d[14495]: db.c,db_acl_has_right: checking ACL for user [4] on mailbox [4] Mar 9 16:59:27 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '4' AND owner_idnr = '4'] Mar 9 16:59:27 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] = [UID] Mar 9 16:59:27 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] = UID (returning 3) Mar 9 16:59:27 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] = [FLAGS] Mar 9 16:59:27 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 3] = FLAGS (returning 4) Mar 9 16:59:27 octo dbmail/imap4d[14495]: dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[4] = [)] Mar 9 16:59:27 octo dbmail/imap4d[14495]: imapcommands.c,_ic_fetch: hdrparse_needed [0] Mar 9 16:59:27 octo dbmail/imap4d[14495]: imapcommands.c,_ic_fetch: msgparse_needed [0] Mar 9 16:59:27 octo dbmail/imap4d[14495]: imapcommands.c,_ic_fetch: fetch_start [0] fetch_end [0] Mar 9 16:59:27 octo dbmail/imap4d[14495]: dbmysql.c,db_query: executing 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 '16251' AND '16251' AND mailbox_idnr = '4' AND status < '2' ORDER BY message_idnr ASC] Mar 9 16:59:27 octo dbmail/imap4d[14495]: RESPONSE: [* 1 FETCH (] Mar 9 16:59:27 octo dbmail/imap4d[14495]: RESPONSE: [FLAGS ()] Mar 9 16:59:27 octo dbmail/imap4d[14495]: RESPONSE: [ ] Mar 9 16:59:27 octo dbmail/imap4d[14495]: RESPONSE: [UID 16251] Mar 9 16:59:27 octo dbmail/imap4d[14495]: RESPONSE: [) ] Mar 9 16:59:27 octo dbmail/imap4d[14495]: RESPONSE: [19 OK FETCH completed ] Mar 9 16:59:27 octo dbmail/imap4d[14495]: imap4.c,IMAPClientHandler: Finished command fetch [0]
mysql> select * from dbmail_messages where dbmail_messages.message_idnr = 16251; +--------------+--------------+----------------+-----------+---------------+--------------+--------------+-------------+------------+----------------------------------+--------+ | message_idnr | mailbox_idnr | physmessage_id | seen_flag | answered_flag | deleted_flag | flagged_flag | recent_flag | draft_flag | unique_id | status | +--------------+--------------+----------------+-----------+---------------+--------------+--------------+-------------+------------+----------------------------------+--------+ | 16251 | 4 | 16188 | 0 | 0 | 0 | 0 | 0 | 0 | a1049ac69b941d361630c74ed4255515 | 0 | +--------------+--------------+----------------+-----------+---------------+--------------+--------------+-------------+------------+----------------------------------+--------+ 1 row in set (0.01 sec) mysql> select * from dbmail_physmessage where dbmail_physmessage.id = 16188; +-------+-------------+---------+---------------------+ | id | messagesize | rfcsize | internal_date | +-------+-------------+---------+---------------------+ | 16188 | 1822 | 1905 | 2003-11-19 18:10:25 | +-------+-------------+---------+---------------------+ 1 row in set (0.00 sec) mysql> select * from dbmail_messageblks where dbmail_messageblks.physmessage_id = 16188 -> ; +-----------------+----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+-----------+ | messageblk_idnr | physmessage_id | messageblk | blocksize | is_header | +-----------------+----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+-----------+ | 32440 | 16188 |Return-Path: <[EMAIL PROTECTED]> Delivered-To: [EMAIL PROTECTED] Received: (qmail 12679 invoked by uid 1005); 19 Nov 2003 18:10:25 -0000 Delivered-To: [EMAIL PROTECTED] Received: (qmail 12652 invoked by alias); 19 Nov 2003 18:10:24 -0000 Delivered-To: [EMAIL PROTECTED] Received: (qmail 12611 invoked by alias); 19 Nov 2003 18:10:22 -0000 Delivered-To: [EMAIL PROTECTED] Received: (qmail 12570 invoked from network); 19 Nov 2003 18:10:21 -0000 Received: from leto.speedsite.com (206.126.224.10) by ghanima.speedsite.com with SMTP; 19 Nov 2003 18:10:21 -0000 Received: from pcp153982pcs.hamntn01.nj.comcast.net ([68.44.244.150]) by leto.speedsite.com with smtp (Exim 3.36 #1 (Debian)) id 1AMWla-0004K1-00 for <[EMAIL PROTECTED]>; Wed, 19 Nov 2003 12:09:28 -0600 Received: from [89.192.241.202] by pcp153982pcs.hamntn01.nj.comcast.net with SMTP; Thu, 20 Nov 2003 06:05:13 -0200 Message-ID: <[EMAIL PROTECTED]> From: "Meredith Bernard" <[EMAIL PROTECTED]> Reply-To: "Meredith Bernard" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: lose 25 lbs guaranteed bestial hdoe epcyekftbq jl Date: Thu, 20 Nov 2003 06:05:13 GMT X-Mailer: Microsoft Outlook Express 5.50.4133.2400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="C._7__3E6C4D36_E" X-Priority: 3 X-MSMail-Priority: Normal | 1365 | 1 | | 32441 | 16188 | --C._7__3E6C4D36_E Content-Type: text/plain; Content-Transfer-Encoding: quoted-printable Hello, ~Lose 20 lbs or more FAST! Safe and Simple! Wear our d-i-e-t patch & watch the pounds drops http://www.vigetxole.com/m/index.php?AFF_ID=3Dgaj1013 ******************************************* please re-move-me http://www.vigetxole.com/homepage/ vgojlxvpwzvirxs lbxzcwzj cvkwwboxphdyy fpij sox ktlex h --C._7__3E6C4D36_E-- | 457 | 0 | +-----------------+----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+-----------+ 2 rows in set (0.14 sec)