[exim] Mysql Logging problems

Kezdőlap
Üzenet törlése
Válasz az üzenetre
Szerző: Michael da Silva Pereira
Dátum:  
Címzett: exim-users
Tárgy: [exim] Mysql Logging problems
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?

Thanks,
Michael