mysql error in amavis

[Dino Edwards]

Anyone have any insight on this?

From: amavis-users [mailto:amavis-users-bounces+dino.edwards=mydirectmail.net at amavis.org] On Behalf Of Dino Edwards
Sent: Tuesday, April 9, 2019 2:44 PM
To: amavis-users at amavis.org
Subject: mysql error in amavis

I've noticed the following errors on certain messages in mail.log:

amavis[4270]: (04270-02) (!)WARN save_info_final: sql exec: err=1366, HY000, DBD::mysql::st execute failed: Incorrect string value: '\\xF0\\x9F\\x8E\\x89' for column 'subject' at row 1 at (eval 100) line 172

After looking in the msgs table, I found a bunch of messages that have an empty subject as well as other empty fields. These are obviously the messages that amavis was not able to store in the MySQL database because of the above error.

As far as I can tell, these are most likely messages with special characters in the subject line (emojis etc) that amavis is not able to store in the database.

After some research, I have gathered that I most likely need to enable  4-Byte support in MySQL.

I have a couple of questions:


1.       Has anyone ran into a similar problem and what have they done to solve it

2.       Would enabling 4-Byte support in MySQL affect amavis in any way?


Thanks in advance





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.amavis.org/pipermail/amavis-users/attachments/20190416/33e22abb/attachment.html>