Lähettäjä: Peter Bowyer Päiväys: Vastaanottaja: Exim Mailing List Aihe: 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?
