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.