Re: Weird DB character set issue (fixed)

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