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.
--
--------------------------------------------------------------------------------
Claudio Prono OPST
System Developer
Gsm: +39-349-54.33.258
@PSS Srl Tel: +39-011-32.72.100
Via San Bernardino, 17 Fax: +39-011-32.46.497
10141 Torino - ITALY http://atpss.net/disclaimer
--------------------------------------------------------------------------------
PGP Key - http://keys.atpss.net/c_prono.asc
