Piler works great, but only archives some of the incoming emails. The following message can be found in /var/log/mail.log frequently:
#!shell mysql_stmt_execute error: *Incorrect string value: '\xAD57 Di...' for column 'body' at row 1* (errno: 1366)
I think it's some kind of related to UTF-8 charset but I don't even know where to begin.
There are similar errors in
#471 and #571, but both issues are almost one year old and I wonder if someone has even tested piler with MySQL 5.7
My System: Ubuntu 16.04.1 LTS, all updates installed mysqld Ver 5.7.13-0ubuntu0.16.04.2 for Linux on x86_64 ((Ubuntu)) Apache/2.4.18 (Ubuntu) PHP 7.0.8-0ubuntu0.16.04.2 (cli) ( NTS )
Piler version: Build Date: Thu Aug 4 14:39:06 UTC 2016 ldd version: ldd (Ubuntu GLIBC 2.23-0ubuntu3) 2.23 gcc version: gcc version 5.4.0 20160609 (Ubuntu 5.4.0-6ubuntu1~16.04.1) Configure command: ./configure --localstatedir=/var --with-database=mysql --enable-starttls --enable-tcpwrappers
The MTA is Zimbra 8.6