Title: BTS activities for Thursday, February 22 2024
BTS Activities
Home page: https://bugs.sogo.nu
Project: SOGo
For the period covering: Thursday, February 22 2024
idlast updatestatus (resolution)categorysummary
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
Le 22/02/2024 à 10:38:28+0100, Albert Shih a écrit
> 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
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
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 |
>
Hi,
Have you set the param OCSAdminURLin your sogo.conf? If not, it's normal the
table is not created.
If yes, sogo will create it when starting/restrating
Quentin
-Original Message-
From: users-requ...@sogo.nu On Behalf Of Albert Shih
Sent: jeudi 22 février 2024 10:38
To: qhivert
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:
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
Hello
Careful you probably put in your OCSAdminUrl the same as value as SOGoProfileURL
Yours should look like this
OCSAdminURL = "mysql://sogo:PASSWORD@127.0.0.1:3306/sogo/sogo_admin";
For the collation, SOGo should create the correct value. For example, mines are
utf8mb4_0900_ai_ci
For