Re: Weird DB character set issue (fixed)

I found that the column charset was set as utf8mb3, probably a mariadb
default.

Here is the relevant snippet from the db creation script. (Seems it should
be updated)

[image: maia_mail_table_create.png]


Joe



On Thu, Sep 11, 2025 at 1:18 PM Janky Jay, III <[email protected]> wrote:

> Hi Joe,
>
> On 9/11/25 02:10PM, jjs - mainphrame wrote:
>
>
> 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
>
>
> Are you not pulling code from
> https://github.com/einheit/maia_mailguard_1.04a ? This should already be
> the default SQL setup (this is a VERY old issue that has been fixed for
> years.)
>
> Regards,
> Janky Jay, III
>
> _______________________________________________
> Maia-users mailing list
> [email protected]
> http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
>

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