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
