[horde] IMP IMAP DB Cache backend lifetime

[Jan Schneider]

Zitat von Joao S Veiga <jsveiga at rf.com.br>:

> ----- Message from Jan Schneider <jan at horde.org> ---------
>
>>> 1 - horde-clear-cache does not clear the IMP IMAP DB cache tables  
>>> (horde_imap_client_data, horde_imap_client_metadata,  
>>> horde_imap_client_message). Is there a script for clearing these  
>>> tables, or doing it via sql is the only way?
>>
>> imp-query-imap-cache
>>
>>> 2 - the Db.php backend  
>>> (framework/Imap_Client/lib/Horde/Imap/Client/Cache/Backend/Db.php)  
>>> does have a clear($lifetime) function, but I couldn't find where  
>>> is it called. Who is supposed to call that?
>>
>> See above.
>>
>>> 3 - it seems there's a missing ")" in that function at the DELETE  
>>> statement (line 320 at  
>>> https://github.com/horde/horde/blob/master/framework/Imap_Client/lib/Horde/Imap/Client/Cache/Backend/Db.php):
>>>
>>> $purge = time() - $lifetime;
>>> $sql = 'DELETE FROM %s WHERE messageid IN (SELECT messageid FROM  
>>> %s WHERE modified < ?';
>>> foreach (array(self::MD_TABLE, self::MSG_TABLE) as $val) {
>>>
>>> I've searched for an sql error in the logs and couldn't find one  
>>> for this statement, so maybe it's never called?
>>
>> Indeed, fixed for the next release.
>>
>> It's only called when using the --lifetime parameter with  
>> imp-query-imap-cache.
>>
>
>
> Thank you Jan,
>
> So if I understood correctly, the imap cache old entries are only  
> cleaned manually with the imp-query-imap-cache script, so there is  
> no automatic "expiring" like for the horde cache files?
>
> Thanks again,
>
> Joao

I don't think so.

-- 
Jan Schneider
The Horde Project
https://www.horde.org/