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