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: [email protected] <[email protected]> On Behalf Of Daniel Kollmer
Sent: jeudi 6 mars 2025 16:59
To: [email protected]
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 ([email protected]) 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
