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)


-- 
Oleg Lapshin

Reply via email to