Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: grpprod on December 26, 2012, 06:21:12 AM

Title: RC does not handle message caching consistently
Post by: grpprod on December 26, 2012, 06:21:12 AM
Hi,
here are some of my recent RC logs. It seems there are some issues present. Any help would be nice. I use PHP 5.4.10.

It seems there is problem when caching is enabled. Please also note that DB was taken from a previous RC (0.3.1) and was upgraded using mysql.update.sql

Quote[26-Dec-2012 11:42:18 +0200]: DB Error: MDB2 Error: constraint violation Query: _execute: [Error message: Unable to execute statement] [Last executed query: INSERT INTO cache_messages (user_id, mailbox, uid, flags, changed, data) VALUES (?, ?, ?, ?, now(), ?)] [Native code: 1062] [Native message: Duplicate entry '254-INBOX-1243' for key 'PRIMARY']  in /opt/servers/apache/htdocs/roundcube/program/include/rcube_mdb2.php on line 727 (GET /?_task=mail&_action=preview&_uid=1243&_mbox=INBOX&_framed=1)

Title: Re: RC does not handle message caching consistently
Post by: SKaero on December 27, 2012, 12:12:27 AM
It can happen after a update, its best to clear the cache tables when doing an upgrade.
Title: Re: RC does not handle message caching consistently
Post by: grpprod on December 27, 2012, 03:38:21 AM
Sorry, I thought it was obvious I already did that. In fact, I do this frequently now, but this still happens after some time.
Title: Re: RC does not handle message caching consistently
Post by: alec on December 27, 2012, 05:09:13 AM
This is most likely fixed in git-master with the new DB layer. We do not bother to fix this for MDB2 package.
Title: Re: RC does not handle message caching consistently
Post by: grpprod on December 31, 2012, 10:47:07 AM
I have no problem with these errors. I just want to ask this: Could this errors mean that when cache is enabled security is compromised? In other words, is there a chance that one user reads other user's cached message under certain circumstances? This is my main concern.
Title: Re: RC does not handle message caching consistently
Post by: JohnDoh on December 31, 2012, 11:27:37 AM
QuoteCould this errors mean that when cache is enabled security is compromised?

entries in the cache are entered with the speicific user id so only that user can see them.

btw the cache only stores message headers, none of the message content.