Mark/Ruth/The List, Thanks for the prompt responses. Before I try to figure out a way to correct this... is the "character_set_database" the only thing I should be looking at?
I also looked at the hyperkitty_email table, since that isreferenced in a lot of errors. That shows some collations are set to latin1_swedish_ci, and others are NULL.
If there suggestions about how to correct this on the databaseserver, I'm all ears. I'm definitely a little concerned about making such a big change now that we are moving a lot of messages/lists thru this instance.
Thanks for all your help.- Matt Alberti
MariaDB [mailmandb]> SHOW FULL COLUMNS FROM hyperkitty_email; +-----------------+--------------+-------------------+------+-----+--------- +----------------+---------------------------------+---------+ | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment | +-----------------+--------------+-------------------+------+-----+--------- +----------------+---------------------------------+---------+ | id | int(11) | NULL | NO | PRI | NULL | auto_increment | select,insert,update,references | | | message_id | varchar(255) | latin1_swedish_ci | NO | MUL | NULL | | select,insert,update,references | | | message_id_hash | varchar(255) | latin1_swedish_ci | NO | MUL | NULL | | select,insert,update,references | | | subject | varchar(512) | latin1_swedish_ci | NO | MUL | NULL | | select,insert,update,references | | | content | longtext | latin1_swedish_ci | NO | | NULL | | select,insert,update,references | | | date | datetime(6) | NULL | NO | MUL | NULL | | select,insert,update,references | | | timezone | smallint(6) | NULL | NO | | NULL | | select,insert,update,references | | | in_reply_to | varchar(255) | latin1_swedish_ci | YES | MUL | NULL | | select,insert,update,references | | | archived_date | datetime(6) | NULL | NO | MUL | NULL | | select,insert,update,references | | | thread_depth | int(11) | NULL | NO | | NULL | | select,insert,update,references | | | thread_order | int(11) | NULL | YES | MUL | NULL | | select,insert,update,references | | | mailinglist_id | int(11) | NULL | NO | MUL | NULL | | select,insert,update,references | | | parent_id | int(11) | NULL | YES | MUL | NULL | | select,insert,update,references | | | sender_id | varchar(255) | latin1_swedish_ci | NO | MUL | NULL | | select,insert,update,references | | | thread_id | int(11) | NULL | NO | MUL | NULL | | select,insert,update,references | | | sender_name | varchar(255) | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | | +-----------------+--------------+-------------------+------+-----+--------- +----------------+---------------------------------+---------+ 16 rows in set (0.001 sec)
MariaDB [mailmandb]>
-----Original Message----- From: Mark Sapiro <mark@msapiro.net> Sent: Tuesday, December 8, 2020 2:55 PM To: mailman-users@mailman3.org Subject: [MM3-users] Re: Hyperkitty Recommended mySQL Database Setup & Archive Importing
On 12/8/20 9:05 AM, matthew@alberti.us wrote:
From what I've been reading, it seems like Mailman3expects the mysql database to use UTF8 encoding. It appears, by default, that when using the docker-mailman containers, that the character set is set to latin1. This may explain why there are lots of import errors, and maybe also why there are a lot of errors when threads
are deleted in hyperkitty's UI.
Is it the case that UTF8 is the preferred character set?I also saw some threads indicating that maybe utf8mb4 is more preferred. I'd like to try to change the character_set on the database, if that is advisable.
You want the MySQL encoding for the Mailman database to be utf8mb4. If not, as Ruth says, you will have issues with 4-bute utf-8 encodings. See <https://gitlab.com/mailman/mailman-suite/-/blob/master/mailman-suite_projec t/settings.py#L156>
Also, is Hyperkitty 1.3.4 officially released? I seethat the list.org instance is using it, but the latest announce I've seen is for 1.3.3.
No, it is not. lists.mailman3.org and mail.python.org both run the HEADs of the GitLab branches so they are generally ahead of the latest releases.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/