collation is normally a table property your mysql-tables charset should be uTF8
Am 24.01.2011 10:17, schrieb Claudio Prono: > Hello all, > > 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 > > This results in a Temporary lookup failure. > > A thing i have noticied when this happens is someone uses some strange > characters into the server greeting, i have this into the logs: > > 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? > > My //etc/postfix/mysql_virtual_domains_maps.cf is the following: > > user = postfix > password = xxxxxxxxxxxxxxx > hosts = 127.0.0.1 > dbname = postfix > table = domain > select_field = domain > where_field = domain > > What i can do to solve that problem? > > Cordially, > > Claudio Prono. > > -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/
signature.asc
Description: OpenPGP digital signature
