Yep. That's me working on bug #125. Looks like your getting corruptions
where my tests pass without errors.
I'll track this down asap.
Oleg Lapshin wrote:
> Igor Olemskoi wrote:
>
>>dbmail-dev rev 2013 doesn't work, it writes "permission denied" when I
>>trying to see messages list in any folder using squirrelmail or
>>Thenderbird.
>
>
> It seems, that db_acl_has_right (in db.c) doesn't get mailbox->owner_idnr
>
> LOG:
>
> COMMAND: [11 SELECT "INBOX/dbmail/my"]
> arg[0]: 'INBOX/dbmail/my'
> imap4.c,IMAPClientHandler: Executing command select...
> db.c,db_findmailbox: looking for mailbox with FQN [INBOX/dbmail/my].
> dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM
> dbmail_mailboxes
> WHERE name='INBOX/dbmail/my' AND owner_idnr='2']
> db.c,db_acl_has_right: checking ACL [read_flag] for user [2] on mailbox [61]
> LOE: mailbox->owner_idnr=578811027262036368 userid=2
> ^^^^^^^^^^^^^^
> dbmysql.c,db_query: executing query [SELECT * FROM dbmail_acl WHERE user_id =
> '2' AND mailbox_id = '61' AND read_flag = '1']
> dbmysql.c,db_query: executing query [SELECT user_idnr FROM dbmail_users WHERE
> lower(userid) = lower('anyone')]
> db.c,db_acl_has_right: checking ACL [read_flag] for user [4] on mailbox [61]
> LOE: mailbox->owner_idnr=578811027262036368 userid=4
> ^^^^^^^^^^^^^^
> dbmysql.c,db_query: executing query [SELECT * FROM dbmail_acl WHERE user_id =
> '4' AND mailbox_id = '61' AND read_flag = '1']
> RESPONSE: [11 NO permission denied
> ]
> imap4.c,IMAPClientHandler: Finished command select [1]
>
>
> And smth wrong with dbmysql.c,db_query:
>
> db.c,db_acl_has_right: checking ACL [read_flag] for user [2] on mailbox [56]
> LOE: mailbox->owner_idnr=0 userid=2
> dbmysql.c,db_query: executing query [SELECT owner_idnr FROM dbmail_mailboxes
> WHERE mailbox_idnr = '56']
> LOE: result=21474836481
> ^^^^^^^^^
>
> ( I includeed some trace(TRACE_DEBUG,....); statements)
>
>
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
