Hello
Am 28.02.24 um 23:29 schrieb "Rouven Seifert" (rouven.seif...@ifsr.de):
Sogo has two modes for database. The current one, with only 11 tables The legacy one with several tables per user Both are ok and once a mode has been chosen, you can’t switch between them. If you’re setting up a new sogo server, we encourage to use the new mode (by setting OCSStoreURL, OCSAclURL and OCSCacheFolderURL).I was reading this and wondering if this recommendation is actually documented somewhere? The current installation guide (found at [0]) still seems to recommend the old scheme per default and just references the 3 new options alongside others in that one big table.
Documentation can always get improved.
Another question: We currently run our SOGo instance in legacy mode. What would happen if we would set the three options (OCSStoreURL, OCSAclURL and OCSCacheFolderURL) now? The Docs mention no breaking behaviour at this point.
Your setup will break!!!
The only way in order to change the database mode is by creating a new one.
1) Stop reverse proxy and SOGo
sudo apache2ctl graceful-stop
sudo systemctl stop sogo
2) Backup all Data from the old one with:
sudo /usr/sbin/sogo-tool backup /Path/To/Backup ALL
3) Drop old database and create new one
4) Change settings in /etc/sogo/sogo.conf for the Mode you want to use.
5) Start SOGo, this will create tables
sudo systemctl start sogo
6) Restore all Data
for RESTORE_USER in $(ls /Path/To/Backup)
do
sudo /usr/sbin/sogo-tool restore -f ALL /Path/To/Backup ${RESTORE_USER}
sudo /usr/sbin/sogo-tool restore -p -c /etc/sogo/sieve.creds
/Path/To/Backup ${RESTORE_USER}
done 7) Start reverse proxy sudo apache2ctl start Hints: * Not sure, 5) is still necessary, but it doesn't hurt either.* We had problems with shared privileges. We fixed that by running the restore with -p again
Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung, Lehre, Infrastruktur 78457 Konstanz +49 7531 88-4416
smime.p7s
Description: Kryptografische S/MIME-Signatur
