Re: Missing Calendar and Contacts entries

Thanks for update and provided sql.
I managed to repair the database.
For clearing cache I'm using now the command intended for doing so.

But after I repaired the database I have still problem with contacts of 
one of my users.
When kolab_cache is enabled contacts can't be seen in roundcube and 
mobile as well.
When I disable kolab_cache contacts is loaded in roundcube.
I can't figure out what is causing problem.
Other users contacts are ok.

Thanks for any ideas.

Thomas


On 7/16/19 8:41 PM, Mihai Badici wrote:
> I can't provide an official dump but I made a dump of my running setup
> using roundcube 1.3.4. just for you.
>
> It will fix at least the "expires" errors but i think is pretty up-to-date.
>
> http://mihai.badici.ro/linux/machinet/debian/roundcube-1.3.4.sql
>
>
> Unfortunately I was busy last years with different projects so I
> neglected kolab but I'm still follow the product.
>
> On 7/16/19 9:15 PM, Thomas wrote:
>> Thanks, I didn't know that.
>> And I didn't search the docs.
>> I searched only google and not explecetly for clearing cache, but for
>> the problem with not showing contacts and found only the old solution
>> I mentioned.
>>
>> Could you please advise me how to repair/recreate roundcube database
>> table structure.
>> Because I found out that by using the old kolab.sql script i broke
>> roundcube database and I have now a lot of errors.
>> Mainly about missing column 'expires' in 'cache' table. But there
>> could be more problems.
>>
>> Thanks in advance.
>>
>> Thomas
>>
>>
>> On 7/16/19 7:43 PM, Daniel Hoffend wrote:
>>> 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
>> _______________________________________________
>> 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