A NOTE has been added to this issue.
======================================================================
http://www.dbmail.org/mantis/view.php?id=379
======================================================================
Reported By: dustmite
Assigned To:
======================================================================
Project: DBMail
Issue ID: 379
Category: IMAP daemon
Reproducibility: always
Severity: minor
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 19-Jul-06 09:40 CEST
Last Modified: 19-Jul-06 12:35 CEST
======================================================================
Summary: RoundCube Webmail Client (IMAP) Unable to Retrieve
Message Body
Description:
RoundCube appears to receive incorrect message ids/numbers, it is able
however to receive the mbox listings and can retrieve details relating to
each mbox, including the mail list, however, when it attempts to retrieve
a message body it uses the wrong message number. The result of this is an
error from dbmail-lmapd of "invalid message range specified"
I am unable to work this out, I don't think it's a fault, per se, with
RoundCube since the bug is not apparent under 2.0 branch of Dbmail. I'll
try and post details to the RoundCube bug tracker so that the exact cause
can be identified... hopefully.
Jul 18 12:37:38 localhost dbmail/imap4d[3366]: COMMAND: [ftch FETCH 10
(BODY.PEEK[TEXT])]
Jul 18 12:37:38 localhost dbmail/imap4d[3366]: arg[0]: '10'
Jul 18 12:37:38 localhost dbmail/imap4d[3366]: arg[1]: '('
Jul 18 12:37:38 localhost dbmail/imap4d[3366]: arg[2]: 'BODY.PEEK'
Jul 18 12:37:38 localhost dbmail/imap4d[3366]: arg[3]: '['
Jul 18 12:37:38 localhost dbmail/imap4d[3366]: arg[4]: 'TEXT'
Jul 18 12:37:38 localhost dbmail/imap4d[3366]: arg[5]: ']'
Jul 18 12:37:38 localhost dbmail/imap4d[3366]: arg[6]: ')'
Jul 18 12:37:38 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Executing command fetch...
Jul 18 12:37:38 localhost dbmail/imap4d[3366]: db.c,db_acl_has_right:
checking ACL [read_flag] for user [4] on mailbox [7]
Jul 18 12:37:38 localhost dbmail/imap4d[3366]: db.c, db_acl_has_right:
mailbox [7] is owned by user [4], is that also [4]?
Jul 18 12:37:38 localhost dbmail/imap4d[3366]: db.c, db_acl_has_right:
mailbox [7] is owned by user [4], giving all rights
Jul 18 12:37:38 localhost dbmail/imap4d[3366]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] =
[BODY.PEEK]
Jul 18 12:37:38 localhost dbmail/imap4d[3366]:
dbmail-imapsession.c,_imap_session_fetch_parse_partspec: token [TEXT],
nexttoken []]
Jul 18 12:37:38 localhost dbmail/imap4d[3366]:
dbmail-imapsession.c,_imap_session_fetch_parse_octet_range: parse token
[)]
Jul 18 12:37:38 localhost dbmail/imap4d[3366]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[6] =
[)]
Jul 18 12:37:38 localhost dbmail/imap4d[3366]: RESPONSE: [ftch BAD invalid
message range specified ]
======================================================================
----------------------------------------------------------------------
paul - 19-Jul-06 11:37
----------------------------------------------------------------------
dustmite,
plz include more loglines leading upto the one you're already including.
I'm especially interested in COMMAND and RESPONSE lines.
btw, roundcube looks really nice/spiffy/web2.0
but tags used in the imap commands look *really* suspicious. They break
rfc3501.
from 3501:
...
The client command begins an operation. Each client command is
prefixed with an identifier (typically a short alphanumeric string,
e.g., A0001, A0002, etc.) called a "tag". A different tag is
generated by the client for each command.
...
And this roundcube doesn't do. It will happily use the same tag (sl01) for
subsequent SELECT commands on different mailboxes. That's not good.
I've tested this on roundcube/trunk.
----------------------------------------------------------------------
dustmite - 19-Jul-06 12:35
----------------------------------------------------------------------
I'm including all of the loglines for, what appears to be, a whole session
with roundcube.
I certainly agree regarding the issues that roundcube has, particularly
the tags.
I'm gradually working through it in an attempt to fix a few things. I like
it's look but I'm struggling with the quality of portions of it's backend -
the IMAP lib that's being used was taken from another webmail client and
feels really hideous and bloated.
Anyway, here's some (hah, a lot more like like) more loglines for you.
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: COMMAND: [a001 LOGIN test
"test"]
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: arg[0]: 'test'
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: arg[1]: 'test'
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command login...
Jul 18 12:37:29 localhost dbmail/imap4d[3368]:
dbmail-imapsession.c,dbmail_imap_session_handle_auth: trying to validate
user [test], pass [XXXX]
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: db.c,db_usermap_resolve:
checking userid 'test' in usermap
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: db.c,db_usermap_resolve:
client on inet socket [inet:10.238.160.20:143]
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT login, sock_allow, sock_deny, userid FROM dbmail_usermap WHERE
login in ('test','ANY') ORDER BY sock_allow, sock_deny]
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: db.c,db_usermap_resolve:
login 'test' not found in usermap
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower('test')]
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE
user_idnr = '4']
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: authsql.c,auth_validate:
validating using plaintext passwords
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[UPDATE dbmail_users SET last_login = '2006-07-18 12:37:29' WHERE
user_idnr = '4']
Jul 18 12:37:29 localhost dbmail/imap4d[3368]:
dbmail-imapsession.c,dbmail_imap_session_handle_auth: user (id:4, name
test) tries login
Jul 18 12:37:29 localhost dbmail/imap4d[3368]:
dbmail-imapsession.c,dbmail_imap_session_handle_auth: user (id 4, name
test) login accepted @ 2006-07-18 12:37:29
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: RESPONSE: [a001 OK LOGIN
completed ]
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command login [0]
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: COMMAND: [ns1 NAMESPACE]
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command namespace...
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: RESPONSE: [* NAMESPACE ((""
"/")) (("#Users" "/")) (("#Public" "/")) ]
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: RESPONSE: [ns1 OK NAMESPACE
complete ]
Jul 18 12:37:29 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command namespace [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [ns1 NAMESPACE]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command namespace...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [* NAMESPACE ((""
"/")) (("#Users" "/")) (("#Public" "/")) ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [ns1 OK NAMESPACE
complete ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command namespace [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [lsb LSUB "" "*"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: ''
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[1]: '*'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command lsub...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imapcommands.c,_ic_list:
search with pattern: [*]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: 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 = '4' AND ((mbx.owner_idnr = '4') OR (acl.user_id = '4' AND
acl.lookup_flag = '1') OR (usr.userid = 'anyone' AND acl.lookup_flag =
'1')))]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,
db_findmailbox_by_regex: did not find any mailboxes that match pattern.
returning 0, nchildren = 0
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [lsb OK LSUB
completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command lsub [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [c CREATE
"INBOX"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: 'INBOX'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command create...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [INBOX].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [c NO mailbox
already exists ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command create [1]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [sub1 SUBSCRIBE
"INBOX"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: 'INBOX'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command subscribe...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [INBOX].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_acl_has_right:
checking ACL [lookup_flag] for user [4] on mailbox [7]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '7']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [7] is owned by user [4], is that also [4]?
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [7] is owned by user [4], giving all rights
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT * FROM dbmail_subscription WHERE mailbox_id = '7' AND user_id =
'4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[INSERT INTO dbmail_subscription (user_id, mailbox_id) VALUES ('4', '7')]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [sub1 OK
SUBSCRIBE completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command subscribe [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [c CREATE
"Drafts"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: 'Drafts'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command create...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Drafts].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Drafts' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox_owner:
no mailbox found
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: checking for 'Drafts'...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Drafts].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Drafts' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox_owner:
no mailbox found
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imapcommands.c,_ic_create:
Checking if we have the right to create mailboxes under mailbox [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[INSERT INTO dbmail_mailboxes (name, owner_idnr,seen_flag, answered_flag,
deleted_flag, flagged_flag, recent_flag, draft_flag, permission) VALUES
('Drafts', '4', 1, 1, 1, 1, 1, 1, 2)]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_createmailbox:
created mailbox with idnr [8] for user [4] result [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [c OK CREATE
completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command create [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [sub1 SUBSCRIBE
"Drafts"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: 'Drafts'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command subscribe...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Drafts].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Drafts' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_acl_has_right:
checking ACL [lookup_flag] for user [4] on mailbox [8]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '8']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [8] is owned by user [4], is that also [4]?
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [8] is owned by user [4], giving all rights
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT * FROM dbmail_subscription WHERE mailbox_id = '8' AND user_id =
'4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[INSERT INTO dbmail_subscription (user_id, mailbox_id) VALUES ('4', '8')]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [sub1 OK
SUBSCRIBE completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command subscribe [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [sub1 SUBSCRIBE
"Drafts"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: 'Drafts'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command subscribe...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Drafts].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Drafts' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_acl_has_right:
checking ACL [lookup_flag] for user [4] on mailbox [8]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '8']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [8] is owned by user [4], is that also [4]?
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [8] is owned by user [4], giving all rights
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT * FROM dbmail_subscription WHERE mailbox_id = '8' AND user_id =
'4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_subscribe: already
subscribed to mailbox [8]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [sub1 OK
SUBSCRIBE completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command subscribe [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [c CREATE "Sent
Items"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: 'Sent Items'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command create...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Sent Items].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Sent Items' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox_owner:
no mailbox found
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: checking for 'Sent
Items'...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Sent Items].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Sent Items' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox_owner:
no mailbox found
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imapcommands.c,_ic_create:
Checking if we have the right to create mailboxes under mailbox [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[INSERT INTO dbmail_mailboxes (name, owner_idnr,seen_flag, answered_flag,
deleted_flag, flagged_flag, recent_flag, draft_flag, permission) VALUES
('Sent Items', '4', 1, 1, 1, 1, 1, 1, 2)]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_createmailbox:
created mailbox with idnr [9] for user [4] result [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [c OK CREATE
completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command create [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [sub1 SUBSCRIBE
"Sent Items"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: 'Sent Items'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command subscribe...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Sent Items].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Sent Items' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_acl_has_right:
checking ACL [lookup_flag] for user [4] on mailbox [9]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '9']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [9] is owned by user [4], is that also [4]?
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [9] is owned by user [4], giving all rights
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT * FROM dbmail_subscription WHERE mailbox_id = '9' AND user_id =
'4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[INSERT INTO dbmail_subscription (user_id, mailbox_id) VALUES ('4', '9')]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [sub1 OK
SUBSCRIBE completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command subscribe [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [sub1 SUBSCRIBE
"Sent Items"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: 'Sent Items'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command subscribe...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Sent Items].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Sent Items' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_acl_has_right:
checking ACL [lookup_flag] for user [4] on mailbox [9]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '9']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [9] is owned by user [4], is that also [4]?
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [9] is owned by user [4], giving all rights
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT * FROM dbmail_subscription WHERE mailbox_id = '9' AND user_id =
'4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_subscribe: already
subscribed to mailbox [9]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [sub1 OK
SUBSCRIBE completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command subscribe [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [c CREATE "Junk"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: 'Junk'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command create...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Junk].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Junk' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox_owner:
no mailbox found
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: checking for 'Junk'...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Junk].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Junk' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox_owner:
no mailbox found
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imapcommands.c,_ic_create:
Checking if we have the right to create mailboxes under mailbox [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[INSERT INTO dbmail_mailboxes (name, owner_idnr,seen_flag, answered_flag,
deleted_flag, flagged_flag, recent_flag, draft_flag, permission) VALUES
('Junk', '4', 1, 1, 1, 1, 1, 1, 2)]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_createmailbox:
created mailbox with idnr [10] for user [4] result [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [c OK CREATE
completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command create [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [sub1 SUBSCRIBE
"Junk"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: 'Junk'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command subscribe...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Junk].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Junk' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_acl_has_right:
checking ACL [lookup_flag] for user [4] on mailbox [10]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '10']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [10] is owned by user [4], is that also [4]?
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [10] is owned by user [4], giving all rights
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT * FROM dbmail_subscription WHERE mailbox_id = '10' AND user_id =
'4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[INSERT INTO dbmail_subscription (user_id, mailbox_id) VALUES ('4',
'10')]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [sub1 OK
SUBSCRIBE completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command subscribe [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [sub1 SUBSCRIBE
"Junk"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: 'Junk'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command subscribe...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Junk].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Junk' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_acl_has_right:
checking ACL [lookup_flag] for user [4] on mailbox [10]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '10']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [10] is owned by user [4], is that also [4]?
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [10] is owned by user [4], giving all rights
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT * FROM dbmail_subscription WHERE mailbox_id = '10' AND user_id =
'4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_subscribe: already
subscribed to mailbox [10]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [sub1 OK
SUBSCRIBE completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command subscribe [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [c CREATE "Deleted
Items"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: 'Deleted Items'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command create...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Deleted Items].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Deleted Items' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox_owner:
no mailbox found
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: checking for 'Deleted
Items'...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Deleted Items].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Deleted Items' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox_owner:
no mailbox found
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imapcommands.c,_ic_create:
Checking if we have the right to create mailboxes under mailbox [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[INSERT INTO dbmail_mailboxes (name, owner_idnr,seen_flag, answered_flag,
deleted_flag, flagged_flag, recent_flag, draft_flag, permission) VALUES
('Deleted Items', '4', 1, 1, 1, 1, 1, 1, 2)]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_createmailbox:
created mailbox with idnr [11] for user [4] result [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [c OK CREATE
completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command create [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [sub1 SUBSCRIBE
"Deleted Items"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: 'Deleted Items'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command subscribe...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Deleted Items].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Deleted Items' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_acl_has_right:
checking ACL [lookup_flag] for user [4] on mailbox [11]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '11']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [11] is owned by user [4], is that also [4]?
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [11] is owned by user [4], giving all rights
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT * FROM dbmail_subscription WHERE mailbox_id = '11' AND user_id =
'4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[INSERT INTO dbmail_subscription (user_id, mailbox_id) VALUES ('4',
'11')]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [sub1 OK
SUBSCRIBE completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command subscribe [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [sub1 SUBSCRIBE
"Deleted Items"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: 'Deleted Items'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command subscribe...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_findmailbox:
looking for mailbox with FQN [Deleted Items].
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Deleted Items' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_acl_has_right:
checking ACL [lookup_flag] for user [4] on mailbox [11]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '11']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [11] is owned by user [4], is that also [4]?
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c, db_acl_has_right:
mailbox [11] is owned by user [4], giving all rights
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT * FROM dbmail_subscription WHERE mailbox_id = '11' AND user_id =
'4']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: db.c,db_subscribe: already
subscribed to mailbox [11]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [sub1 OK
SUBSCRIBE completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command subscribe [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [lsb LSUB "" "*"]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[0]: ''
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: arg[1]: '*'
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command lsub...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imapcommands.c,_ic_list:
search with pattern: [*]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: 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 = '4' AND ((mbx.owner_idnr = '4') OR (acl.user_id = '4' AND
acl.lookup_flag = '1') OR (usr.userid = 'anyone' AND acl.lookup_flag =
'1')))]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]:
db.c,db_findmailbox_by_regex: found [5] mailboxes
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '7']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'INBOX/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [* LSUB
(\hasnochildren) "/" "INBOX" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '8']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'Drafts/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [* LSUB
(\hasnochildren) "/" "Drafts" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '9']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'Sent Items/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [* LSUB
(\hasnochildren) "/" "Sent Items" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '10']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'Junk/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [* LSUB
(\hasnochildren) "/" "Junk" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '11']
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'Deleted Items/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [* LSUB
(\hasnochildren) "/" "Deleted Items" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [lsb OK LSUB
completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command lsub [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: COMMAND: [I LOGOUT]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Executing command logout...
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imapcommands.c,_ic_logout:
user (id:4) logging out @ [2006-07-18 12:37:30]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [* BYE dbmail
imap server kisses you goodbye ]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Finished command logout [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: RESPONSE: [I OK completed
]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]: imap4.c,IMAPClientHandler:
Closing connection for client from IP [10.238.160.15]
Jul 18 12:37:30 localhost dbmail/imap4d[3368]:
serverchild.c,PerformChildTask: client handling complete, closing streams
Jul 18 12:37:30 localhost dbmail/imap4d[3368]:
serverchild.c,PerformChildTask: connection closed
Jul 18 12:37:30 localhost dbmail/imap4d[3368]:
serverchild.c,PerformChildTask: waiting for connection
Jul 18 12:37:30 localhost dbmail/imap4d[3368]:
pool.c,child_reg_disconnected: [3368]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: pool.c,child_reg_connected:
[3366]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]:
serverchild.c,PerformChildTask: incoming connection from [10.238.160.15
(ws01.cove.local)] by pid [3366]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]:
serverchild.c,PerformChildTask: client info init complete, calling client
handler
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* OK dbmail imap
(protocol version 4r1) server 2.1 ready to run ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: COMMAND: [cp01 CAPABILITY]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Executing command capability...
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* CAPABILITY
IMAP4 IMAP4rev1 AUTH=LOGIN ACL NAMESPACE CHILDREN SORT QUOTA ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [cp01 OK
CAPABILITY completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Finished command capability [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: COMMAND: [a001 LOGIN test
"test"]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: arg[0]: 'test'
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: arg[1]: 'test'
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Executing command login...
Jul 18 12:37:30 localhost dbmail/imap4d[3366]:
dbmail-imapsession.c,dbmail_imap_session_handle_auth: trying to validate
user [test], pass [XXXX]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_usermap_resolve:
checking userid 'test' in usermap
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_usermap_resolve:
client on inet socket [inet:10.238.160.20:143]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT login, sock_allow, sock_deny, userid FROM dbmail_usermap WHERE
login in ('test','ANY') ORDER BY sock_allow, sock_deny]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_usermap_resolve:
login 'test' not found in usermap
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower('test')]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE
user_idnr = '4']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: authsql.c,auth_validate:
validating using plaintext passwords
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[UPDATE dbmail_users SET last_login = '2006-07-18 12:37:30' WHERE
user_idnr = '4']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]:
dbmail-imapsession.c,dbmail_imap_session_handle_auth: user (id:4, name
test) tries login
Jul 18 12:37:30 localhost dbmail/imap4d[3366]:
dbmail-imapsession.c,dbmail_imap_session_handle_auth: user (id 4, name
test) login accepted @ 2006-07-18 12:37:30
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [a001 OK LOGIN
completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Finished command login [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: COMMAND: [ns1 NAMESPACE]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Executing command namespace...
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* NAMESPACE ((""
"/")) (("#Users" "/")) (("#Public" "/")) ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [ns1 OK NAMESPACE
complete ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Finished command namespace [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: COMMAND: [ns1 NAMESPACE]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Executing command namespace...
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* NAMESPACE ((""
"/")) (("#Users" "/")) (("#Public" "/")) ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [ns1 OK NAMESPACE
complete ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Finished command namespace [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: COMMAND: [sel1 SELECT
"INBOX"]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: arg[0]: 'INBOX'
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Executing command select...
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_findmailbox:
looking for mailbox with FQN [INBOX].
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_acl_has_right:
checking ACL [read_flag] for user [4] on mailbox [7]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '7']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c, db_acl_has_right:
mailbox [7] is owned by user [4], is that also [4]?
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c, db_acl_has_right:
mailbox [7] is owned by user [4], giving all rights
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '7']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '7']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: 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]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '7' AND
status IN ('0','1') ORDER BY message_idnr ASC]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_getmailbox_count:
exists [1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC
LIMIT 1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '7']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: 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]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '7' AND
status IN ('0','1') ORDER BY message_idnr ASC]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_getmailbox_count:
exists [1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC
LIMIT 1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* 1 EXISTS ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* 1 RECENT ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* FLAGS (\Seen
\Answered \Deleted \Flagged \Draft \Recent) ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* OK
[PERMANENTFLAGS (\Seen \Answered \Deleted \Flagged \Draft \Recent)] ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* OK [UIDNEXT
11] Predicted next UID ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* OK
[UIDVALIDITY 7] UID value ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT MIN(message_idnr) FROM dbmail_messages WHERE mailbox_idnr = '7'
AND status < '2' AND seen_flag = '0']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* OK [UNSEEN 1]
first unseen message ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE recent_flag = 1 AND
mailbox_idnr = '7']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]:
dbmail-imapsession.c,dbmail_imap_session_mailbox_select_recent: recent [1]
in mailbox [7]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [sel1 OK
[READ-WRITE] SELECT completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Finished command select [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '7']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: 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]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '7' AND
status IN ('0','1') ORDER BY message_idnr ASC]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_getmailbox_count:
exists [1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC
LIMIT 1]
Jul 18 12:37:30 localhost dbmail/imap4d[14481]: pool.c,child_register:
register child [14481]
Jul 18 12:37:30 localhost dbmail/imap4d[14481]: pool.c,child_register:
initializing child_state [14481] using slot [2]
Jul 18 12:37:30 localhost dbmail/imap4d[14481]: serverchild.c,CreateChild:
signal handler placed, going to perform task now
Jul 18 12:37:30 localhost dbmail/imap4d[14481]: dbmysql.c,db_connect:
MySQL host is set to localhost, but no mysql_socket has been set. Use
sqlsocket=... in dbmail.conf. Connecting will be attempted using the
default socket.
Jul 18 12:37:30 localhost dbmail/imap4d[14481]: dbmysql.c,db_query: query
[SHOW VARIABLES LIKE 'collation_%']
Jul 18 12:37:30 localhost dbmail/imap4d[14481]:
dbmysql.c,db_mysql_check_collations: does
[collation_database:utf8_general_ci] match
[collation_connection:utf8_general_ci]?
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: COMMAND: [lsb LSUB "" "*"]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: arg[0]: ''
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: arg[1]: '*'
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Executing command lsub...
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imapcommands.c,_ic_list:
search with pattern: [*]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: 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 = '4' AND ((mbx.owner_idnr = '4') OR (acl.user_id = '4' AND
acl.lookup_flag = '1') OR (usr.userid = 'anyone' AND acl.lookup_flag =
'1')))]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]:
db.c,db_findmailbox_by_regex: found [5] mailboxes
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '7']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'INBOX/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[14481]:
serverchild.c,PerformChildTask: waiting for connection
Jul 18 12:37:30 localhost dbmail/imap4d[14481]:
pool.c,child_reg_disconnected: [14481]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* LSUB
(\hasnochildren) "/" "INBOX" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '8']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'Drafts/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* LSUB
(\hasnochildren) "/" "Drafts" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '9']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'Sent Items/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* LSUB
(\hasnochildren) "/" "Sent Items" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '10']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'Junk/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* LSUB
(\hasnochildren) "/" "Junk" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '11']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'Deleted Items/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* LSUB
(\hasnochildren) "/" "Deleted Items" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [lsb OK LSUB
completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Finished command lsub [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3363]:
pool.c,manage_spare_children: children [3/10], spares [2 (2 - 4)]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: COMMAND: [lsb LSUB "" "*"]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: arg[0]: ''
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: arg[1]: '*'
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Executing command lsub...
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imapcommands.c,_ic_list:
search with pattern: [*]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: 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 = '4' AND ((mbx.owner_idnr = '4') OR (acl.user_id = '4' AND
acl.lookup_flag = '1') OR (usr.userid = 'anyone' AND acl.lookup_flag =
'1')))]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]:
db.c,db_findmailbox_by_regex: found [5] mailboxes
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '7']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'INBOX/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* LSUB
(\hasnochildren) "/" "INBOX" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '8']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'Drafts/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* LSUB
(\hasnochildren) "/" "Drafts" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '9']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'Sent Items/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* LSUB
(\hasnochildren) "/" "Sent Items" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '10']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'Junk/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* LSUB
(\hasnochildren) "/" "Junk" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes
WHERE mailbox_idnr = '11']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr =
'4' AND name LIKE 'Deleted Items/%' ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* LSUB
(\hasnochildren) "/" "Deleted Items" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [lsb OK LSUB
completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Finished command lsub [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: COMMAND: [ghd LIST "" ""]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: arg[0]: ''
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: arg[1]: ''
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Executing command list...
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* LIST
(\NoSelect) "/" "" ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [ghd OK LIST
completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Finished command list [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: COMMAND: [sel1 SELECT
"Drafts"]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: arg[0]: 'Drafts'
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Executing command select...
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[update dbmail_messages set recent_flag = 0 where message_idnr in (10)]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_findmailbox:
looking for mailbox with FQN [Drafts].
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Drafts' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_acl_has_right:
checking ACL [read_flag] for user [4] on mailbox [8]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '8']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c, db_acl_has_right:
mailbox [8] is owned by user [4], is that also [4]?
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c, db_acl_has_right:
mailbox [8] is owned by user [4], giving all rights
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '8']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '8']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: 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]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC
LIMIT 1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '8']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: 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]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC
LIMIT 1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* 0 EXISTS ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* 0 RECENT ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* FLAGS (\Seen
\Answered \Deleted \Flagged \Draft \Recent) ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* OK
[PERMANENTFLAGS (\Seen \Answered \Deleted \Flagged \Draft \Recent)] ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* OK [UIDNEXT
11] Predicted next UID ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* OK
[UIDVALIDITY 8] UID value ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT MIN(message_idnr) FROM dbmail_messages WHERE mailbox_idnr = '8'
AND status < '2' AND seen_flag = '0']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_get_result:
result is null
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE recent_flag = 1 AND
mailbox_idnr = '8']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]:
dbmail-imapsession.c,dbmail_imap_session_mailbox_select_recent: recent [0]
in mailbox [8]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [sel1 OK
[READ-WRITE] SELECT completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Finished command select [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '8']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: 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]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC
LIMIT 1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: COMMAND: [sel1 SELECT "Sent
Items"]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: arg[0]: 'Sent Items'
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Executing command select...
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_findmailbox:
looking for mailbox with FQN [Sent Items].
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Sent Items' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_acl_has_right:
checking ACL [read_flag] for user [4] on mailbox [9]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '9']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c, db_acl_has_right:
mailbox [9] is owned by user [4], is that also [4]?
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c, db_acl_has_right:
mailbox [9] is owned by user [4], giving all rights
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '9']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '9']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: 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]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC
LIMIT 1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '9']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: 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]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC
LIMIT 1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* 0 EXISTS ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* 0 RECENT ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* FLAGS (\Seen
\Answered \Deleted \Flagged \Draft \Recent) ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* OK
[PERMANENTFLAGS (\Seen \Answered \Deleted \Flagged \Draft \Recent)] ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* OK [UIDNEXT
11] Predicted next UID ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* OK
[UIDVALIDITY 9] UID value ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT MIN(message_idnr) FROM dbmail_messages WHERE mailbox_idnr = '9'
AND status < '2' AND seen_flag = '0']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_get_result:
result is null
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE recent_flag = 1 AND
mailbox_idnr = '9']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]:
dbmail-imapsession.c,dbmail_imap_session_mailbox_select_recent: recent [0]
in mailbox [9]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [sel1 OK
[READ-WRITE] SELECT completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Finished command select [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '9']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: 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]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC
LIMIT 1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: COMMAND: [sel1 SELECT
"Junk"]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: arg[0]: 'Junk'
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Executing command select...
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_findmailbox:
looking for mailbox with FQN [Junk].
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Junk' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_acl_has_right:
checking ACL [read_flag] for user [4] on mailbox [10]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '10']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c, db_acl_has_right:
mailbox [10] is owned by user [4], is that also [4]?
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c, db_acl_has_right:
mailbox [10] is owned by user [4], giving all rights
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '10']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '10']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='10' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages
WHERE mailbox_idnr='10' AND (status='0' OR status='1') AND seen_flag=1
UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='10' AND
(status='0' OR status='1') AND recent_flag=1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC
LIMIT 1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '10']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='10' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages
WHERE mailbox_idnr='10' AND (status='0' OR status='1') AND seen_flag=1
UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='10' AND
(status='0' OR status='1') AND recent_flag=1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC
LIMIT 1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* 0 EXISTS ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* 0 RECENT ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* FLAGS (\Seen
\Answered \Deleted \Flagged \Draft \Recent) ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* OK
[PERMANENTFLAGS (\Seen \Answered \Deleted \Flagged \Draft \Recent)] ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* OK [UIDNEXT
11] Predicted next UID ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [* OK
[UIDVALIDITY 10] UID value ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT MIN(message_idnr) FROM dbmail_messages WHERE mailbox_idnr = '10'
AND status < '2' AND seen_flag = '0']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_get_result:
result is null
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE recent_flag = 1 AND
mailbox_idnr = '10']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]:
dbmail-imapsession.c,dbmail_imap_session_mailbox_select_recent: recent [0]
in mailbox [10]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: RESPONSE: [sel1 OK
[READ-WRITE] SELECT completed ]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Finished command select [0]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '10']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='10' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages
WHERE mailbox_idnr='10' AND (status='0' OR status='1') AND seen_flag=1
UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='10' AND
(status='0' OR status='1') AND recent_flag=1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC
LIMIT 1]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: COMMAND: [sel1 SELECT
"Deleted Items"]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: arg[0]: 'Deleted Items'
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: imap4.c,IMAPClientHandler:
Executing command select...
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_findmailbox:
looking for mailbox with FQN [Deleted Items].
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='Deleted Items' AND
owner_idnr='4']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c,db_acl_has_right:
checking ACL [read_flag] for user [4] on mailbox [11]
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '11']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c, db_acl_has_right:
mailbox [11] is owned by user [4], is that also [4]?
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: db.c, db_acl_has_right:
mailbox [11] is owned by user [4], giving all rights
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '11']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '11']
Jul 18 12:37:30 localhost dbmail/imap4d[3366]: dbmysql.c,db_query: query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='11' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages
WHERE mailbox_idnr='11' AND (status='0
Issue History
Date Modified Username Field Change
======================================================================
19-Jul-06 09:40 dustmite New Issue
19-Jul-06 11:37 paul Note Added: 0001306
19-Jul-06 12:35 dustmite Note Added: 0001307
======================================================================
