On Mon, Jan 24, 2011 at 10:17:25AM +0100, Claudio Prono wrote:
> On a postfix server i have some strange things in logs files, and i
> don't know what's happening.
>
> Jan 22 23:54:07 mail postfix/trivial-rewrite[10285]: warning: mysql
> query failed: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
> (utf8_unicode_ci,COERCIBLE) for operation '='
> Jan 22 23:54:07 mail postfix/trivial-rewrite[10285]: warning:
> transport_maps lookup failure
The SQL client and server have to agree on the character encoding. In your
case data from the Postfix SQL client is in a different encoding than data
stored in the database.
SMTP specifies ASCII as the encoding of envelope commands and addresses,
there is no way to determine whether non-conformant addresses sent by
some client are intended to be UTF-8, ISO8859-1, or any other encoding.
What MySQL makes of such data is up to the MySQL client and server libraries,
but Postfix does not promise that the input will be well-formed UTF-8, or
ISO Latin or anything of the sort. Just an array of bytes.
> Jan 22 23:54:07 mail postfix/smtpd[10267]: NOQUEUE: reject: RCPT from
> hostxx.xx-static.xx.xxx-b.business.telecomitalia.it[xxx.xx.x.xx]: 451
> 4.3.0 <Rodr guez1...@4mortgagehelp.xxx>: Temporary lookup failure;
> from=<Rodr?guez1...@4mortgagehelp.xxx> to=<u...@domain.it> proto=ESMTP
> helo=<mail.domain.it>
>
> Notice the character "?" into the from, can be this the problem?
The "?" in the logs, replaced a non-ASCII character transmitted on the wire.
--
Viktor.
