Autor: Jeremy Harris Data: A: exim-users @ exim. org Assumpte: Re: [exim] How to filter single quotes out of rcpt-headers?
Exim User wrote:
> 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
