Re: Missing Calendar and Contacts entries

Sure there's a command line utitity

root@mx01:/usr/share/roundcubemail# plugins/libkolab/bin/modcache.sh 
clear -a
37 records deleted from 'kolab_folders'

You can even do this for domains or single users. Or do this only for 
specific cache types.

--
Regards
Daniel



Am 2019-07-16 08:49, schrieb Thomas:
> Hi,
> 
> thanks for the info.
> I will try that in the evening.
> So if the template is old and not up to date, how to correct roundcube
> db to be up to date and delete cache?
> Is there bettere way to delete kolab cache?
> Why the kolab update did not delete cache?
> 
> Thanks.
> Thomas
> On 7/16/19 6:19 AM, Mihai Badici wrote:
> 
>> I wasn't aware this sql template is still used :)
>> 
>> Please notice that during the time there are some fields added to
>> sql tables, some of them where missing from the installer's
>> template. This template is pretty old so could be more fields
>> missing.
>> 
>> You can enable the sql debug in roundcube and syncroton to see if
>> there are more fields missing in mysql tables.  In roundcube source
>> there is a folder named SQL which contain the succesive updates to
>> mysql table structure, you can compare with  the erors in mysql log
>> 
>> in roundcube: $config['sql_debug'] = true;
>> 
>> On 7/15/19 9:53 PM, Thomas wrote:
>> 
>> Hi,
>> 
>> I had maybe same issue with contacts.
>> One user of 5 on my kolab installation reported me yesterday that
>> her contacts suddenly disappeared.
>> This users using only contact sync with her mobile phone (no mails,
>> no calendar).
>> 
>> The contacts was missing on her phone (synced using ActiveSync) and
>> also in Roundcube.
>> The contacts was still as files on disk in the imap spool.
>> 
>> I tried things around index, but no luck.
>> Now I found this about kolab cache.
>> https://lists.kolab.org/pipermail/users/2014-August/017704.html
>> 
>> I first tried to disable kolab cache in
>> /etc/roundcubemail/libkolab.inc.php
>> The change is active immediately (no restart of any service neede).
>> If then you can see your contacts, this means that kolab cache is
>> corrupted.
>> 
>> I then:
>> - enabled cache again
>> - backed up roundcube databse
>> _mysqldump -u roundcube -p roundcube > roundcube-backup.sql_
>> - delete cache from database using this sql:
>> http://mihai.badici.ro/linux/machinet/debian/kolab.sql
>> mysql -u roundcube -p roundcube < kolab.sql
>> 
>> Maybe it can help you.
>> 
>> I didn't find out why the cache was corrupted.
>> 
>> Thomas
>> 
>> On 7/11/19 5:30 AM, Eric B Munson wrote:
>> I have opened an issue on maniphest for this problem:
>> 
>> https://git.kolab.org/T5501
>> 
>> On 2019-07-10 17:02, Eric B Munson wrote:
>> Over night (with no kolab updates AFAICT) my calendar and contacts
>> entries have disappeared. The files are still on disk in the imap
>> spool but they are no longer being displayed in the roundcube
>> interface and they are missing from CardDAV/CalDAV.  Any hints on
>> how
>> to bring them back?
>> 
>> Thanks,
>> Eric
>> _______________________________________________
>> users mailing list
>> [email protected]
>> https://lists.kolab.org/mailman/listinfo/users
>> _______________________________________________
>> users mailing list
>> [email protected]
>> https://lists.kolab.org/mailman/listinfo/users
> 
> _______________________________________________
> users mailing list
> [email protected]
> https://lists.kolab.org/mailman/listinfo/users
> 
> _______________________________________________
> users mailing list
> [email protected]
> https://lists.kolab.org/mailman/listinfo/users
> _______________________________________________
> users mailing list
> [email protected]
> https://lists.kolab.org/mailman/listinfo/users