Weird DB character set issue (fixed)

Today I saw that there were a few messages stuck in the queue on the maiad
server. The corresponding log entries for the rejected messages looked like
this:

2025-09-11T12:25:03.794144-07:00 zapad postfix/lmtp[17732]: B249681CB0:
to=<raskolnikov-IDHCfG2tVhIaUiLqDj/[email protected]
com>, relay=127.0.0.1[127.0.0.1]:10024, delay=4756, delays=4755/0/0/1.2,
dsn=4.5.0, status=deferred (host
127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=15150-02,
spam_scan FAILED: DBD::mysql::st
execute failed: Incorrect string value: '\\xF0\\x9F\\x97\\xB3\\xEF\\xB8...'
for column `maia`.`maia_mail`.
`subject` at row 1 at /var/lib/maia/maiad line 3841, <GEN22> line 1930. (in
reply to end of DATA command))

After some research, I concluded the following adjustment was needed in the
maia db:

MariaDB [maia]> alter table maia_mail
-> modify column subject varchar(255)
-> character set utf8mb4 COLLATE utf8mb4_unicode_ci;

After doing so, the 5 messages were processed and delivered.
All of them had a subject line that began with a special graphic character

Hope this info is helpful to someone

Joe

_______________________________________________
Maia-users mailing list
[email protected]
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users