Reindl Harald ha scritto:
> collation is normally a table property
> your mysql-tables charset should be uTF8
>
>
How i can check this?
> 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.
>>
>>
>>
>
>
> ------------------------------------------------------------------------
>
> !DSPAM:1,4d3d4b0f261161601616861!
--
--------------------------------------------------------------------------------
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
