From: Chris Richards (gizmogiz-works.com)
Date: Mon Mar 31 2008 - 01:04:41 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Dennis Duggen wrote:
> Hi Wietse Venema
>
>>> | $ egrep 'warning|error|fatal|panic' /var/log/maillog
>> And you really did not notice these warning messages.
>> Mar 30 19:41:49 tanja postfix/cleanup[6121]: warning: mysql query
>> failed: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
>> (utf8_general_ci,COERCIBLE) for operation '='
> Yes i did. But ignored these since some tries to send to
> Wadstr?mwebspeed.dk with supposedly a danish special char. But there
> are many more non special char mails, which produces errors.
>
> Fx. when i am sending a mail through Thunderbird i sometimes get the
> same error, and my mailaddress has no special chars.
>
> I will look into the mysql error but i can't se that this i related to
> the other errors.
>
> Dennis

While it is not obviously related, I submit that it IS in fact related;
I was having similar issues and when I changed my SQL query, they went
away. Specifically, my query used to look something like this:

query = "SELECT destination FROM `virtual-aliases` WHERE email='%s'"

Now, it looks like this:

query = "SELECT destination FROM `virtual-aliases` WHERE
email=CONVERT('%s' USING latin1)"

If you are using the older form, where you have:

table = tablename
select_field = fieldname
where_field = wherefieldname

and you are running PostFix 2.2 or later, I HIGHLY recommend using the
query= syntax, as the other is deprecated (to my understanding), and the
query= syntax is much more powerful anyway (as you can see).

Later,
Chris

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]