Re: [SOGo] sogo_admin table in 5.10
Not yet, but I planned to upgrade on next week. Thanks for the explanation. On Tue, Feb 27, 2024 at 12:12 PM smizr...@alinto.eu wrote: > Dear Pavel, > > This table is not mandatory and can be used to enabled the new "message of > the day" feature. > Did you add the settings "OCSAdminURL" on the configuration ? > > Sebastien > > Le Mercredi, Février 21, 2024 15:33 CET, "Pavel Zheltobryukhov" ( > pave...@gmail.com) a écrit: > > > 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 > > > >
Re: [SOGo] sogo_admin table in 5.10
Dear Pavel, This table is not mandatory and can be used to enabled the new "message of the day" feature. Did you add the settings "OCSAdminURL" on the configuration ? Sebastien Le Mercredi, Février 21, 2024 15:33 CET, "Pavel Zheltobryukhov" (pave...@gmail.com) a écrit: 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 sogopsql (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
Re: [SOGo] sogo_admin table in 5.10
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 (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.* Forget to say, I'm using postgresql. Regards -- Albert SHIH 嶺 France Heure locale/Local time: jeu. 22 févr. 2024 11:03:12 CET
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] sogo_admin table in 5.10
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 Subject: Re: [SOGo] sogo_admin table in 5.10 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] sogo_admin table in 5.10
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] sogo_admin table in 5.10
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 some users that use Unicode (for emoji) they would have to change that manually. As long as you don’t see any missing characters in your webmail, you have nothing to worry about. Quentin From: users-requ...@sogo.nu On Behalf Of Max Malycha Sent: mercredi 21 février 2024 18:11 To: users@sogo.nu Subject: 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 mailto: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 <mailto:users-requ...@sogo.nu> mailto:users-requ...@sogo.nu> > On Behalf Of Pavel Zheltobryukhov Sent: mercredi 21 février 2024 15:34 To: users@sogo.nu <mailto: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
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
RE: [SOGo] sogo_admin table in 5.10
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] 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