1 Topic by timcons

  • timcons
  • Member
  • Offline
  • Registered: 2017-12-19
  • Posts: 9

Topic: amavisd error message

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- Linux/BSD distribution name and version: Ubuntu 16.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

In the daily logwatch report, I see this error message in the Amavisd-new section :

<code>
**Unmatched Entries**
        1   message repeated 3 times: [ (03255-04) (!)WARN save_info_final: sql exec: err=1366, HY000, DBD::mysql::st execute failed: Incorrect string value: '\\xF0\\x9F\\x91\\x80' for column 'subject' at row 1 at (eval 99) line 172.]
</code>

On other days this message can be repeated.

How do I diagnose this ?  I am not sure what file it is referring to.

Thank you

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: amavisd error message

This message is safe to ignore. We have a fix in next iRedMail release with MySQL commands below (please run as mysql root user):

USE amavisd
ALTER TABLE msgs MODIFY COLUMN subject VARBINARY(255) DEFAULT '';
ALTER TABLE msgs MODIFY COLUMN from_addr VARBINARY(255) DEFAULT '';