---------- 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.
On 17.04.2012 13:21, CISSE Amadou wrote:
I disabled message_cache and roundcube displays the messages normally.
Exactly which Roundcube version are you using? Did you try with 0.7.2?
On Tue, Apr 17, 2012 at 11:56 AM, A.L.E.C alec@alec.pl wrote:
On 17.04.2012 13:21, CISSE Amadou wrote:
I disabled message_cache and roundcube displays the messages normally.
Exactly which Roundcube version are you using? Did you try with 0.7.2?
I only tested this with latest svn.
-- Aleksander 'A.L.E.C' Machniak LAN Management System Developer [http://lms.org.pl] Roundcube Webmail Developer [http://roundcube.net]
PGP: 19359DC1 @@ GG: 2275252 @@ WWW: http://alec.pl _______________________________________________ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
On 17.04.2012 13:21, CISSE Amadou wrote:
Just to be in sync, user B is the mailbox owner and has shared it readonly with user A. All of the messages. When user A deleted the messages, the following error message popped up.
Connection to storage server failed.
[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
"Connection failed" is not something I expect on permission error.
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
This is incomplete, didn't you remove something in this line? Also "Bo&AO4-tes partag&AOk-es/notifications" != "INBOX". This is not the log on the same folder.
No error messages, just an empty maillbox in the roundcube. here's the sql log when i refresh the page:
Are you using any plugins? Disable them.
On Tue, Apr 17, 2012 at 12:05 PM, A.L.E.C alec@alec.pl wrote:
On 17.04.2012 13:21, CISSE Amadou wrote:
Just to be in sync, user B is the mailbox owner and has shared it
readonly
with user A. All of the messages. When user A deleted the messages, the following
error
message popped up.
Connection to storage server failed.
[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
"Connection failed" is not something I expect on permission error.
well, that was it. I'll get u a screenshot later.
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
This is incomplete, didn't you remove something in this line? Also "Bo&AO4-tes partag&AOk-es/notifications" != "INBOX". This is not the log on the same folder.
Bo&AO4-tes partag&AOk-es/notifications is french for SharedFolders/notifications and this how it appears to user A. But to the owning user B, it appears as INBOX.
No error messages, just an empty maillbox in the roundcube. here's the
sql
log when i refresh the page:
Are you using any plugins? Disable them.
sure, some of the defaults that come with and sieverules, quickrules, automatic_addressbook. I'll disable them and try again later at which point I'll also send the complete log files.
Cheers.
--
Aleksander 'A.L.E.C' Machniak LAN Management System Developer [http://lms.org.pl] Roundcube Webmail Developer [http://roundcube.net]
PGP: 19359DC1 @@ GG: 2275252 @@ WWW: http://alec.pl _______________________________________________ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
-
A.L.E.C -
CISSE Amadou