Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - V3.1.3.615 on Linux/MySQL "update tblquarantine.."
  FAQ FAQ  Forum Search   Register Register  Login Login

V3.1.3.615 on Linux/MySQL "update tblquarantine.."

 Post Reply Post Reply
Author
Markus View Drop Down
Newbie
Newbie
Avatar

Joined: 06 March 2010
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Markus Quote  Post ReplyReply Direct Link To This Post Topic: V3.1.3.615 on Linux/MySQL "update tblquarantine.."
    Posted: 06 March 2010 at 4:24pm
Sorry for a Question about a old version of SpamFilter.
When I changed from Windows to Linux, there was a Error in the Activity Log telling me that a table does not exist:

Exception occurred during TDeleteExpiredQuarantineThread.Execute: [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-community]Table 'spamdb.tblquarantine' doesn't exist

ODBC Logging showed me that SQL statements normally come with upper and lower case mixed. Example:

SELECT tblQuarantine.QuarID, tblQuarantine.EmailTo, tblQuarantine.EmailFrom, tblQuarantine.Deliver, tblQuarantine.Expire, tblMsgs.MsgID, tblMsgs.Msg FROM tblQuarantine INNER JOIN tblMsgs ON tblQuarantine.MsgID = tblMsgs.MsgID WHERE Deliver <> 0 AND Expire = 0 AND ( (ServerID = 1) OR (ServerID = 0) OR (ServerID IS NULL) );

Only one SQL statement that does the cleanup at the quarantine table is all in lower case:

update tblquarantine set expire = 1 where msgdate <= _latin1'2010-02-04' and ( (serverid = 1) or (serverid = 0) or (serverid is null) );;

When I open the SpamFilter Application in a HEX Editor, I can find this SQL statement perfectely right:

UPDATE tblQuarantine SET Expire = 1 WHERE MsgDate <= :MsgDate AND ( (ServerID = ...

Somewhere in the code, the whole SQL statement gets converted to lowercase?

What can I do to make the quarantine cleanup work?
(Do I have to install a stored procedure instead to do the job or can you fix it that the "
UPDATE tblQuarantine SET Expire..." SQL statement doesen't get converted into lower case?)Cry


Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 06 March 2010 at 10:53pm
Markus,

The version of SpamFilter you're running is very old :-) That was a known issue and was solved a long time ago starting with SpamFilter v3.5.3.657. The partial release notes for that build are as follows:

// New to VersionNumber = '3.5.3.657';
{TODO -cFix : SpamFilter could send duplicate emails when executing the process that runs every 60 minutes that reprocesses emails in the queue, as it could re-send emails that were being delivered at that exact moment}
{TODO -cNew : Added support for AUTH PLAIN in addition to AUTH LOGIN}
{TODO -cFix : Solved issues with the quarantine grid display that prevented the quarantine list form being displayed with MS Access and Access Violations with MySQL }
{TODO -cNew : Added "ScanAllHeaders" option in SpamFilter.ini file to also scan all headers for keywords}
{TODO -cFix : Emails with multiple recipients on multiple domains - if different domains have different destination SMTP servers, the email is split and delivered to each server correctly}
{TODO -cFix : Converted all queries in lowercase to fix issues with Unix-based MySQL databases}
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
Markus View Drop Down
Newbie
Newbie
Avatar

Joined: 06 March 2010
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Markus Quote  Post ReplyReply Direct Link To This Post Posted: 12 March 2010 at 10:13am
Hi Roberto
Many thanks for your fast reply. So - if there is no workaround I have to install the new version.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.078 seconds.