Unfortunately I wasn’t able try the fix - when I got your message I had already purged sogo and recovered with a fresh install and a backup of the data using sogo-tool.
Rob Sent from my iPad > On Nov 27, 2023, at 4:03 PM, users@sogo.nu wrote: > > Dear Robert, > > The issue has been fixed and this is related to your table's collation : > https://bugs.sogo.nu/view.php?id=5902 > > Sebastien > > Le Samedi, Novembre 25, 2023 15:09 CET, "\"Robert A. Decker\"" > (dec...@robdecker.com) <users@sogo.nu> a écrit: > >> >> I suspect something is wrong with my database. I can no longer log into the >> sogo web interface. I tried uninstalling and reinstalling sogo. I'm on >> ubuntu 20. >> >> sogo-activesync/unknown,now 5.9.0.20231125-1 amd64 [installed] >> sogo/unknown,now 5.9.0.20231125-1 amd64 [installed] >> sope4.9-gdl1-mysql/unknown,now 4.9.r1664.20230927 amd64 [installed] >> sope4.9-libxmlsaxdriver/unknown,now 4.9.r1664.20230927 amd64 >> [installed,automatic] >> >> >> I have logging turned on and here's what I see: >> 2023-11-25 08:56:22.819 sogod[1087145:1087145] MySQL4 connection established >> 0x0x559c7becb050 >> 2023-11-25 08:56:22.819 sogod[1087145:1087145] ---------- -[MySQL4Channel >> openChannel]: <MySQL4Channel[0x0x559c7b6a2280] connection=0x0x559c7becb050> >> opens channel count[5] >> 2023-11-25 08:56:22.819 sogod[1087145:1087145] MySQL4 channel >> 0x0x559c7b6a2280 opened (connection=0x0x559c7becb050,sogo) >> 2023-11-25 08:56:22.819 sogod[1087145:1087145] >> <MySQL4Channel[0x0x559c7b6a2280] connection=0x0x559c7becb050> SQL: SELECT >> c_defaults FROM sogo_user_profile WHERE c_uid = 'dec...@robdecker.com'; >> 2023-11-25 08:56:22.820 sogod[1087145:1087145] >> <MySQL4Channel[0x0x559c7b6a2280] connection=0x0x559c7becb050> query has >> results, entering fetch-mode. >> 2023-11-25 08:56:22.820 sogod[1087145:1087145] EXCEPTION: <NSException: >> 0x559c7b6eb720> NAME:NSInvalidArgumentException >> REASON:NSDataMalloc(instance) does not recognize isJSONString INFO:(null) >> >> >> I ran the same select statement and got a json string. When I put it into a >> json pretty printer the json is valid. >> >> >> I think the encoding is correct: >> >> MariaDB [sogo]> SELECT character_set_name FROM information_schema.`COLUMNS` >> WHERE table_schema = "sogo" and table_name = "sogo_user_profile" and >> column_name = "c_defaults"; >> +--------------------+ >> | character_set_name | >> +--------------------+ >> | utf8mb4 | >> +--------------------+ >> 1 row in set (0.001 sec) >> >> MariaDB [sogo]> SHOW TABLE STATUS WHERE NAME LIKE 'sogo_user_profile'; >> +-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+----------------+---------+------------------+-----------+ >> | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length >> | Max_data_length | Index_length | Data_free | Auto_increment | Create_time >> | Update_time | Check_time | Collation | Checksum | Create_options | Comment >> | Max_index_length | Temporary | >> +-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+----------------+---------+------------------+-----------+ >> | sogo_user_profile | InnoDB | 10 | Dynamic | 2 | 8192 | 16384 | 0 | 0 | 0 | >> NULL | 2023-11-25 14:04:36 | NULL | NULL | utf8mb4_bin | NULL | | | 0 | N | >> +-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+----------------+---------+------------------+-----------+ >> 1 row in set (0.001 sec) >> >> >> MariaDB [sogo]> describe sogo_user_profile; >> +------------+--------------+------+-----+---------+-------+ >> | Field | Type | Null | Key | Default | Extra | >> +------------+--------------+------+-----+---------+-------+ >> | c_uid | varchar(255) | NO | PRI | NULL | | >> | c_defaults | mediumtext | YES | | NULL | | >> | c_settings | mediumtext | YES | | NULL | | >> +------------+--------------+------+-----+---------+-------+ >> 3 rows in set (0.001 sec) >> >> > > >