Re: [SOGo] How many table
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
Re: [SOGo] How many table
Hi there, > > 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. 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. Best regards, Rouven -- Rouven Seifert Co-Admin im Fachschaftsrat Informatik der TU Dresden https://ifsr.de [0] https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_database_configuration
Re: [SOGo] How many table
Le 22/02/2024 à 11:45:14+0100, qhivert a écrit Hi, > > 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. Ok thanks for the answer, just another question, what's the best way to clean up the databases when some user leave definitely > > If you’re setting up a new sogo server, we encourage to use the new mode (by > setting OCSStoreURL, OCSAclURL and OCSCacheFolderURL). No our server are very old Regards. JAS -- Albert SHIH 嶺 Observatoire de Paris France Heure locale/Local time: mer. 28 févr. 2024 17:49:11 CET
RE: [SOGo] How many table
Hello, 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). Quentin From: users-requ...@sogo.nu On Behalf Of Max Malycha Sent: jeudi 22 février 2024 11:33 To: users@sogo.nu Subject: Re: [SOGo] How many table Hi, my (MySQL-)Database holds only 11 tables: mysql> use sogo Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; ++ | Tables_in_sogo | ++ | sogo_acl | | sogo_admin | | sogo_alarms_folder | | sogo_cache_folder | | sogo_folder_info | | sogo_quick_appointment | | sogo_quick_contact | | sogo_sessions_folder | | sogo_store | | sogo_user_profile | | users | ++ 11 rows in set (0,00 sec) I'm not sure, but perhaps the count of rows you name is the whole db? The number of rows in my example means the count of rows in the answer to my statement! Best Regards Max Am 22. Feb. 2024, 10:59 +0100 schrieb Albert Shih mailto:users@sogo.nu> >: Hi, How many tables do you have in your postgresql ? Because I got (26908 rows) It seem I got 12 tables for each users. Everything seem to work well, and maybe it's just because it's old installation, but I just want to ask. Regards -- Albert SHIH 嶺 France Heure locale/Local time: jeu. 22 févr. 2024 10:39:33 CET
Re: [SOGo] How many table
Hi, my (MySQL-)Database holds only 11 tables: > mysql> use sogo > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Database changed > mysql> show tables; > ++ > | Tables_in_sogo | > ++ > | sogo_acl | > | sogo_admin | > | sogo_alarms_folder | > | sogo_cache_folder | > | sogo_folder_info | > | sogo_quick_appointment | > | sogo_quick_contact | > | sogo_sessions_folder | > | sogo_store | > | sogo_user_profile | > | users | > ++ > 11 rows in set (0,00 sec) I'm not sure, but perhaps the count of rows you name is the whole db? The number of rows in my example means the count of rows in the answer to my statement! Best Regards Max Am 22. Feb. 2024, 10:59 +0100 schrieb Albert Shih : > Hi, > > How many tables do you have in your postgresql ? > > Because I got > > (26908 rows) > > It seem I got 12 tables for each users. > > Everything seem to work well, and maybe it's just because it's old > installation, but I just want to ask. > > Regards > -- > Albert SHIH 嶺 > France > Heure locale/Local time: > jeu. 22 févr. 2024 10:39:33 CET