Hi Paul,
Thanks for "sticking with this one"
Attach is a "full log of dbmail-imapd" with
3 transactions comming from Horde.
Maybe you can make something out of this....
Thanks again
Jacques
* Jacques Beaudoin ([EMAIL PROTECTED]) [170106 01:24]:
> Hi Paul,
>
> Horde logging is "crap", even with full loging i can't see no
> usefull imapcommands issued by horde/imp in there log.
No need. Dbmail logs imap commands on level4 and above: just grep for
COMMAND like I said in my first reply.
I don't care much for the sql. If horde issues valid setacl calls, I can
make sure the sql is valid as well.
>
> I give up on trying to find a solution to have ACL work
> between horde/imp and dbmail.
>
> I will desable share folder in horde/imp, it just doesnt work "now"
> with dbmail.
>
> Thanks Paul
>
> Jacques
>
>
> Jacques,
>
> The commands look clean, but without the actual imapcommands issued by
> horde, there's no way of knowing.
>
>
> >=================================================================================
> >If i takeout all 3 flags "lookup,read,seen" in horde/imp
> >these are the mysql updates trancactions to the dbmail_acl table
> >=================================================================================
> >N O T H I N G
> >
> >Yes no mysql update transaction to dbmail_acl table
> >
> >Horde/Imp is sending no update transactions or is it dbmail-imapd that is not
> >updating the dbmail_acl table
> >
> >
> >
> >------------------------------------------------------------------------
> >
> >_______________________________________________
> >Dbmail mailing list
> >Dbmail@dbmail.org
> >https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
> >
>
> --
> ________________________________________________________________
> Paul Stevens mailto:[EMAIL PROTECTED]
> NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
> The Netherlands________________________________http://www.nfg.nl
>
>
> Jacques,
>
> The commands look clean, but without the actual imapcommands issued by
> horde, there's no way of knowing.
>
>
> >=================================================================================
> >If i takeout all 3 flags "lookup,read,seen" in horde/imp
> >these are the mysql updates trancactions to the dbmail_acl table
> >=================================================================================
> >N O T H I N G
> >
> >Yes no mysql update transaction to dbmail_acl table
> >
> >Horde/Imp is sending no update transactions or is it dbmail-imapd that is not
> >updating the dbmail_acl table
> >
> >
> >
> >------------------------------------------------------------------------
> >
> >_______________________________________________
> >Dbmail mailing list
> >Dbmail@dbmail.org
> >https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
> >
>
> --
> ________________________________________________________________
> Paul Stevens mailto:[EMAIL PROTECTED]
> NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
> The Netherlands________________________________http://www.nfg.nl
>
>
> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
> <title></title>
> </head>
> <body bgcolor="#ffffff" text="#000000">
> Jacques,<br>
> <br>
> The commands look clean, but without the actual imapcommands issued by
> horde, there's no way of knowing.<br>
> <br>
> <br>
> <blockquote cite="[EMAIL PROTECTED]"
> type="cite">
> <pre wrap="">
> =================================================================================
> If i takeout all 3 flags "lookup,read,seen" in horde/imp
> these are the mysql updates trancactions to the dbmail_acl table
> =================================================================================
> N O T H I N G
>
> Yes no mysql update transaction to dbmail_acl table
>
> Horde/Imp is sending no update transactions or is it dbmail-imapd that is not
> updating the dbmail_acl table
>
> </pre>
> <pre wrap="">
> <hr size="4" width="90%">
> _______________________________________________
> Dbmail mailing list
> <a class="moz-txt-link-abbreviated"
> href="mailto:Dbmail@dbmail.org";>Dbmail@dbmail.org</a>
> <a class="moz-txt-link-freetext"
href="https://mailman.fastxs.nl/mailman/listinfo/dbmail";>https://mailman.fastxs.nl/mailman/listinfo/dbmail</a>
> </pre>
> </blockquote>
> <br>
> <pre class="moz-signature" cols="72">--
> ________________________________________________________________
> Paul Stevens <a
> class="moz-txt-link-freetext"
href="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</a>
> NET FACILITIES GROUP PGP: finger <a
> class="moz-txt-link-abbreviated"
href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a>
> The Netherlands________________________________<a
> class="moz-txt-link-freetext"
href="http://www.nfg.nl";>http://www.nfg.nl</a>
> </pre>
> </body>
> </html>
>
> _______________________________________________
> Dbmail mailing list
> Dbmail@dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
> _______________________________________________
> Dbmail mailing list
> Dbmail@dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
jacques-beaudoin/INBOX is given ACL HORDE "r" FLAG TO denis-frechette
=====================================================================
Feb 14 14:06:10 mail dbmail/imap4d[28117]: serverchild.c,PerformChildTask:
incoming connection from [10.220.12.2]
Feb 14 14:06:10 mail dbmail/imap4d[28117]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): line read for
PID 28117
Feb 14 14:06:10 mail dbmail/imap4d[28117]: COMMAND: [00000000 CAPABILITY]
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): Finished
command capability
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): line read for
PID 28117
Feb 14 14:06:10 mail dbmail/imap4d[28117]: COMMAND: [00000001 AUTHENTICATE
LOGIN]
Feb 14 14:06:10 mail dbmail/imap4d[28117]: arg[0]: 'LOGIN'
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): Executing
command authenticate...
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE userid =
'jacques-beaudoin']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: authsql.c,auth_validate: validating
using plaintext passwords
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET last_login = '2006-02-14 14:06:10' WHERE user_idnr =
'1166']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPD [PID 28117]: user (id 1166,
name jacques-beaudoin) login accepted @ 2006-02-14 14:06:10
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): Finished
command authenticate
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): line read for
PID 28117
Feb 14 14:06:10 mail dbmail/imap4d[28117]: COMMAND: [00000002 CAPABILITY]
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): Finished
command capability
Feb 14 14:06:10 mail dbmail/imap4d[28121]: serverchild.c,PerformChildTask:
incoming connection from [10.220.12.2]
Feb 14 14:06:10 mail dbmail/imap4d[28121]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Feb 14 14:06:10 mail dbmail/imap4d[28121]: IMAPClientHandler(): line read for
PID 28121
Feb 14 14:06:10 mail dbmail/imap4d[28121]: COMMAND: [x CAPABILITY]
Feb 14 14:06:10 mail dbmail/imap4d[28121]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:06:10 mail dbmail/imap4d[28121]: IMAPClientHandler(): Finished
command capability
Feb 14 14:06:10 mail dbmail/imap4d[28121]: serverchild.c,PerformChildTask:
client handling complete, closing streams
Feb 14 14:06:10 mail dbmail/imap4d[28121]: serverchild.c,client_close: closing
write stream
Feb 14 14:06:10 mail dbmail/imap4d[28121]: serverchild.c,client_close: closing
read stream
Feb 14 14:06:10 mail dbmail/imap4d[28121]: serverchild.c,PerformChildTask:
connection closed
Feb 14 14:06:10 mail dbmail/imap4d[28121]: serverchild.c,PerformChildTask:
waiting for connection
Feb 14 14:06:10 mail dbmail/imap4d[28125]: serverchild.c,PerformChildTask:
incoming connection from [10.220.12.2]
Feb 14 14:06:10 mail dbmail/imap4d[28125]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): line read for
PID 28125
Feb 14 14:06:10 mail dbmail/imap4d[28125]: COMMAND: [00000000 CAPABILITY]
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): Finished
command capability
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): line read for
PID 28125
Feb 14 14:06:10 mail dbmail/imap4d[28125]: COMMAND: [00000001 AUTHENTICATE
LOGIN]
Feb 14 14:06:10 mail dbmail/imap4d[28125]: arg[0]: 'LOGIN'
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): Executing
command authenticate...
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE userid =
'jacques-beaudoin']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: authsql.c,auth_validate: validating
using plaintext passwords
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET last_login = '2006-02-14 14:06:10' WHERE user_idnr =
'1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPD [PID 28125]: user (id 1166,
name jacques-beaudoin) login accepted @ 2006-02-14 14:06:10
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): Finished
command authenticate
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): line read for
PID 28125
Feb 14 14:06:10 mail dbmail/imap4d[28125]: COMMAND: [00000002 CAPABILITY]
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): Finished
command capability
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): line read for
PID 28125
Feb 14 14:06:10 mail dbmail/imap4d[28125]: COMMAND: [00000003 SETACL INBOX
denis-frechette lr]
Feb 14 14:06:10 mail dbmail/imap4d[28125]: arg[0]: 'INBOX'
Feb 14 14:06:10 mail dbmail/imap4d[28125]: arg[1]: 'denis-frechette'
Feb 14 14:06:10 mail dbmail/imap4d[28125]: arg[2]: 'lr'
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): Executing
command setacl...
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c,db_findmailbox: looking for
mailbox with FQN [INBOX].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='denis-frechette']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: acl.c,acl_replace_rights: replacing
rights for user [649], mailbox [1166] to lr
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET lookup_flag = '1' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET read_flag = '1' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET seen_flag = '0' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET write_flag = '0' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET insert_flag = '0' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET post_flag = '0' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET create_flag = '0' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET delete_flag = '0' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET administer_flag = '0' WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28125]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): Finished
command setacl
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): line read for
PID 28117
Feb 14 14:06:10 mail dbmail/imap4d[28117]: COMMAND: [00000003 LIST "" *]
Feb 14 14:06:10 mail dbmail/imap4d[28117]: arg[0]: ''
Feb 14 14:06:10 mail dbmail/imap4d[28117]: arg[1]: '*'
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): Executing
command list...
Feb 14 14:06:10 mail dbmail/imap4d[28117]: ic_list(): build the pattern: [^.*$]
Feb 14 14:06:10 mail dbmail/imap4d[28117]: db.c,db_list_mailboxes_by_regex: in
func
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT mbx.name, mbx.mailbox_idnr, mbx.owner_idnr FROM dbmail_mailboxes mbx
LEFT JOIN dbmail_acl acl ON mbx.mailbox_idnr = acl.mailbox_id LEFT JOIN
dbmail_users usr ON acl.user_id = usr.user_idnr WHERE (mbx.owner_idnr = '1166')
OR (acl.user_id = '1166' AND acl.lookup_flag = '1') OR (usr.userid = 'anyone'
AND acl.lookup_flag = '1')]
Feb 14 14:06:10 mail dbmail/imap4d[28117]: db.c,db_list_mailboxes_by_regex:
checking mailbox: BROULLONS, nr 8510, owner = 1166
Feb 14 14:06:10 mail dbmail/imap4d[28117]: db.c,db_list_mailboxes_by_regex:
comparing mailbox [BROULLONS] to regular expression
Feb 14 14:06:10 mail dbmail/imap4d[28117]: db.c,db_list_mailboxes_by_regex:
regex match BROULLONS, mailbox_idnr = 8510
Feb 14 14:06:10 mail dbmail/imap4d[28117]: db.c,db_list_mailboxes_by_regex:
checking mailbox: ENVOYES, nr 8508, owner = 1166
Feb 14 14:06:10 mail dbmail/imap4d[28117]: db.c,db_list_mailboxes_by_regex:
comparing mailbox [ENVOYES] to regular expression
Feb 14 14:06:10 mail dbmail/imap4d[28117]: db.c,db_list_mailboxes_by_regex:
regex match ENVOYES, mailbox_idnr = 8508
Feb 14 14:06:10 mail dbmail/imap4d[28117]: db.c,db_list_mailboxes_by_regex:
checking mailbox: INBOX, nr 1166, owner = 1166
Feb 14 14:06:10 mail dbmail/imap4d[28117]: db.c,db_list_mailboxes_by_regex:
comparing mailbox [INBOX] to regular expression
Feb 14 14:06:10 mail dbmail/imap4d[28117]: db.c,db_list_mailboxes_by_regex:
regex match INBOX, mailbox_idnr = 1166
Feb 14 14:06:10 mail dbmail/imap4d[28117]: db.c,db_list_mailboxes_by_regex: exit
Feb 14 14:06:10 mail dbmail/imap4d[28117]: db.c,db_findmailbox_by_regex: found
[3] mailboxes
Feb 14 14:06:10 mail dbmail/imap4d[28117]: imapcommands.c,_ic_list: children[0]
= 8510
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '8510']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT name FROM dbmail_mailboxes WHERE mailbox_idnr = '8510']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '8510']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '8510']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name FROM dbmail_mailboxes WHERE mailbox_idnr = '8510' ]
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '1166'
AND name LIKE 'BROULLONS/%']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: imapcommands.c,_ic_list: children[1]
= 8508
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '8508']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT name FROM dbmail_mailboxes WHERE mailbox_idnr = '8508']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '8508']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '8508']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name FROM dbmail_mailboxes WHERE mailbox_idnr = '8508' ]
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '1166'
AND name LIKE 'ENVOYES/%']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: imapcommands.c,_ic_list: children[2]
= 1166
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT name FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' ]
Feb 14 14:06:10 mail dbmail/imap4d[28117]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '1166'
AND name LIKE 'INBOX/%']
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): Finished
command list
Feb 14 14:06:10 mail dbmail/imap4d[28129]: serverchild.c,PerformChildTask:
incoming connection from [10.220.12.2]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Feb 14 14:06:10 mail dbmail/imap4d[28129]: IMAPClientHandler(): line read for
PID 28129
Feb 14 14:06:10 mail dbmail/imap4d[28129]: COMMAND: [0 LOGIN jacques-beaudoin
sarto]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: arg[0]: 'jacques-beaudoin'
Feb 14 14:06:10 mail dbmail/imap4d[28129]: arg[1]: 'sarto'
Feb 14 14:06:10 mail dbmail/imap4d[28129]: IMAPClientHandler(): Executing
command login...
Feb 14 14:06:10 mail dbmail/imap4d[28129]: _ic_login(): trying to validate user
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE userid =
'jacques-beaudoin']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: authsql.c,auth_validate: validating
using plaintext passwords
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET last_login = '2006-02-14 14:06:10' WHERE user_idnr =
'1166']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: _ic_login(): user (id:1166, name
jacques-beaudoin) tries login
Feb 14 14:06:10 mail dbmail/imap4d[28129]: _ic_login(): user (id 1166, name
jacques-beaudoin) login accepted @ 2006-02-14 14:06:10
Feb 14 14:06:10 mail dbmail/imap4d[28129]: IMAPClientHandler(): Finished
command login
Feb 14 14:06:10 mail dbmail/imap4d[28129]: IMAPClientHandler(): line read for
PID 28129
Feb 14 14:06:10 mail dbmail/imap4d[28129]: COMMAND: [1 GETACL INBOX]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: arg[0]: 'INBOX'
Feb 14 14:06:10 mail dbmail/imap4d[28129]: IMAPClientHandler(): Executing
command getacl...
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_findmailbox: looking for
mailbox with FQN [INBOX].
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='1166']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT dbmail_users.userid FROM dbmail_users, dbmail_acl WHERE
dbmail_acl.mailbox_id = '1166' AND dbmail_users.user_idnr = dbmail_acl.user_id]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_get_identifier: adding
denis-frechette to identifier list
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT userid FROM dbmail_users WHERE user_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: authsql.c,auth_get_userid:
query_result = jacques-beaudoin
Feb 14 14:06:10 mail dbmail/imap4d[28129]: authsql.c,auth_get_userid: returning
jacques-beaudoin as returnid
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_acl: before looping
identifiers!
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_acl: acl_string size =
53
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='jacques-beaudoin']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring: i = 0.
char is l, str = l
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring: i = 1.
char is r, str = lr
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lr
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring: i = 2.
char is s, str = lrs
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lrs
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring: i = 3.
char is w, str = lrsw
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lrsw
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring: i = 4.
char is i, str = lrswi
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lrswi
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring: i = 5.
char is p, str = lrswip
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lrswip
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring: i = 6.
char is c, str = lrswipc
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lrswipc
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring: i = 7.
char is d, str = lrswipcd
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lrswipcd
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring: i = 8.
char is a, str = lrswipcda
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lrswipcda
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_acl: lrswipcda
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='denis-frechette']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
lookup_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring: i = 0.
char is l, str = l
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
read_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring: i = 1.
char is r, str = lr
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lr
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
seen_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
seen_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lr
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
write_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
write_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lr
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
insert_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
insert_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lr
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
post_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
post_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lr
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
create_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
create_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lr
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
delete_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
delete_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lr
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
administer_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
administer_flag = '1']
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_rightsstring
rightsstring currently is lr
Feb 14 14:06:10 mail dbmail/imap4d[28129]: acl.c,acl_get_acl: lr
Feb 14 14:06:10 mail dbmail/imap4d[28129]: IMAPClientHandler(): Finished
command getacl
Feb 14 14:06:10 mail dbmail/imap4d[28129]: serverchild.c,PerformChildTask:
client handling complete, closing streams
Feb 14 14:06:10 mail dbmail/imap4d[28129]: serverchild.c,client_close: closing
write stream
Feb 14 14:06:10 mail dbmail/imap4d[28129]: serverchild.c,client_close: closing
read stream
Feb 14 14:06:10 mail dbmail/imap4d[28129]: serverchild.c,PerformChildTask:
connection closed
Feb 14 14:06:10 mail dbmail/imap4d[28129]: serverchild.c,PerformChildTask:
waiting for connection
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): line read for
PID 28117
Feb 14 14:06:10 mail dbmail/imap4d[28117]: COMMAND: [00000004 LOGOUT]
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): Executing
command logout...
Feb 14 14:06:10 mail dbmail/imap4d[28117]: _ic_logout(): user (id:1166) logging
out @ [2006-02-14 14:06:10]
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): Finished
command logout
Feb 14 14:06:10 mail dbmail/imap4d[28117]: IMAPClientHandler(): Closing
connection for client from IP [10.220.12.2]
Feb 14 14:06:10 mail dbmail/imap4d[28117]: serverchild.c,PerformChildTask:
client handling complete, closing streams
Feb 14 14:06:10 mail dbmail/imap4d[28117]: serverchild.c,client_close: closing
write stream
Feb 14 14:06:10 mail dbmail/imap4d[28117]: serverchild.c,client_close: closing
read stream
Feb 14 14:06:10 mail dbmail/imap4d[28117]: serverchild.c,PerformChildTask:
connection closed
Feb 14 14:06:10 mail dbmail/imap4d[28117]: serverchild.c,PerformChildTask:
waiting for connection
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): line read for
PID 28125
Feb 14 14:06:10 mail dbmail/imap4d[28125]: COMMAND: [00000004 LOGOUT]
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): Executing
command logout...
Feb 14 14:06:10 mail dbmail/imap4d[28125]: _ic_logout(): user (id:1166) logging
out @ [2006-02-14 14:06:10]
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): Finished
command logout
Feb 14 14:06:10 mail dbmail/imap4d[28125]: IMAPClientHandler(): Closing
connection for client from IP [10.220.12.2]
Feb 14 14:06:10 mail dbmail/imap4d[28125]: serverchild.c,PerformChildTask:
client handling complete, closing streams
Feb 14 14:06:10 mail dbmail/imap4d[28125]: serverchild.c,client_close: closing
write stream
Feb 14 14:06:10 mail dbmail/imap4d[28125]: serverchild.c,client_close: closing
read stream
Feb 14 14:06:10 mail dbmail/imap4d[28125]: serverchild.c,PerformChildTask:
connection closed
Feb 14 14:06:10 mail dbmail/imap4d[28125]: serverchild.c,PerformChildTask:
waiting for connection
====== END OF TRANSACTION ALL IS OK =======
jacques-beaudoin/INBOX take's out the ACL HORDE "r" FLAG TO denis-frechette
===========================================================================
Feb 14 14:08:25 mail dbmail/imap4d[28133]: serverchild.c,PerformChildTask:
incoming connection from [10.220.12.2]
Feb 14 14:08:25 mail dbmail/imap4d[28133]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): line read for
PID 28133
Feb 14 14:08:25 mail dbmail/imap4d[28133]: COMMAND: [00000000 CAPABILITY]
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): Finished
command capability
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): line read for
PID 28133
Feb 14 14:08:25 mail dbmail/imap4d[28133]: COMMAND: [00000001 AUTHENTICATE
LOGIN]
Feb 14 14:08:25 mail dbmail/imap4d[28133]: arg[0]: 'LOGIN'
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): Executing
command authenticate...
Feb 14 14:08:25 mail dbmail/imap4d[28133]: dbmysql.c,db_query: executing query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE userid =
'jacques-beaudoin']
Feb 14 14:08:25 mail dbmail/imap4d[28133]: authsql.c,auth_validate: validating
using plaintext passwords
Feb 14 14:08:25 mail dbmail/imap4d[28133]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET last_login = '2006-02-14 14:08:25' WHERE user_idnr =
'1166']
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPD [PID 28133]: user (id 1166,
name jacques-beaudoin) login accepted @ 2006-02-14 14:08:25
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): Finished
command authenticate
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): line read for
PID 28133
Feb 14 14:08:25 mail dbmail/imap4d[28133]: COMMAND: [00000002 CAPABILITY]
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): Finished
command capability
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): line read for
PID 28133
Feb 14 14:08:25 mail dbmail/imap4d[28133]: COMMAND: [00000003 STATUS INBOX
(MESSAGES RECENT UNSEEN)]
Feb 14 14:08:25 mail dbmail/imap4d[28133]: arg[0]: 'INBOX'
Feb 14 14:08:25 mail dbmail/imap4d[28133]: arg[1]: '('
Feb 14 14:08:25 mail dbmail/imap4d[28133]: arg[2]: 'MESSAGES'
Feb 14 14:08:25 mail dbmail/imap4d[28133]: arg[3]: 'RECENT'
Feb 14 14:08:25 mail dbmail/imap4d[28133]: arg[4]: 'UNSEEN'
Feb 14 14:08:25 mail dbmail/imap4d[28133]: arg[5]: ')'
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): Executing
command status...
Feb 14 14:08:25 mail dbmail/imap4d[28133]: db.c,db_findmailbox: looking for
mailbox with FQN [INBOX].
Feb 14 14:08:25 mail dbmail/imap4d[28133]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='1166']
Feb 14 14:08:25 mail dbmail/imap4d[28133]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:08:25 mail dbmail/imap4d[28133]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:08:25 mail dbmail/imap4d[28133]: 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 = '1166']
Feb 14 14:08:25 mail dbmail/imap4d[28133]: dbmysql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='1166' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='1166' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='1166' AND (status='0' OR
status='1') AND recent_flag=1]
Feb 14 14:08:25 mail dbmail/imap4d[28133]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '1166' AND
status < '2' ORDER BY message_idnr ASC]
Feb 14 14:08:25 mail dbmail/imap4d[28133]: dbmysql.c,db_query: executing query
[SELECT message_idnr + 1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT
1]
Feb 14 14:08:25 mail dbmail/imap4d[28133]: imapcommands.c,_ic_status: RESPONSE
[ * STATUS "INBOX" (MESSAGES 1 RECENT 1 UNSEEN 0)^M ]
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): Finished
command status
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): line read for
PID 28133
Feb 14 14:08:25 mail dbmail/imap4d[28133]: COMMAND: [00000004 LOGOUT]
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): Executing
command logout...
Feb 14 14:08:25 mail dbmail/imap4d[28133]: _ic_logout(): user (id:1166) logging
out @ [2006-02-14 14:08:25]
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): Finished
command logout
Feb 14 14:08:25 mail dbmail/imap4d[28133]: IMAPClientHandler(): Closing
connection for client from IP [10.220.12.2]
Feb 14 14:08:25 mail dbmail/imap4d[28133]: serverchild.c,PerformChildTask:
client handling complete, closing streams
Feb 14 14:08:25 mail dbmail/imap4d[28133]: serverchild.c,client_close: closing
write stream
Feb 14 14:08:25 mail dbmail/imap4d[28133]: serverchild.c,client_close: closing
read stream
Feb 14 14:08:25 mail dbmail/imap4d[28133]: serverchild.c,PerformChildTask:
connection closed
Feb 14 14:08:25 mail dbmail/imap4d[28133]: serverchild.c,PerformChildTask:
waiting for connection
Feb 14 14:08:37 mail dbmail/imap4d[28127]: serverchild.c,PerformChildTask:
incoming connection from [10.220.12.2]
Feb 14 14:08:37 mail dbmail/imap4d[28127]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): line read for
PID 28127
Feb 14 14:08:37 mail dbmail/imap4d[28127]: COMMAND: [00000000 CAPABILITY]
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): Finished
command capability
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): line read for
PID 28127
Feb 14 14:08:37 mail dbmail/imap4d[28127]: COMMAND: [00000001 AUTHENTICATE
LOGIN]
Feb 14 14:08:37 mail dbmail/imap4d[28127]: arg[0]: 'LOGIN'
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): Executing
command authenticate...
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE userid =
'jacques-beaudoin']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: authsql.c,auth_validate: validating
using plaintext passwords
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET last_login = '2006-02-14 14:08:37' WHERE user_idnr =
'1166']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPD [PID 28127]: user (id 1166,
name jacques-beaudoin) login accepted @ 2006-02-14 14:08:37
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): Finished
command authenticate
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): line read for
PID 28127
Feb 14 14:08:37 mail dbmail/imap4d[28127]: COMMAND: [00000002 CAPABILITY]
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): Finished
command capability
Feb 14 14:08:37 mail dbmail/imap4d[28131]: serverchild.c,PerformChildTask:
incoming connection from [10.220.12.2]
Feb 14 14:08:37 mail dbmail/imap4d[28131]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Feb 14 14:08:37 mail dbmail/imap4d[28131]: IMAPClientHandler(): line read for
PID 28131
Feb 14 14:08:37 mail dbmail/imap4d[28131]: COMMAND: [x CAPABILITY]
Feb 14 14:08:37 mail dbmail/imap4d[28131]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:08:37 mail dbmail/imap4d[28131]: IMAPClientHandler(): Finished
command capability
Feb 14 14:08:37 mail dbmail/imap4d[28131]: serverchild.c,PerformChildTask:
client handling complete, closing streams
Feb 14 14:08:37 mail dbmail/imap4d[28131]: serverchild.c,client_close: closing
write stream
Feb 14 14:08:37 mail dbmail/imap4d[28131]: serverchild.c,client_close: closing
read stream
Feb 14 14:08:37 mail dbmail/imap4d[28131]: serverchild.c,PerformChildTask:
connection closed
Feb 14 14:08:37 mail dbmail/imap4d[28131]: serverchild.c,PerformChildTask:
waiting for connection
Feb 14 14:08:37 mail dbmail/imap4d[28137]: serverchild.c,PerformChildTask:
incoming connection from [10.220.12.2]
Feb 14 14:08:37 mail dbmail/imap4d[28137]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): line read for
PID 28137
Feb 14 14:08:37 mail dbmail/imap4d[28137]: COMMAND: [00000000 CAPABILITY]
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): Finished
command capability
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): line read for
PID 28137
Feb 14 14:08:37 mail dbmail/imap4d[28137]: COMMAND: [00000001 AUTHENTICATE
LOGIN]
Feb 14 14:08:37 mail dbmail/imap4d[28137]: arg[0]: 'LOGIN'
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): Executing
command authenticate...
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE userid =
'jacques-beaudoin']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: authsql.c,auth_validate: validating
using plaintext passwords
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET last_login = '2006-02-14 14:08:37' WHERE user_idnr =
'1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPD [PID 28137]: user (id 1166,
name jacques-beaudoin) login accepted @ 2006-02-14 14:08:37
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): Finished
command authenticate
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): line read for
PID 28137
Feb 14 14:08:37 mail dbmail/imap4d[28137]: COMMAND: [00000002 CAPABILITY]
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): Finished
command capability
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): line read for
PID 28137
Feb 14 14:08:37 mail dbmail/imap4d[28137]: COMMAND: [00000003 SETACL INBOX
denis-frechette l]
Feb 14 14:08:37 mail dbmail/imap4d[28137]: arg[0]: 'INBOX'
Feb 14 14:08:37 mail dbmail/imap4d[28137]: arg[1]: 'denis-frechette'
Feb 14 14:08:37 mail dbmail/imap4d[28137]: arg[2]: 'l'
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): Executing
command setacl...
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c,db_findmailbox: looking for
mailbox with FQN [INBOX].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='denis-frechette']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: acl.c,acl_replace_rights: replacing
rights for user [649], mailbox [1166] to l
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET lookup_flag = '1' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET read_flag = '0' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET seen_flag = '0' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET write_flag = '0' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET insert_flag = '0' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET post_flag = '0' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET create_flag = '0' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET delete_flag = '0' WHERE user_id = '649' AND mailbox_id =
'1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c, db_acl_set_right: Setting ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[SELECT user_id, mailbox_id FROM dbmail_acl WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: dbmysql.c,db_query: executing query
[UPDATE dbmail_acl SET administer_flag = '0' WHERE user_id = '649' AND
mailbox_id = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28137]: db.c,db_acl_set_right: Updated ACL
for user [649], mailbox [1166].
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): Finished
command setacl
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): line read for
PID 28127
Feb 14 14:08:37 mail dbmail/imap4d[28127]: COMMAND: [00000003 LIST "" *]
Feb 14 14:08:37 mail dbmail/imap4d[28127]: arg[0]: ''
Feb 14 14:08:37 mail dbmail/imap4d[28127]: arg[1]: '*'
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): Executing
command list...
Feb 14 14:08:37 mail dbmail/imap4d[28127]: ic_list(): build the pattern: [^.*$]
Feb 14 14:08:37 mail dbmail/imap4d[28127]: db.c,db_list_mailboxes_by_regex: in
func
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT mbx.name, mbx.mailbox_idnr, mbx.owner_idnr FROM dbmail_mailboxes mbx
LEFT JOIN dbmail_acl acl ON mbx.mailbox_idnr = acl.mailbox_id LEFT JOIN
dbmail_users usr ON acl.user_id = usr.user_idnr WHERE (mbx.owner_idnr = '1166')
OR (acl.user_id = '1166' AND acl.lookup_flag = '1') OR (usr.userid = 'anyone'
AND acl.lookup_flag = '1')]
Feb 14 14:08:37 mail dbmail/imap4d[28127]: db.c,db_list_mailboxes_by_regex:
checking mailbox: BROULLONS, nr 8510, owner = 1166
Feb 14 14:08:37 mail dbmail/imap4d[28127]: db.c,db_list_mailboxes_by_regex:
comparing mailbox [BROULLONS] to regular expression
Feb 14 14:08:37 mail dbmail/imap4d[28127]: db.c,db_list_mailboxes_by_regex:
regex match BROULLONS, mailbox_idnr = 8510
Feb 14 14:08:37 mail dbmail/imap4d[28127]: db.c,db_list_mailboxes_by_regex:
checking mailbox: ENVOYES, nr 8508, owner = 1166
Feb 14 14:08:37 mail dbmail/imap4d[28127]: db.c,db_list_mailboxes_by_regex:
comparing mailbox [ENVOYES] to regular expression
Feb 14 14:08:37 mail dbmail/imap4d[28127]: db.c,db_list_mailboxes_by_regex:
regex match ENVOYES, mailbox_idnr = 8508
Feb 14 14:08:37 mail dbmail/imap4d[28127]: db.c,db_list_mailboxes_by_regex:
checking mailbox: INBOX, nr 1166, owner = 1166
Feb 14 14:08:37 mail dbmail/imap4d[28127]: db.c,db_list_mailboxes_by_regex:
comparing mailbox [INBOX] to regular expression
Feb 14 14:08:37 mail dbmail/imap4d[28127]: db.c,db_list_mailboxes_by_regex:
regex match INBOX, mailbox_idnr = 1166
Feb 14 14:08:37 mail dbmail/imap4d[28127]: db.c,db_list_mailboxes_by_regex: exit
Feb 14 14:08:37 mail dbmail/imap4d[28127]: db.c,db_findmailbox_by_regex: found
[3] mailboxes
Feb 14 14:08:37 mail dbmail/imap4d[28127]: imapcommands.c,_ic_list: children[0]
= 8510
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '8510']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT name FROM dbmail_mailboxes WHERE mailbox_idnr = '8510']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '8510']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '8510']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name FROM dbmail_mailboxes WHERE mailbox_idnr = '8510' ]
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '1166'
AND name LIKE 'BROULLONS/%']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: imapcommands.c,_ic_list: children[1]
= 8508
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '8508']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT name FROM dbmail_mailboxes WHERE mailbox_idnr = '8508']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '8508']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '8508']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name FROM dbmail_mailboxes WHERE mailbox_idnr = '8508' ]
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '1166'
AND name LIKE 'ENVOYES/%']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: imapcommands.c,_ic_list: children[2]
= 1166
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT name FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' ]
Feb 14 14:08:37 mail dbmail/imap4d[28127]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '1166'
AND name LIKE 'INBOX/%']
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): Finished
command list
Feb 14 14:08:37 mail dbmail/imap4d[28141]: serverchild.c,PerformChildTask:
incoming connection from [10.220.12.2]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Feb 14 14:08:37 mail dbmail/imap4d[28141]: IMAPClientHandler(): line read for
PID 28141
Feb 14 14:08:37 mail dbmail/imap4d[28141]: COMMAND: [0 LOGIN jacques-beaudoin
sarto]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: arg[0]: 'jacques-beaudoin'
Feb 14 14:08:37 mail dbmail/imap4d[28141]: arg[1]: 'sarto'
Feb 14 14:08:37 mail dbmail/imap4d[28141]: IMAPClientHandler(): Executing
command login...
Feb 14 14:08:37 mail dbmail/imap4d[28141]: _ic_login(): trying to validate user
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE userid =
'jacques-beaudoin']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: authsql.c,auth_validate: validating
using plaintext passwords
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET last_login = '2006-02-14 14:08:37' WHERE user_idnr =
'1166']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: _ic_login(): user (id:1166, name
jacques-beaudoin) tries login
Feb 14 14:08:37 mail dbmail/imap4d[28141]: _ic_login(): user (id 1166, name
jacques-beaudoin) login accepted @ 2006-02-14 14:08:37
Feb 14 14:08:37 mail dbmail/imap4d[28141]: IMAPClientHandler(): Finished
command login
Feb 14 14:08:37 mail dbmail/imap4d[28141]: IMAPClientHandler(): line read for
PID 28141
Feb 14 14:08:37 mail dbmail/imap4d[28141]: COMMAND: [1 GETACL INBOX]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: arg[0]: 'INBOX'
Feb 14 14:08:37 mail dbmail/imap4d[28141]: IMAPClientHandler(): Executing
command getacl...
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_findmailbox: looking for
mailbox with FQN [INBOX].
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='1166']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT dbmail_users.userid FROM dbmail_users, dbmail_acl WHERE
dbmail_acl.mailbox_id = '1166' AND dbmail_users.user_idnr = dbmail_acl.user_id]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_get_identifier: adding
denis-frechette to identifier list
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT userid FROM dbmail_users WHERE user_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: authsql.c,auth_get_userid:
query_result = jacques-beaudoin
Feb 14 14:08:37 mail dbmail/imap4d[28141]: authsql.c,auth_get_userid: returning
jacques-beaudoin as returnid
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_acl: before looping
identifiers!
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_acl: acl_string size =
53
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='jacques-beaudoin']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring: i = 0.
char is l, str = l
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring: i = 1.
char is r, str = lr
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is lr
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring: i = 2.
char is s, str = lrs
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is lrs
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring: i = 3.
char is w, str = lrsw
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is lrsw
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring: i = 4.
char is i, str = lrswi
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is lrswi
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring: i = 5.
char is p, str = lrswip
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is lrswip
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring: i = 6.
char is c, str = lrswipc
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is lrswipc
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring: i = 7.
char is d, str = lrswipcd
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is lrswipcd
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring: i = 8.
char is a, str = lrswipcda
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is lrswipcda
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_acl: lrswipcda
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='denis-frechette']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
lookup_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring: i = 0.
char is l, str = l
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
read_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
read_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
seen_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
seen_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
write_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
write_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
insert_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
insert_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
post_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
post_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
create_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
create_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
delete_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
delete_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
administer_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
administer_flag = '1']
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:08:37 mail dbmail/imap4d[28141]: acl.c,acl_get_acl: l
Feb 14 14:08:37 mail dbmail/imap4d[28141]: IMAPClientHandler(): Finished
command getacl
Feb 14 14:08:37 mail dbmail/imap4d[28141]: serverchild.c,PerformChildTask:
client handling complete, closing streams
Feb 14 14:08:37 mail dbmail/imap4d[28141]: serverchild.c,client_close: closing
write stream
Feb 14 14:08:37 mail dbmail/imap4d[28141]: serverchild.c,client_close: closing
read stream
Feb 14 14:08:37 mail dbmail/imap4d[28141]: serverchild.c,PerformChildTask:
connection closed
Feb 14 14:08:37 mail dbmail/imap4d[28141]: serverchild.c,PerformChildTask:
waiting for connection
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): line read for
PID 28127
Feb 14 14:08:37 mail dbmail/imap4d[28127]: COMMAND: [00000004 LOGOUT]
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): Executing
command logout...
Feb 14 14:08:37 mail dbmail/imap4d[28127]: _ic_logout(): user (id:1166) logging
out @ [2006-02-14 14:08:37]
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): Finished
command logout
Feb 14 14:08:37 mail dbmail/imap4d[28127]: IMAPClientHandler(): Closing
connection for client from IP [10.220.12.2]
Feb 14 14:08:37 mail dbmail/imap4d[28127]: serverchild.c,PerformChildTask:
client handling complete, closing streams
Feb 14 14:08:37 mail dbmail/imap4d[28127]: serverchild.c,client_close: closing
write stream
Feb 14 14:08:37 mail dbmail/imap4d[28127]: serverchild.c,client_close: closing
read stream
Feb 14 14:08:37 mail dbmail/imap4d[28127]: serverchild.c,PerformChildTask:
connection closed
Feb 14 14:08:37 mail dbmail/imap4d[28127]: serverchild.c,PerformChildTask:
waiting for connection
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): line read for
PID 28137
Feb 14 14:08:37 mail dbmail/imap4d[28137]: COMMAND: [00000004 LOGOUT]
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): Executing
command logout...
Feb 14 14:08:37 mail dbmail/imap4d[28137]: _ic_logout(): user (id:1166) logging
out @ [2006-02-14 14:08:37]
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): Finished
command logout
Feb 14 14:08:37 mail dbmail/imap4d[28137]: IMAPClientHandler(): Closing
connection for client from IP [10.220.12.2]
Feb 14 14:08:37 mail dbmail/imap4d[28137]: serverchild.c,PerformChildTask:
client handling complete, closing streams
Feb 14 14:08:37 mail dbmail/imap4d[28137]: serverchild.c,client_close: closing
write stream
Feb 14 14:08:37 mail dbmail/imap4d[28137]: serverchild.c,client_close: closing
read stream
Feb 14 14:08:37 mail dbmail/imap4d[28137]: serverchild.c,PerformChildTask:
connection closed
Feb 14 14:08:37 mail dbmail/imap4d[28137]: serverchild.c,PerformChildTask:
waiting for connection
====== END OF TRANSACTION ALL IS OK =======
jacques-beaudoin/INBOX take's out the last ACL HORDE "l" FLAG TO denis-frechette
================================================================================
Feb 14 14:10:02 mail dbmail/imap4d[28135]: serverchild.c,PerformChildTask:
incoming connection from [10.220.12.2]
Feb 14 14:10:02 mail dbmail/imap4d[28135]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): line read for
PID 28135
Feb 14 14:10:02 mail dbmail/imap4d[28135]: COMMAND: [00000000 CAPABILITY]
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): Finished
command capability
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): line read for
PID 28135
Feb 14 14:10:02 mail dbmail/imap4d[28135]: COMMAND: [00000001 AUTHENTICATE
LOGIN]
Feb 14 14:10:02 mail dbmail/imap4d[28135]: arg[0]: 'LOGIN'
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): Executing
command authenticate...
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE userid =
'jacques-beaudoin']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: authsql.c,auth_validate: validating
using plaintext passwords
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET last_login = '2006-02-14 14:10:02' WHERE user_idnr =
'1166']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPD [PID 28135]: user (id 1166,
name jacques-beaudoin) login accepted @ 2006-02-14 14:10:02
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): Finished
command authenticate
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): line read for
PID 28135
Feb 14 14:10:02 mail dbmail/imap4d[28135]: COMMAND: [00000002 CAPABILITY]
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): Finished
command capability
Feb 14 14:10:02 mail dbmail/imap4d[28139]: serverchild.c,PerformChildTask:
incoming connection from [10.220.12.2]
Feb 14 14:10:02 mail dbmail/imap4d[28139]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Feb 14 14:10:02 mail dbmail/imap4d[28139]: IMAPClientHandler(): line read for
PID 28139
Feb 14 14:10:02 mail dbmail/imap4d[28139]: COMMAND: [x CAPABILITY]
Feb 14 14:10:02 mail dbmail/imap4d[28139]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:10:02 mail dbmail/imap4d[28139]: IMAPClientHandler(): Finished
command capability
Feb 14 14:10:02 mail dbmail/imap4d[28139]: serverchild.c,PerformChildTask:
client handling complete, closing streams
Feb 14 14:10:02 mail dbmail/imap4d[28139]: serverchild.c,client_close: closing
write stream
Feb 14 14:10:02 mail dbmail/imap4d[28139]: serverchild.c,client_close: closing
read stream
Feb 14 14:10:02 mail dbmail/imap4d[28139]: serverchild.c,PerformChildTask:
connection closed
Feb 14 14:10:02 mail dbmail/imap4d[28139]: serverchild.c,PerformChildTask:
waiting for connection
Feb 14 14:10:02 mail dbmail/imap4d[28145]: serverchild.c,PerformChildTask:
incoming connection from [10.220.12.2]
Feb 14 14:10:02 mail dbmail/imap4d[28145]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): line read for
PID 28145
Feb 14 14:10:02 mail dbmail/imap4d[28145]: COMMAND: [00000000 CAPABILITY]
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): Finished
command capability
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): line read for
PID 28145
Feb 14 14:10:02 mail dbmail/imap4d[28145]: COMMAND: [00000001 AUTHENTICATE
LOGIN]
Feb 14 14:10:02 mail dbmail/imap4d[28145]: arg[0]: 'LOGIN'
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): Executing
command authenticate...
Feb 14 14:10:02 mail dbmail/imap4d[28145]: dbmysql.c,db_query: executing query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE userid =
'jacques-beaudoin']
Feb 14 14:10:02 mail dbmail/imap4d[28145]: authsql.c,auth_validate: validating
using plaintext passwords
Feb 14 14:10:02 mail dbmail/imap4d[28145]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET last_login = '2006-02-14 14:10:02' WHERE user_idnr =
'1166']
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPD [PID 28145]: user (id 1166,
name jacques-beaudoin) login accepted @ 2006-02-14 14:10:02
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): Finished
command authenticate
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): line read for
PID 28145
Feb 14 14:10:02 mail dbmail/imap4d[28145]: COMMAND: [00000002 CAPABILITY]
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): Executing
command capability...
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): Finished
command capability
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): line read for
PID 28145
Feb 14 14:10:02 mail dbmail/imap4d[28145]: COMMAND: [00000003 SETACL INBOX
denis-frechette ""]
Feb 14 14:10:02 mail dbmail/imap4d[28145]: arg[0]: 'INBOX'
Feb 14 14:10:02 mail dbmail/imap4d[28145]: arg[1]: 'denis-frechette'
Feb 14 14:10:02 mail dbmail/imap4d[28145]: arg[2]: ''
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): Executing
command setacl...
Feb 14 14:10:02 mail dbmail/imap4d[28145]: db.c,db_findmailbox: looking for
mailbox with FQN [INBOX].
Feb 14 14:10:02 mail dbmail/imap4d[28145]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='1166']
Feb 14 14:10:02 mail dbmail/imap4d[28145]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='denis-frechette']
Feb 14 14:10:02 mail dbmail/imap4d[28145]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28145]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): Finished
command setacl
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): line read for
PID 28135
Feb 14 14:10:02 mail dbmail/imap4d[28135]: COMMAND: [00000003 LIST "" *]
Feb 14 14:10:02 mail dbmail/imap4d[28135]: arg[0]: ''
Feb 14 14:10:02 mail dbmail/imap4d[28135]: arg[1]: '*'
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): Executing
command list...
Feb 14 14:10:02 mail dbmail/imap4d[28135]: ic_list(): build the pattern: [^.*$]
Feb 14 14:10:02 mail dbmail/imap4d[28135]: db.c,db_list_mailboxes_by_regex: in
func
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT mbx.name, mbx.mailbox_idnr, mbx.owner_idnr FROM dbmail_mailboxes mbx
LEFT JOIN dbmail_acl acl ON mbx.mailbox_idnr = acl.mailbox_id LEFT JOIN
dbmail_users usr ON acl.user_id = usr.user_idnr WHERE (mbx.owner_idnr = '1166')
OR (acl.user_id = '1166' AND acl.lookup_flag = '1') OR (usr.userid = 'anyone'
AND acl.lookup_flag = '1')]
Feb 14 14:10:02 mail dbmail/imap4d[28135]: db.c,db_list_mailboxes_by_regex:
checking mailbox: BROULLONS, nr 8510, owner = 1166
Feb 14 14:10:02 mail dbmail/imap4d[28135]: db.c,db_list_mailboxes_by_regex:
comparing mailbox [BROULLONS] to regular expression
Feb 14 14:10:02 mail dbmail/imap4d[28135]: db.c,db_list_mailboxes_by_regex:
regex match BROULLONS, mailbox_idnr = 8510
Feb 14 14:10:02 mail dbmail/imap4d[28135]: db.c,db_list_mailboxes_by_regex:
checking mailbox: ENVOYES, nr 8508, owner = 1166
Feb 14 14:10:02 mail dbmail/imap4d[28135]: db.c,db_list_mailboxes_by_regex:
comparing mailbox [ENVOYES] to regular expression
Feb 14 14:10:02 mail dbmail/imap4d[28135]: db.c,db_list_mailboxes_by_regex:
regex match ENVOYES, mailbox_idnr = 8508
Feb 14 14:10:02 mail dbmail/imap4d[28135]: db.c,db_list_mailboxes_by_regex:
checking mailbox: INBOX, nr 1166, owner = 1166
Feb 14 14:10:02 mail dbmail/imap4d[28135]: db.c,db_list_mailboxes_by_regex:
comparing mailbox [INBOX] to regular expression
Feb 14 14:10:02 mail dbmail/imap4d[28135]: db.c,db_list_mailboxes_by_regex:
regex match INBOX, mailbox_idnr = 1166
Feb 14 14:10:02 mail dbmail/imap4d[28135]: db.c,db_list_mailboxes_by_regex: exit
Feb 14 14:10:02 mail dbmail/imap4d[28135]: db.c,db_findmailbox_by_regex: found
[3] mailboxes
Feb 14 14:10:02 mail dbmail/imap4d[28135]: imapcommands.c,_ic_list: children[0]
= 8510
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '8510']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT name FROM dbmail_mailboxes WHERE mailbox_idnr = '8510']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '8510']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '8510']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name FROM dbmail_mailboxes WHERE mailbox_idnr = '8510' ]
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '1166'
AND name LIKE 'BROULLONS/%']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: imapcommands.c,_ic_list: children[1]
= 8508
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '8508']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT name FROM dbmail_mailboxes WHERE mailbox_idnr = '8508']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '8508']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '8508']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name FROM dbmail_mailboxes WHERE mailbox_idnr = '8508' ]
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '1166'
AND name LIKE 'ENVOYES/%']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: imapcommands.c,_ic_list: children[2]
= 1166
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT name FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT owner_idnr, name FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' ]
Feb 14 14:10:02 mail dbmail/imap4d[28135]: dbmysql.c,db_query: executing query
[SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '1166'
AND name LIKE 'INBOX/%']
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): Finished
command list
Feb 14 14:10:02 mail dbmail/imap4d[28123]: serverchild.c,PerformChildTask:
incoming connection from [10.220.12.2]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Feb 14 14:10:02 mail dbmail/imap4d[28123]: IMAPClientHandler(): line read for
PID 28123
Feb 14 14:10:02 mail dbmail/imap4d[28123]: COMMAND: [0 LOGIN jacques-beaudoin
sarto]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: arg[0]: 'jacques-beaudoin'
Feb 14 14:10:02 mail dbmail/imap4d[28123]: arg[1]: 'sarto'
Feb 14 14:10:02 mail dbmail/imap4d[28123]: IMAPClientHandler(): Executing
command login...
Feb 14 14:10:02 mail dbmail/imap4d[28123]: _ic_login(): trying to validate user
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE userid =
'jacques-beaudoin']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: authsql.c,auth_validate: validating
using plaintext passwords
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET last_login = '2006-02-14 14:10:02' WHERE user_idnr =
'1166']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: _ic_login(): user (id:1166, name
jacques-beaudoin) tries login
Feb 14 14:10:02 mail dbmail/imap4d[28123]: _ic_login(): user (id 1166, name
jacques-beaudoin) login accepted @ 2006-02-14 14:10:02
Feb 14 14:10:02 mail dbmail/imap4d[28123]: IMAPClientHandler(): Finished
command login
Feb 14 14:10:02 mail dbmail/imap4d[28123]: IMAPClientHandler(): line read for
PID 28123
Feb 14 14:10:02 mail dbmail/imap4d[28123]: COMMAND: [1 GETACL INBOX]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: arg[0]: 'INBOX'
Feb 14 14:10:02 mail dbmail/imap4d[28123]: IMAPClientHandler(): Executing
command getacl...
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_findmailbox: looking for
mailbox with FQN [INBOX].
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='1166']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT dbmail_users.userid FROM dbmail_users, dbmail_acl WHERE
dbmail_acl.mailbox_id = '1166' AND dbmail_users.user_idnr = dbmail_acl.user_id]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_get_identifier: adding
denis-frechette to identifier list
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT userid FROM dbmail_users WHERE user_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: authsql.c,auth_get_userid:
query_result = jacques-beaudoin
Feb 14 14:10:02 mail dbmail/imap4d[28123]: authsql.c,auth_get_userid: returning
jacques-beaudoin as returnid
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_acl: before looping
identifiers!
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_acl: acl_string size =
53
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='jacques-beaudoin']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring: i = 0.
char is l, str = l
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring: i = 1.
char is r, str = lr
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is lr
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring: i = 2.
char is s, str = lrs
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is lrs
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring: i = 3.
char is w, str = lrsw
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is lrsw
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring: i = 4.
char is i, str = lrswi
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is lrswi
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring: i = 5.
char is p, str = lrswip
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is lrswip
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring: i = 6.
char is c, str = lrswipc
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is lrswipc
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring: i = 7.
char is d, str = lrswipcd
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is lrswipcd
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [1166] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '1166']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring: i = 8.
char is a, str = lrswipcda
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is lrswipcda
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_acl: lrswipcda
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='denis-frechette']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
lookup_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring: i = 0.
char is l, str = l
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
read_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
read_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
seen_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
seen_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
write_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
write_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
insert_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
insert_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
post_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
post_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
create_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
create_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
delete_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
delete_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [649] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '649']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '649' AND mailbox_id = '1166' AND
administer_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='anyone']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: db.c,db_acl_has_right: checking ACL
for user [4690] on mailbox [1166]
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND
owner_idnr = '4690']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: dbmysql.c,db_query: executing query
[SELECT * FROM dbmail_acl WHERE user_id = '4690' AND mailbox_id = '1166' AND
administer_flag = '1']
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_rightsstring
rightsstring currently is l
Feb 14 14:10:02 mail dbmail/imap4d[28123]: acl.c,acl_get_acl: l
Feb 14 14:10:02 mail dbmail/imap4d[28123]: IMAPClientHandler(): Finished
command getacl
Feb 14 14:10:02 mail dbmail/imap4d[28123]: serverchild.c,PerformChildTask:
client handling complete, closing streams
Feb 14 14:10:02 mail dbmail/imap4d[28123]: serverchild.c,client_close: closing
write stream
Feb 14 14:10:02 mail dbmail/imap4d[28123]: serverchild.c,client_close: closing
read stream
Feb 14 14:10:02 mail dbmail/imap4d[28123]: serverchild.c,PerformChildTask:
connection closed
Feb 14 14:10:02 mail dbmail/imap4d[28123]: serverchild.c,PerformChildTask:
waiting for connection
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): line read for
PID 28135
Feb 14 14:10:02 mail dbmail/imap4d[28135]: COMMAND: [00000004 LOGOUT]
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): Executing
command logout...
Feb 14 14:10:02 mail dbmail/imap4d[28135]: _ic_logout(): user (id:1166) logging
out @ [2006-02-14 14:10:02]
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): Finished
command logout
Feb 14 14:10:02 mail dbmail/imap4d[28135]: IMAPClientHandler(): Closing
connection for client from IP [10.220.12.2]
Feb 14 14:10:02 mail dbmail/imap4d[28135]: serverchild.c,PerformChildTask:
client handling complete, closing streams
Feb 14 14:10:02 mail dbmail/imap4d[28135]: serverchild.c,client_close: closing
write stream
Feb 14 14:10:02 mail dbmail/imap4d[28135]: serverchild.c,client_close: closing
read stream
Feb 14 14:10:02 mail dbmail/imap4d[28135]: serverchild.c,PerformChildTask:
connection closed
Feb 14 14:10:02 mail dbmail/imap4d[28135]: serverchild.c,PerformChildTask:
waiting for connection
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): line read for
PID 28145
Feb 14 14:10:02 mail dbmail/imap4d[28145]: COMMAND: [00000004 LOGOUT]
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): Executing
command logout...
Feb 14 14:10:02 mail dbmail/imap4d[28145]: _ic_logout(): user (id:1166) logging
out @ [2006-02-14 14:10:02]
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): Finished
command logout
Feb 14 14:10:02 mail dbmail/imap4d[28145]: IMAPClientHandler(): Closing
connection for client from IP [10.220.12.2]
Feb 14 14:10:02 mail dbmail/imap4d[28145]: serverchild.c,PerformChildTask:
client handling complete, closing streams
Feb 14 14:10:02 mail dbmail/imap4d[28145]: serverchild.c,client_close: closing
write stream
Feb 14 14:10:02 mail dbmail/imap4d[28145]: serverchild.c,client_close: closing
read stream
Feb 14 14:10:02 mail dbmail/imap4d[28145]: serverchild.c,PerformChildTask:
connection closed
Feb 14 14:10:02 mail dbmail/imap4d[28145]: serverchild.c,PerformChildTask:
waiting for connection
====== END OF TRANSACTION AND THE LAST "l" FLAG IS NOT TAKEN OUT =======
====== AND jacques-beaudoin/INBOX is always share with denis-frechette ======
