Author: Michael da Silva Pereira Date: To: exim-users Subject: [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')