Re: [exim] Mysql Logging problems

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Peter Bowyer
Ημερομηνία:  
Προς: Exim Mailing List
Αντικείμενο: Re: [exim] Mysql Logging problems
On 09/06/05, Michael da Silva Pereira <michael@???> wrote:
> Hi,
>
> I am getting this sort of message in my log:
>
> Jun 9 06:47:41 spamstop exim[23515]: 2005-06-09 06:47:41 1DgEx7-00067H-Ie
> H=gfiservers.gfi.com (S44374) [69.20.55.130] Warning: ACL "warn" statement
> skipped: condition test deferred: 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 's Access exploit vulnerability
> test','emailtesting@???','te\n
>
> It looks like that message has a ' in the subject line, and obviously mysql
> is not going to like this. Here is my config file:
>
> LOG_FIRST = INSERT INTO message_log
> (msgid,mail_subject,mail_from,mail_to,mail_host,mail_ctime,mail_size)
> values('$message_id'
> ,'$h_subject:','$sender_address','$recipients','$sender_host_address',$tod_e
> poch,'$message_size')
>
> How can I get exim to sort this problem out?


Look for $quote_mysql in the docs.

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@???