Re: [Exim] Problem with non ASCII caracters

<-- Warning: charset 'X-UNKNOWN' is not supported -->

See below.

On Fri, 28 Dec 2001, Torsten Mueller wrote:

> Philip Hazel schrieb:
> >
> > On Mon, 24 Dec 2001, Torsten Mueller wrote:
> >
> > > but:
> > > mail to inf?@??? goes to the spoolfile

[.. .. ..]

Aha, here might be the nitty gritty of it:

> MYSQL query: SELECT DISTINCT domain FROM mail WHERE domain
> LIKE 'bloopark.de' AND username LIKE 'inf?' AND
> is_alias='no'
> MYSQL using cached connection for
> localhost/popaccounts/xxxxxxxx/xxxxxxxxxx
> lookup yielded: bloopark.de


Your MYSLQ is doing a query in the "mail" table, WHERE

domain LIKE 'bloopark.de'
and
username LIKE 'inf?'

and that query is SUCCEEDING!, which results in exim accepting mail for
that address (and delivering it as configured)

**

Apparently either

You actually have an entry in that table with that username,

-- If this is the case find the offending row and delete it

-OR-

your MYSQL's 'LIKE' comparison considers those characters to match

-- If this is the case, you might want to consider using a more definate
comparison than 'LIKE' (such as 'EQUALS' or = or ==, whatever the right
syntax is)


Either that, or instead of selecting only the domain, select also the
username and use that instead of the input local_part when delivering,
at least that way the mail will be deivered to the file as described in
the db table, rather than the non-ascii one.