Thanks Mark. Also, just to confirm, should the database connection string also be updated? In both the core and web configuration, I have something like:
DATABASE_URL=mysql+pymysql://mailman:password@database/mailmandb
Note the trailing UTF-8 encoding stuff isn't there. Should we be specifying utf8mb4 there as well?
I'm planning to test this in a dev environment. If I can somewhat confirm the fix procedure won't break an existing install (like I have), I'll submit a PR(s) to the docker-mailman github.
- Matt Alberti
-----Original Message----- From: Mark Sapiro <mark@msapiro.net> Sent: Wednesday, December 9, 2020 1:29 PM To: mailman-users@mailman3.org Subject: [MM3-users] Re: Hyperkitty Recommended mySQL Database Setup & Archive Importing
On 12/8/20 1:02 PM, matthew@alberti.us wrote:
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?
You need to set
'OPTIONS': {'charset': 'utf8mb4'}
in the DATABASES['default'] definition in your django settings. I'm not sure if this overrides the various collation, etc. settings in the DB or not, but it wouldn't hurt to update the DB.
-- 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/