Re: [exim] How to filter single quotes out of rcpt-headers?

Startseite
Nachricht löschen
Nachricht beantworten
Autor: Peter Bowyer
Datum:  
To: exim users
Betreff: 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


${quote_mysql

http://www.exim.org/exim-html-4.50/doc/html/spec_9.html#SECT9.8

Peter



--
Peter Bowyer
Email: peter@???
Tel: +44 1296 768003
VoIP: sip:peter@???