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 <users@sogo.nu>: > 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