---------- Forwarded message ---------- From: CISSE Amadou cisse.amadou.9@gmail.com Date: Mon, Apr 16, 2012 at 2:33 PM Subject: Re: [RCU] message_cache and shared folders possible bug To: Jeroen van Meeuwen vanmeeuwen@kolabsys.com
Just to be in sync, user B is the mailbox owner and has shared it readonly with user A.
On Sun, Apr 15, 2012 at 3:23 PM, Jeroen van Meeuwen <vanmeeuwen@kolabsys.com
wrote:
On Sunday, April 15, 2012 02:18:58 PM CISSE Amadou wrote:
Hi,
I have massage_cache turned on. I created and account and shared its mailbox readonly with some other users. When logged-in as one of those users, i try to delete messages in the mailbox without success, nice.
However when i login as the mailbox owner, roundcube displays no
messages.
turn off message_cache and roundcube displays the messages.
Just curious;
- when user A deletes messages, does user A delete only some of the
messages, or all of the messages?
All of the messages. When user A deleted the messages, the following error message popped up.
Connection to storage server failed.
The imap logs shows Permission denied in the logs:
[16-Apr-2012 14:03:02 +0000]: [1515] C: A0009 UID STORE 1:* +FLAGS.SILENT (\Deleted) [16-Apr-2012 14:03:02 +0000]: [1515] S: A0009 NO Permission denied
sql log when user A deleted the messages:
[16-Apr-2012 14:07:43 +0000]: query(1): SELECT vars, ip, changed FROM session WHERE sess_id = '3jjb6ffvhpgh3bv7dit9huut97'; [16-Apr-2012 14:07:43 +0000]: query(1): SELECT * FROM users WHERE user_id = '7'; [16-Apr-2012 14:07:43 +0000]: query(1): SELECT vars, ip, changed FROM session WHERE sess_id = '3jjb6ffvhpgh3bv7dit9huut97'; [16-Apr-2012 14:07:43 +0000]: query(1): SELECT * FROM users WHERE user_id = '7'; [16-Apr-2012 14:07:43 +0000]: query(1): SELECT data, valid FROM cache_index WHERE user_id = '7' AND mailbox = 'Bo&AO4-tes partag&AOk-es/notifications'; [16-Apr-2012 14:07:43 +0000]: query(1): SELECT data, valid FROM cache_index WHERE user_id = '7' AND mailbox = 'Bo&AO4-tes partag&AOk-es/notifications'; [16-Apr-2012 14:07:43 +0000]: query(1): UPDATE cache_index SET data = 'O:18:"rcube_result_index":5:{s:11:"', valid = 1, changed = now() WHERE user_id = '7' AND mailbox = 'Bo&AO4-tes partag&AOk-es/notifications'; [16-Apr-2012 14:07:43 +0000]: query(1): SELECT uid, data, flags FROM cache_messages WHERE user_id = '7' AND mailbox = 'Bo&AO4-tes partag&AOk-es/notifications' AND uid IN (116,115,114,113,112,111,110,109,108,107,106,105,104,103,102,101,100,99,98,97,96,95,94,93,92,91,90,89,88,87,86,85);
- when user B is displayed no messages, what is the message? Mailbox is
empty, "No messages in selected mailbox"?
No error messages, just an empty maillbox in the roundcube. here's the sql log when i refresh the page:
[16-Apr-2012 14:09:26 +0000]: query(1): SELECT vars, ip, changed FROM session WHERE sess_id = 'q3vjgc77vsl7vk98ri607n7iv3'; [16-Apr-2012 14:09:26 +0000]: query(1): SELECT * FROM users WHERE user_id = '10'; [16-Apr-2012 14:09:26 +0000]: query(1): SELECT data, valid FROM cache_index WHERE user_id = '10' AND mailbox = 'INBOX';
and the imap log:
[16-Apr-2012 14:12:24 +0000]: [F8E9] C: A0004 SELECT INBOX [16-Apr-2012 14:12:24 +0000]: [F8E9] S: * FLAGS (\Answered \Flagged \Draft \Deleted \Seen) [16-Apr-2012 14:12:24 +0000]: [F8E9] S: * OK [PERMANENTFLAGS (\Answered \Flagged \Draft \Deleted \Seen *)] [16-Apr-2012 14:12:24 +0000]: [F8E9] S: * 32 EXISTS [16-Apr-2012 14:12:24 +0000]: [F8E9] S: * 0 RECENT
In fact roundcube shows that there are 32 messages in the inbox but when i click on inbox no messages displayed, see image screenshots attached.
I have roundcube check for messages every minute, so the interface goes back to inbox.png every minute.
What do the (debug) logs say about this (imap, most prominently?). I reckon
of particular interest would also be the SQL log as it contains any query statements that might disclose what's going on, if you are able to configure SQL caching and reproduce this.
Kind regards,
Jeroen van Meeuwen
-- Systems Architect, Kolab Systems AG
e: vanmeeuwen at kolabsys.com m: +44 74 2516 3817 w: http://www.kolabsys.com
pgp: 9342 BF08
I disabled message_cache and roundcube displays the messages normally.
Cheers.
