Hey All;
Well, I hadn't noticed this brought up, so figured I'd give it a shot.
I upgraded from 2.0.6 to the current svn trunk and no longer am able to
view messages in squirrelmail (as far as I can tell, Thunderbird still
works fine). In the inbox, all I see is an empty 'From', 'Unknown date'
and the Subject as (no subject), for all messages in the folder. When I
click on the (no subject) it comes up saying it can't find the message.
I am assuming this has to do with the DB layout changes from 2.0 ->
current, but wanted to check here first. If so, any reasonable way to
get the database in the right state for the messages?
OS: FC4
MySQL: Ver 12.22 Distrib 4.0.20
Thanks,
Dan
BTW: Attached is some logging at TRACE 5 in case it's of any use.
Jan 31 02:40:28 mail dbmail/imap4d[28350]: server.c,dm_socket: done
Jan 31 02:40:28 mail dbmail/imap4d[28350]: server.c,dm_bind_and_listen: done
Jan 31 02:40:28 mail dbmail/imap4d[28351]: dbmysql.c,db_query: executing query
[SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0]
Jan 31 02:40:28 mail dbmail/imap4d[28351]: dbmysql.c,db_query: executing query
[SELECT 1=1 FROM dbmail_headervalue LIMIT 1 OFFSET 0]
Jan 31 02:40:28 mail dbmail/imap4d[28353]: pool.c,child_register: register
child [28353]
Jan 31 02:40:28 mail dbmail/imap4d[28353]: pool.c,child_register: initializing
child_state [28353] using slot [0]
Jan 31 02:40:28 mail dbmail/imap4d[28353]: serverchild.c,CreateChild: signal
handler placed, going to perform task now
Jan 31 02:40:28 mail dbmail/imap4d[28353]: serverchild.c,PerformChildTask:
waiting for connection
Jan 31 02:40:28 mail dbmail/imap4d[28353]: pool.c,child_reg_disconnected:
[28353]
Jan 31 02:40:28 mail dbmail/imap4d[28355]: pool.c,child_register: register
child [28355]
Jan 31 02:40:28 mail dbmail/imap4d[28355]: pool.c,child_register: initializing
child_state [28355] using slot [1]
Jan 31 02:40:28 mail dbmail/imap4d[28355]: serverchild.c,CreateChild: signal
handler placed, going to perform task now
Jan 31 02:40:28 mail dbmail/imap4d[28355]: serverchild.c,PerformChildTask:
waiting for connection
Jan 31 02:40:28 mail dbmail/imap4d[28355]: pool.c,child_reg_disconnected:
[28355]
Jan 31 02:40:28 mail dbmail/imap4d[28351]: server.c,StartServer: starting main
service loop
---------------
Jan 31 02:41:43 mail dbmail/imap4d[28376]: pool.c,child_reg_connected: [28376]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: serverchild.c,PerformChildTask:
incoming connection from [127.0.0.1 (localhost)]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* OK dbmail imap
(protocol version 4r1) server 2.1 ready to run
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A001 LOGIN "dstilts"
"******"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: 'dstilts'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[1]: '******'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command login...
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_handle_auth: trying to validate user
[dstilts], pass [XXXX]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT userid FROM dbmail_usermap WHERE 1 = 2]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_use_usermap: enabling
usermap lookups
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_usermap_resolve: checking
userid 'dstilts' in usermap
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_usermap_resolve: client on
inet socket [inet:127.0.0.1:143]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT login, sock_allow, sock_deny, userid FROM dbmail_usermap WHERE login in
('dstilts','ANY') ORDER BY sock_allow, sock_deny]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_usermap_resolve: login
'dstilts' not found in usermap
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='dstilts']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE user_idnr =
'3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: authsql.c,auth_validate: validating
using MD5 digest comparison
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET last_login = '2006-01-31 02:41:43' WHERE user_idnr =
'3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_handle_auth: user (id:3, name dstilts)
tries login
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_handle_auth: user (id 3, name dstilts)
login accepted @ 2006-01-31 02:41:43
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A001 OK LOGIN completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command login [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A002 SELECT "Junk E-mail"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: 'Junk E-mail'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command select...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_findmailbox: looking for
mailbox with FQN [Junk E-mail].
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Junk E-mail' AND
owner_idnr='3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_acl_has_right: checking ACL
for user [3] on mailbox [13]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '13' AND
owner_idnr = '3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='13' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND (status='0' OR
status='1') AND recent_flag=1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
< '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_getmailbox: exists [1]
num_rows [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='13' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND (status='0' OR
status='1') AND recent_flag=1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
< '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_getmailbox: exists [1]
num_rows [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* 1 EXISTS
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* 1 RECENT
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* FLAGS (\Seen \Answered
\Deleted \Flagged \Draft \Recent)
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* OK [PERMANENTFLAGS
(\Seen \Answered \Deleted \Flagged \Draft \Recent)]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* OK [UIDNEXT 359482]
Predicted next UID
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* OK [UIDVALIDITY 13] UID
value
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT MIN(message_idnr) FROM dbmail_messages WHERE mailbox_idnr = '13' AND
status < '2' AND seen_flag = '0']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_get_result: result is
null
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE recent_flag = 1 AND
mailbox_idnr = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_mailbox_select_recent: recent [129] in
mailbox [13]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A002 OK [READ-WRITE]
SELECT completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command select [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='13' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND (status='0' OR
status='1') AND recent_flag=1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
< '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_getmailbox: exists [1]
num_rows [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A003 EXPUNGE]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command expunge...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_acl_has_right: checking ACL
for user [3] on mailbox [13]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '13' AND
owner_idnr = '3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT sum(pm.messagesize) FROM dbmail_messages msg, dbmail_physmessage pm
WHERE msg.physmessage_id = pm.id AND msg.mailbox_idnr = '13' AND msg.status <
'2' AND msg.deleted_flag = '1']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_get_result: result is
null
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND
deleted_flag='1' AND status < '2' ORDER BY message_idnr DESC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[UPDATE dbmail_messages SET status='2' WHERE mailbox_idnr = '13' AND
deleted_flag='1' AND status < '2']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_subtract_quotum_used:
subtracting 0 from mailsize
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
db.c.user_idnr_is_delivery_user_idnr: looking up user_idnr for [EMAIL
PROTECTED]@__
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='[EMAIL PROTECTED]@__']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET curmail_size = curmail_size - '0' WHERE user_idnr =
'3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='13' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND (status='0' OR
status='1') AND recent_flag=1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
< '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_getmailbox: exists [1]
num_rows [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A003 OK EXPUNGE completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command expunge [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='13' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND (status='0' OR
status='1') AND recent_flag=1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
< '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_getmailbox: exists [1]
num_rows [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A004 EXAMINE "Junk E-mail"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: 'Junk E-mail'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command examine...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_findmailbox: looking for
mailbox with FQN [Junk E-mail].
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Junk E-mail' AND
owner_idnr='3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_acl_has_right: checking ACL
for user [3] on mailbox [13]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '13' AND
owner_idnr = '3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='13' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND (status='0' OR
status='1') AND recent_flag=1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
< '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_getmailbox: exists [1]
num_rows [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='13' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND (status='0' OR
status='1') AND recent_flag=1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
< '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_getmailbox: exists [1]
num_rows [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* 1 EXISTS
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* 1 RECENT
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* FLAGS (\Seen \Answered
\Deleted \Flagged \Draft \Recent)
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* OK [PERMANENTFLAGS
(\Seen \Answered \Deleted \Flagged \Draft \Recent)]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* OK [UIDNEXT 359482]
Predicted next UID
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* OK [UIDVALIDITY 13] UID
value
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A004 OK [READ-ONLY]
EXAMINE completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command examine [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A005 SELECT "Junk E-mail"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: 'Junk E-mail'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command select...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[update dbmail_messages set recent_flag = 0 where message_idnr in
(358349,358361,358366,358372,358381,358398,358403,358406,358410,358427,358431,358434,358437,358440,358443,358448,358458,358464,358467,358470,358476,358496,358509,358517,358520,358526,358541,358544,358548,358554,358557,358566,358569,358572,358575,358581,358584,358587,358590,358600,358603,358606,358609,358629,358635,358641,358647,358653,358658,358678,358688,358708,358713,358718,358723,358726,358729,358758,358768,358780,358789,358792,358797,358800,358803,358806,358814,358817,358820,358842,358845,358856,358859,358865,358868,358871,358878,358887,358890,358893,358896,358914,358917,358920,358932,358938,358943,358949,358972,358975,358978,358981,358984,358999,359002,359010,359016,359019,359022,359025)]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[update dbmail_messages set recent_flag = 0 where message_idnr in
(359039,359042,359050,359078,359094,359103,359157,359199,359207,359216,359232,359266,359273,359277,359297,359317,359325,359330,359342,359347,359352,359368,359373,359380,359395,359406,359447,359453,359481)]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_findmailbox: looking for
mailbox with FQN [Junk E-mail].
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Junk E-mail' AND
owner_idnr='3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_acl_has_right: checking ACL
for user [3] on mailbox [13]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '13' AND
owner_idnr = '3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='13' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND (status='0' OR
status='1') AND recent_flag=1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
< '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_getmailbox: exists [1]
num_rows [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='13' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND (status='0' OR
status='1') AND recent_flag=1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
< '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_getmailbox: exists [1]
num_rows [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* 1 EXISTS
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* 0 RECENT
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* FLAGS (\Seen \Answered
\Deleted \Flagged \Draft \Recent)
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* OK [PERMANENTFLAGS
(\Seen \Answered \Deleted \Flagged \Draft \Recent)]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* OK [UIDNEXT 359482]
Predicted next UID
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* OK [UIDVALIDITY 13] UID
value
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT MIN(message_idnr) FROM dbmail_messages WHERE mailbox_idnr = '13' AND
status < '2' AND seen_flag = '0']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_get_result: result is
null
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE recent_flag = 1 AND
mailbox_idnr = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_mailbox_select_recent: recent [0] in
mailbox [13]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A005 OK [READ-WRITE]
SELECT completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command select [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='13' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND (status='0' OR
status='1') AND recent_flag=1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
< '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_getmailbox: exists [1]
num_rows [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A006 EXPUNGE]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command expunge...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_acl_has_right: checking ACL
for user [3] on mailbox [13]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '13' AND
owner_idnr = '3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT sum(pm.messagesize) FROM dbmail_messages msg, dbmail_physmessage pm
WHERE msg.physmessage_id = pm.id AND msg.mailbox_idnr = '13' AND msg.status <
'2' AND msg.deleted_flag = '1']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_get_result: result is
null
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND
deleted_flag='1' AND status < '2' ORDER BY message_idnr DESC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[UPDATE dbmail_messages SET status='2' WHERE mailbox_idnr = '13' AND
deleted_flag='1' AND status < '2']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_subtract_quotum_used:
subtracting 0 from mailsize
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
db.c.user_idnr_is_delivery_user_idnr: no need to look up user_idnr for [EMAIL
PROTECTED]@__
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET curmail_size = curmail_size - '0' WHERE user_idnr =
'3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='13' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND (status='0' OR
status='1') AND recent_flag=1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
< '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_getmailbox: exists [1]
num_rows [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A006 OK EXPUNGE completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command expunge [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='13' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND (status='0' OR
status='1') AND recent_flag=1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
< '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_getmailbox: exists [1]
num_rows [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A007 EXPUNGE]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command expunge...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_acl_has_right: checking ACL
for user [3] on mailbox [13]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '13' AND
owner_idnr = '3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT sum(pm.messagesize) FROM dbmail_messages msg, dbmail_physmessage pm
WHERE msg.physmessage_id = pm.id AND msg.mailbox_idnr = '13' AND msg.status <
'2' AND msg.deleted_flag = '1']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_get_result: result is
null
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND
deleted_flag='1' AND status < '2' ORDER BY message_idnr DESC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[UPDATE dbmail_messages SET status='2' WHERE mailbox_idnr = '13' AND
deleted_flag='1' AND status < '2']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_subtract_quotum_used:
subtracting 0 from mailsize
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
db.c.user_idnr_is_delivery_user_idnr: no need to look up user_idnr for [EMAIL
PROTECTED]@__
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET curmail_size = curmail_size - '0' WHERE user_idnr =
'3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='13' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND (status='0' OR
status='1') AND recent_flag=1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
< '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_getmailbox: exists [1]
num_rows [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A007 OK EXPUNGE completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command expunge [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='13' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='13' AND (status='0' OR
status='1') AND recent_flag=1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
< '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_getmailbox: exists [1]
num_rows [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A008 UID SEARCH UID
1:359481]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: 'SEARCH'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[1]: 'UID'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[2]: '1:359481'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command uid...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_acl_has_right: checking ACL
for user [3] on mailbox [13]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '13' AND
owner_idnr = '3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '13' AND status
IN ('0','1') ORDER BY message_idnr]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: misc.c,check_msg_set: [1:359481] [ok]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmail-mailbox.c,append_search:
[167868680] [1] type [0] field [] search [1:359481] at depth [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmail-mailbox.c,_do_search: type [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-mailbox.c,dbmail_mailbox_get_set: [0] [1:359481]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: misc.c,g_tree_merge: a[0] [OR] b[1]
-> a[1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-mailbox.c,dbmail_mailbox_get_set: self->set contains [1] ids between
[359481] and [359481]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmail-mailbox.c,_do_search: type
[0] rows [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmail-mailbox.c,_merge_search: node
depth [1]
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-mailbox.c,dbmail_mailbox_search: found [1] ids
Jan 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* SEARCH 359481]
]008 OK SEARCH completedil/imap4d[28376]: RESPONSE: [
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command uid [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A009 UID FETCH 1:* (FLAGS
UID RFC822.SIZE INTERNALDATE BODY.PEEK[HEADER.FIELDS (Date To Cc From Subject
X-Priority Content-Type)])]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: 'FETCH'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[1]: '1:*'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[2]: '('
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[3]: 'FLAGS'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[4]: 'UID'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[5]: 'RFC822.SIZE'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[6]: 'INTERNALDATE'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[7]: 'BODY.PEEK'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[8]: '['
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[9]: 'HEADER.FIELDS'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[10]: '('
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[11]: 'Date'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[12]: 'To'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[13]: 'Cc'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[14]: 'From'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[15]: 'Subject'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[16]: 'X-Priority'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[17]: 'Content-Type'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[18]: ')'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[19]: ']'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[20]: ')'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command uid...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_acl_has_right: checking ACL
for user [3] on mailbox [13]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '13' AND
owner_idnr = '3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] =
[FLAGS]
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] =
FLAGS (returning 3)
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] = [UID]
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 3] = UID
(returning 4)
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[4] =
[RFC822.SIZE]
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 4] =
RFC822.SIZE (returning 5)
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[5] =
[INTERNALDATE]
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 5] =
INTERNALDATE (returning 6)
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[6] =
[BODY.PEEK]
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,_imap_session_fetch_parse_partspec: token [HEADER.FIELDS],
nexttoken [(]
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,_imap_session_fetch_parse_octet_range: parse token [)]
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[19] = [)]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imapcommands.c,_ic_fetch:
hdrparse_needed [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imapcommands.c,_ic_fetch:
msgparse_needed [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imapcommands.c,_ic_fetch:
fetch_start [1] fetch_end [359481]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 '1' AND '359481' AND mailbox_idnr =
'13' AND status < '2' ORDER BY message_idnr ASC]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* 1 FETCH (]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [INTERNALDATE "Mon, 30 Jan
2006 23:59:34 -0800"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [ ]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [RFC822.SIZE 16291]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [ ]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [FLAGS (\Seen)]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [ ]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [UID 359481]
Jan 31 02:41:43 mail dbmail/imap4d[28376]:
dbmail-imapsession.c,_imap_show_body_section: itemtype [3] partspec []
Jan 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [ ]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [BODY[]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [HEADER.FIELDS (Date To Cc
From Subject X-Priority Content-Type)] ]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '359481']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT physmessage_id,headername,headervalue FROM dbmail_headervalue v JOIN
dbmail_headername n ON v.headername_id=n.id WHERE physmessage_id IN (198560)
AND lower(headername) IN
('date','to','cc','from','subject','x-priority','content-type')]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [NIL]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [)
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A009 OK UID FETCH
completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command uid [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A010 LSUB "" "*"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[1]: '*'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command lsub...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [*]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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 LEFT JOIN dbmail_subscription
sub ON sub.mailbox_id = mbx.mailbox_idnr WHERE (sub.user_id = '3' AND
((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND acl.lookup_flag = '1') OR
(usr.userid = 'anyone' AND acl.lookup_flag = '1')))]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[16] mailboxes
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '2']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\haschildren) "/"
"INBOX"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '3']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'Sent Items/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\hasnochildren)
"/" "Sent Items"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '4']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'Drafts/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\hasnochildren)
"/" "Drafts"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '6']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'Trash/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\hasnochildren)
"/" "Trash"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '8']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/System/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\haschildren) "/"
"INBOX/System"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '13']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'Junk E-mail/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\hasnochildren)
"/" "Junk E-mail"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '18']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/System/Reports/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\hasnochildren)
"/" "INBOX/System/Reports"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '29']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/People/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\haschildren) "/"
"INBOX/People"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '30']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/People/Person/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\hasnochildren)
"/" "INBOX/People/Person"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '52']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/Mailing Lists/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\haschildren) "/"
"INBOX/Mailing Lists"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '53']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/Mailing Lists/Dbmail/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\hasnochildren)
"/" "INBOX/Mailing Lists/Dbmail"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '93']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/System/Hostmaster/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\hasnochildren)
"/" "INBOX/System/Hostmaster"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '95']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/System/Webmaster/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\hasnochildren)
"/" "INBOX/System/Webmaster"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '97']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/Work/Webative/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\hasnochildren)
"/" "INBOX/Work/Webative"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '98']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/Work/RHI/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\hasnochildren)
"/" "INBOX/Work/RHI"
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '303']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'Sent/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LSUB (\hasnochildren)
"/" "Sent"
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A010 OK LSUB completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command lsub [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A011 LIST "" "Drafts"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[1]: 'Drafts'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [Drafts]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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.name = 'Drafts' AND
((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND acl.lookup_flag = '1') OR
(usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '4']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'Drafts/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\hasnochildren)
"/" "Drafts"
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A011 OK LIST completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A012 LIST "" "INBOX"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[1]: 'INBOX'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [INBOX]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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.name = 'INBOX' AND
((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND acl.lookup_flag = '1') OR
(usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '2']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\haschildren) "/"
"INBOX"
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A012 OK LIST completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A013 LIST ""
"INBOX/Mailing Lists"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[1]: 'INBOX/Mailing Lists'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [INBOX/Mailing Lists]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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.name = 'INBOX/Mailing
Lists' AND ((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND acl.lookup_flag
= '1') OR (usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '52']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/Mailing Lists/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\haschildren) "/"
"INBOX/Mailing Lists"
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A013 OK LIST completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A014 LIST ""
"INBOX/Mailing Lists/Dbmail"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[1]: 'INBOX/Mailing Lists/Dbmail'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [INBOX/Mailing Lists/Dbmail]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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.name = 'INBOX/Mailing
Lists/Dbmail' AND ((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND
acl.lookup_flag = '1') OR (usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '53']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/Mailing Lists/Dbmail/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\hasnochildren)
"/" "INBOX/Mailing Lists/Dbmail"
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A014 OK LIST completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A015 LIST ""
"INBOX/People"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[1]: 'INBOX/People'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [INBOX/People]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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.name = 'INBOX/People'
AND ((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND acl.lookup_flag = '1')
OR (usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '29']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/People/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\haschildren) "/"
"INBOX/People"
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A015 OK LIST completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A016 LIST ""
"INBOX/People/Person"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[1]: 'INBOX/People/Person'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [INBOX/People/Person]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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.name =
'INBOX/People/Person' AND ((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND
acl.lookup_flag = '1') OR (usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '30']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/People/Person/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\hasnochildren)
"/" "INBOX/People/Person"
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A016 OK LIST completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A017 LIST ""
"INBOX/System"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[1]: 'INBOX/System'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [INBOX/System]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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.name = 'INBOX/System'
AND ((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND acl.lookup_flag = '1')
OR (usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '8']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/System/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\haschildren) "/"
"INBOX/System"
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A017 OK LIST completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A018 LIST ""
"INBOX/System/Hostmaster"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[1]: 'INBOX/System/Hostmaster'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [INBOX/System/Hostmaster]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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.name =
'INBOX/System/Hostmaster' AND ((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND
acl.lookup_flag = '1') OR (usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '93']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/System/Hostmaster/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\hasnochildren)
"/" "INBOX/System/Hostmaster"
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A018 OK LIST completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A019 LIST ""
"INBOX/System/Reports"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[1]: 'INBOX/System/Reports'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [INBOX/System/Reports]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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.name =
'INBOX/System/Reports' AND ((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND
acl.lookup_flag = '1') OR (usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '18']
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/System/Reports/%' ]
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\hasnochildren)
"/" "INBOX/System/Reports"
]n 31 02:41:43 mail dbmail/imap4d[28376]: RESPONSE: [A019 OK LIST completed
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:43 mail dbmail/imap4d[28376]: COMMAND: [A020 LIST ""
"INBOX/System/Webmaster"]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:43 mail dbmail/imap4d[28376]: arg[1]: 'INBOX/System/Webmaster'
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:43 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [INBOX/System/Webmaster]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: 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.name =
'INBOX/System/Webmaster' AND ((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND
acl.lookup_flag = '1') OR (usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:43 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:43 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '95']
Jan 31 02:41:44 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/System/Webmaster/%' ]
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\hasnochildren)
"/" "INBOX/System/Webmaster"
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [A020 OK LIST completed
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:44 mail dbmail/imap4d[28376]: COMMAND: [A021 LIST ""
"INBOX/Work/RHI"]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:44 mail dbmail/imap4d[28376]: arg[1]: 'INBOX/Work/RHI'
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [INBOX/Work/RHI]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: 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.name =
'INBOX/Work/RHI' AND ((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND
acl.lookup_flag = '1') OR (usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:44 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '98']
Jan 31 02:41:44 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/Work/RHI/%' ]
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\hasnochildren)
"/" "INBOX/Work/RHI"
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [A021 OK LIST completed
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:44 mail dbmail/imap4d[28376]: COMMAND: [A022 LIST ""
"INBOX/Work/Webative"]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:44 mail dbmail/imap4d[28376]: arg[1]: 'INBOX/Work/Webative'
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [INBOX/Work/Webative]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: 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.name =
'INBOX/Work/Webative' AND ((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND
acl.lookup_flag = '1') OR (usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:44 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '97']
Jan 31 02:41:44 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'INBOX/Work/Webative/%' ]
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\hasnochildren)
"/" "INBOX/Work/Webative"
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [A022 OK LIST completed
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:44 mail dbmail/imap4d[28376]: COMMAND: [A023 LIST "" "Junk E-mail"]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:44 mail dbmail/imap4d[28376]: arg[1]: 'Junk E-mail'
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [Junk E-mail]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: 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.name = 'Junk E-mail'
AND ((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND acl.lookup_flag = '1')
OR (usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:44 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '13']
Jan 31 02:41:44 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'Junk E-mail/%' ]
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\hasnochildren)
"/" "Junk E-mail"
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [A023 OK LIST completed
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:44 mail dbmail/imap4d[28376]: COMMAND: [A024 LIST "" "Sent"]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:44 mail dbmail/imap4d[28376]: arg[1]: 'Sent'
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [Sent]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: 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.name = 'Sent' AND
((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND acl.lookup_flag = '1') OR
(usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:44 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '303']
Jan 31 02:41:44 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'Sent/%' ]
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\hasnochildren)
"/" "Sent"
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [A024 OK LIST completed
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:44 mail dbmail/imap4d[28376]: COMMAND: [A025 LIST "" "Sent Items"]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:44 mail dbmail/imap4d[28376]: arg[1]: 'Sent Items'
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [Sent Items]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: 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.name = 'Sent Items'
AND ((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND acl.lookup_flag = '1')
OR (usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:44 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '3']
Jan 31 02:41:44 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'Sent Items/%' ]
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\hasnochildren)
"/" "Sent Items"
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [A025 OK LIST completed
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:44 mail dbmail/imap4d[28376]: COMMAND: [A026 LIST "" "Trash"]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: arg[0]: ''
Jan 31 02:41:44 mail dbmail/imap4d[28376]: arg[1]: 'Trash'
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command list...
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imapcommands.c,_ic_list: search with
pattern: [Trash]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: 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.name = 'Trash' AND
((mbx.owner_idnr = '3') OR (acl.user_id = '3' AND acl.lookup_flag = '1') OR
(usr.userid = 'anyone' AND acl.lookup_flag = '1'))]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: db.c,db_findmailbox_by_regex: found
[1] mailboxes
Jan 31 02:41:44 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE
mailbox_idnr = '6']
Jan 31 02:41:44 mail dbmail/imap4d[28376]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '3'
AND name LIKE 'Trash/%' ]
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [* LIST (\hasnochildren)
"/" "Trash"
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [A026 OK LIST completed
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command list [0]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: line read
for PID 28376
Jan 31 02:41:44 mail dbmail/imap4d[28376]: COMMAND: [A027 LOGOUT]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Executing
command logout...
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imapcommands.c,_ic_logout: user
(id:3) logging out @ [2006-01-31 02:41:44]
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [* BYE dbmail imap server
kisses you goodbye
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Finished
command logout [0]
]n 31 02:41:44 mail dbmail/imap4d[28376]: RESPONSE: [A027 OK completed
Jan 31 02:41:44 mail dbmail/imap4d[28376]: imap4.c,IMAPClientHandler: Closing
connection for client from IP [127.0.0.1]
Jan 31 02:41:44 mail dbmail/imap4d[28376]: serverchild.c,PerformChildTask:
client handling complete, closing streams
Jan 31 02:41:44 mail dbmail/imap4d[28376]: serverchild.c,client_close: closing
write stream
Jan 31 02:41:44 mail dbmail/imap4d[28376]: serverchild.c,client_close: closing
read stream
Jan 31 02:41:44 mail dbmail/imap4d[28376]: serverchild.c,PerformChildTask:
connection closed
Jan 31 02:41:44 mail dbmail/imap4d[28376]: serverchild.c,PerformChildTask:
waiting for connection
Jan 31 02:41:44 mail dbmail/imap4d[28376]: pool.c,child_reg_disconnected:
[28376]
