Re: [SOGo] all calendars and entries vanished from web interface

[Daniel Kollmer]

Hello Quentin




Greetings;

On 06-03-2025 17:13, qhivert (qhiv...@alinto.eu) wrote:

Thanks for the detailed step-by-step plan. I will try that during a planned maintenance window where I can safely do this without users changing stuff in their calendars.

Hello,

Yes, you can but do a backup of your database first as it's a heavy operation.

Step 1:
Stop sogo, remove/comment OCSStoreURL, OCSCacheFolderURL and OCSAclURL from 
your sogo.conf to be as before.

Step 2:
Backup all users
sogo-tool backup /tmp/backup ALL
Inside /tmp/backup will be a lot of files named after your users, each one 
being their corresponding backup.

Step 3:
Add the new parameters to your sogo.conf
OCSCacheFolderURL = "mysql://<db_url>/sogo/sogo_cache_folder";
OCSStoreURL = "mysql://<db_url>/sogo/sogo_store";
OCSAclURL = "mysql://<db_url>/sogo/sogo_acl";

Step 4:
Restore all your users. Sadly, the sogo-tool restore command can only restore 
one user at a time
sogo-tool restore -F ALL /tmp/backup USER
You could use a bash script
#!/bin/bash
backup_path="/tmp/backup/"
size=${#backup_path}
for filename in ${backup_path}*; do
   echo ${filename:$size}
   sogo-tool restore -F ALL $backup_path ${filename:$size}
done

Step 5:
restart sogo.

Note that I've never done it before so be careful (and do a database backup 
first).

Step 6:
You can clean all the older tables if you want. They are named:
sogo + first 8 characters of the user + 11 random number.


Regards,
Quentin

-----Original Message-----
From: users-requ...@sogo.nu <users-requ...@sogo.nu> On Behalf Of Daniel Kollmer
Sent: jeudi 6 mars 2025 16:59
To: users@sogo.nu
Subject: Re: [SOGo] all calendars and entries vanished from web interface

Hello again

It turned out that this happened because I also enabled the OCSStoreURL feature 
and then the calendar contents can not be found anymore.

I would be interested now to know whether there is a good way to do enable this 
feature and retain calendar events and subscriptions.

Greetings

Daniel

On 06-03-2025 16:23, Daniel Kollmer (dani...@nikhef.nl) wrote:

Hello all

I have done an update of SoGo from the nightly build (I run version
5.11.2) and then I ran the sql-update-5.8.4_to_5.9.0.sh script (maybe
that was the big mistake) for the database which is running on mariadb.

Since then no user can see any prior created events or calendar
subscriptions. New events can be added and also the events in
externally synced calendars are visible (like in thunderbird)

New sharing also makes shared calendars appear again for users but
without prior events.

I hope someone has a good tip, because this is actually being used
heavily by an institution involving hundreds of people.

Thanks in advance;

--
Daniel Kollmer
Computer Technology Group
NIKHEF - Dutch National Institute for Sub-atomic Physics Science Park 105 1098 
XG Amsterdam
Phone: +31646812164

--
Daniel Kollmer
Computer Technology Group
NIKHEF - Dutch National Institute for Sub-atomic Physics
Science Park 105 1098 XG Amsterdam

OpenPGP_signature.asc
Description: OpenPGP digital signature