Roundcube Community Forum

 

RC does not handle message caching consistently

Started by grpprod, December 26, 2012, 06:21:12 AM

Previous topic - Next topic

grpprod

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)


SKaero

It can happen after a update, its best to clear the cache tables when doing an upgrade.

grpprod

Sorry, I thought it was obvious I already did that. In fact, I do this frequently now, but this still happens after some time.

alec

This is most likely fixed in git-master with the new DB layer. We do not bother to fix this for MDB2 package.

grpprod

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.

JohnDoh

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.
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and more...