Re: [SOGo] sogo_admin table in 5.10
Hi, I've had the same question/problem. But regarding the comment from Quentin I set my MySQL collation systemwide to utf8mb4 and put the following limes into /etc/sogo/sogo.conf: > OCSAdminURL = "mysql://sogo:PASSWORD@127.0.0.1:3306/sogo/sogo_admin"; > MySQL4Encoding = "utf8mb4"; I also edited /etc/mysql/mysql.conf.d/mysql.cnf and .../mysql.cnf an put these lines in: > https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_database_configuration > (last block before chapter 5.12). Then I have restarted MySQL and afterwards SOGo and found sogo.sogo_admin in the database! Best Regards Max Am 22. Feb. 2024, 10:59 +0100 schrieb Albert Shih : > Le 21/02/2024 à 16:54:01+0100, qhivert a écrit > Hi, > > > > > You’re quick, I haven’t even made the full release yet > > Yes the table will be created by sogo itself, no need to do it manually. > > If you use another collation than utf8mb4 (for example utf8mb4_unicode_ci) > > you > > may have to change it manually, though. > > > > I just upgrade to 5.10 and no table sogo_admin tables. > > I check inside > > /usr/share/doc/sogo/ > > and don't see any > > sql-update-5.9.0_to_5.10.* > > regards. > > JAS > -- > Albert SHIH 嶺 > France > Heure locale/Local time: > jeu. 22 févr. 2024 10:35:05 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
RE: [SOGo] sogo_admin table in 5.10
Hi, I've tried to get rid of the message about missing OCSAdminURL today and set the value in this way: > // Hack um Fehlermeldung "OCSAdminUrl not set" zu unterdruecken > OCSAdminURL = "mysql://sogo:PASSWORD@127.0.0.1:3306/sogo/sogo_user_profile"; Reason is I've found no db-description for the table 'sogo_admin' :( Quentin wrote: > If you use another collation than utf8mb4 (for example utf8mb4_unicode_ci) > you may have to change it manually, though. Now I took a look in my MySQL database. There is no possibility to set 'pure' utf8mb4 collation. I can only use utf8mb4_XXX encodings, like unicode_ci, german2 etc. And the table sogo_admin was not created by the first start after the update ... (nightly built from today). Best Regards Max Am 21. Feb. 2024, 16:55 +0100 schrieb qhivert : > Hello > You’re quick, I haven’t even made the full release yet > Yes the table will be created by sogo itself, no need to do it manually. > If you use another collation than utf8mb4 (for example utf8mb4_unicode_ci) > you may have to change it manually, though. > > Quentin > > From: users-requ...@sogo.nu On Behalf Of Pavel > Zheltobryukhov > Sent: mercredi 21 février 2024 15:34 > To: users@sogo.nu > Subject: [SOGo] sogo_admin table in 5.10 > > Hi to all, it's nice to hear what ver. 5.10 was released recently. Some new > parameters was introduced - OCSAdminURL and SOGoSuperUsernames . > In OCSAdminURL we need to set up a 'sogo_admin' table. Before start upgrade, > I did a SQL query about tables in sogo db > $ psql -U vmailadmin -d sogo > psql (12.17 (Ubuntu 12.17-0ubuntu0.20.04.1)) > Type "help" for help. > > sogo=> \dt > List of relations > Schema | Name | Type | Owner > ++---+--- > public | sogo_acl | table | sogo > public | sogo_alarms_folder | table | sogo > public | sogo_cache_folder | table | sogo > public | sogo_folder_info | table | sogo > public | sogo_quick_appointment | table | sogo > public | sogo_quick_contact | table | sogo > public | sogo_sessions_folder | table | sogo > public | sogo_store | table | sogo > public | sogo_user_profile | table | sogo > (9 rows) > > sogo=> > There is no 'sogo_admin' at this moment in 5.9.1 (nightly January build) . > Does this table will be created during upgrade process, or I should create it > before/after upgrade? > > WBR, Pavel Zhe
[SOGo] Problems syncinc SOGo with fritz!box
Hi @all I'm using SOGo as a service for calendar and addresscards in the web. Syncing the cards and calendar items via exchange to iPhone or card/cal-DAV to evolution works without problems. But when I try to sync the addressbook to my fritz!box router there are cards missing ich there is a german special charakter (ä, ö, ü or ß) in the name. So I've tried to create the card directly on the frit!box and sync it to the SOGo service. This works and the card is created in the SOGo addressbook. But after the next sync from sogo to the fritz!box the card in the fritz!box is going to be deleted. Is there a solution for this problem? Best regards and a happy new year! Max
