Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Quarantine not deleting old emails
  FAQ FAQ  Forum Search   Register Register  Login Login

Quarantine not deleting old emails

 Post Reply Post Reply
Author
lyndonje View Drop Down
Senior Member
Senior Member
Avatar

Joined: 31 January 2006
Location: United Kingdom
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote lyndonje Quote  Post ReplyReply Direct Link To This Post Topic: Quarantine not deleting old emails
    Posted: 22 February 2006 at 9:24am
Running v.2.7.1.523 and have noticed there are emails in my quarantine from 10th February onwards.

Under the Quarantine DB settings, SF is set to store rejected emails for 1 day, and then delete them 60 minutes after they expire.

Any ideas?
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 22 February 2006 at 4:26pm
From your logs we see several entries like the following:

02/12/06 06:42:18:305 -- (756) Exception occurred during TDeleteExpiredQuarantineThread.Execute: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented

From the error there seems to be a problem with the ODBC provider for SQL you're using, possibly because it is a very old version. Another possibility is if you're using MSSQL 2005, and again the ODBC driver was not updated.
 
Can you please make sure you're using the newer OLE DB drivers rather than the older ODBC ones? The simplest way to proceed is to use a UDL file (Microsoft's Universal DataLink) to define the connection to SQL server. In the SpamFilter\database directory you'll find several .UDL files for each database platform. Please double-click on the one for SQL Server, SpamFilterMSSQL.udl. The correct OLE DB Provider (not using ODBC) should already be selected in the "Provider" tab. In the connection tab, simply enter the name of your SQL server, and the username/password for the SpamFilter database. Click on "Allow saving password" to store the password in the udl file, then select the SpamFilter database. Click on "Test Connection" to ensure the UDL file works.
 
Now in SpamFilter, under the "Settings - Quarantine DB" tab, click on the "..." ellipse button to select a Connection String. In the box that follows, select "Use Data Link File" and select the SpamFilterMSSQL.udl you customized before.
 
Please let us know if that helps any.
 
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
lyndonje View Drop Down
Senior Member
Senior Member
Avatar

Joined: 31 January 2006
Location: United Kingdom
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote lyndonje Quote  Post ReplyReply Direct Link To This Post Posted: 23 February 2006 at 3:56am
OK, done that. I'll see how it goes. Should spam filter automatically clean the quarantine?
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 23 February 2006 at 7:32am
Yes, it may take longer than usual as there are probably lots of old messages to delete, but it should be handled automatically as soon as the error disappears.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
lyndonje View Drop Down
Senior Member
Senior Member
Avatar

Joined: 31 January 2006
Location: United Kingdom
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote lyndonje Quote  Post ReplyReply Direct Link To This Post Posted: 23 February 2006 at 10:36am
Just checked the quarantine and it has deleted the expired emails. Thanks.
Back to Top
Analytical View Drop Down
Newbie
Newbie
Avatar

Joined: 28 February 2006
Location: United States
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Analytical Quote  Post ReplyReply Direct Link To This Post Posted: 28 February 2006 at 4:40pm

We had a problems with our MySql database also -- we also updated the ODBC drivers and added a solution of our own brew see the post Our MySQL database diet

 

His and yours,

Dwight
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.209 seconds.