On 04/11/05, Exim User <[EMAIL PROTECTED]> 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'[EMAIL PROTECTED]>
> temporarily rejected RCPT <[EMAIL PROTECTED]>: 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 ' [EMAIL PROTECTED]'
> 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: [EMAIL PROTECTED]
Tel: +44 1296 768003
VoIP: sip:[EMAIL PROTECTED]
--
## List details at http://www.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://www.exim.org/eximwiki/
