Autor: Peter Bowyer Fecha: A: exim users Asunto: Re: [exim] How to filter single quotes out of rcpt-headers?
On 04/11/05, Exim User <exim2@???> wrote: > Dear list,
>
> using Exim 4.5.1 with a MySQL-backend, I ran into a problem when the
> recipients-header contained a single quote.
>
> Single quote garbles my SQL-syntax for the recipients mailaddress-lookup in
> the database.
> Exim replies to the sender: "Temporary local problem - please try later",
> while the logfile shows:
>
> 2005-11-04 11:25:31 H=(***.***.**) [**.***.***.***] F=<foo'foo@???>
> temporarily rejected RCPT <account@???>: MYSQL: query failed: You
> have an error in your SQL syntax. Check the manual that corresponds to your
> MySQL server version for the right syntax to use near ' foo@???' rlike
> sender' at line 1
