Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - recover quarantined messages
  FAQ FAQ  Forum Search   Register Register  Login Login

recover quarantined messages

 Post Reply Post Reply
Author
Derk View Drop Down
Groupie
Groupie


Joined: 26 January 2005
Location: United States
Status: Offline
Points: 39
Post Options Post Options   Thanks (0) Thanks(0)   Quote Derk Quote  Post ReplyReply Direct Link To This Post Topic: recover quarantined messages
    Posted: 07 March 2005 at 3:14pm

if I go through the potential spam list, deliver a few messages and delete the rest what would the appropriate query be to display the deleted/quarantined messages?  I guess the scenario would be if I'm trying to recover a message I previously thought was spam?

 

 

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

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 07 March 2005 at 5:06pm
Derk,

When an email is force-delivered, it is then tagged to be deleted. SpamFilter will run a cleanup query that deletes all such "tagged" emails every hour (unless you changed this setting). Once they are deleted, the only way to recover lost data from a database is from a backup...
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
Derk View Drop Down
Groupie
Groupie


Joined: 26 January 2005
Location: United States
Status: Offline
Points: 39
Post Options Post Options   Thanks (0) Thanks(0)   Quote Derk Quote  Post ReplyReply Direct Link To This Post Posted: 08 March 2005 at 1:54pm
would there be any particular reason I couldn't make the cleanup query a few days rather than 60 minutes?  Would they be a significant performance decrease?
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 08 March 2005 at 4:22pm
It would depend on your database server. Deleting records (emails) after days rather than hours will increase your database size.  Running a SQL command to erase 30 times the number of emails than you'd otherwise have if removing them hourly will demand much more CPU. If your DB server has disk space and CPU to spare, then it should not be a problem.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
Derk View Drop Down
Groupie
Groupie


Joined: 26 January 2005
Location: United States
Status: Offline
Points: 39
Post Options Post Options   Thanks (0) Thanks(0)   Quote Derk Quote  Post ReplyReply Direct Link To This Post Posted: 27 April 2005 at 12:41pm

I have changed the expire interval to 2880 minutes (48 hours).  My question is does this schedule a purge every 48 hours or more frequently and purges messages that are over 48 hours old?

for example scenario #1: if the last purge was Monday at 4 p.m. I could feasibly recover a message up to Wednesday at 4 p.m.

scenario #2: continuing from scenario #1; on Thursday morning will I be able to recover a message from Tuesday or would it have been purged on Wednesday at 4 p.m.?

 

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

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 27 April 2005 at 4:09pm
When SpamFilter is started a timer is also started. From then on, every NN minutes the purge procedure is invoked. NN is the value under "Enter the interval in minutes for when the expired emails are deleted from the quarantien database". In turn, when it runs, the purge procedure will delete any emails whose date is less than or equal to (Now - DD). Now is the time at which the purge is executed, DD is the value under "Enter the number of days to store quarantined rejected emails.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
Derk View Drop Down
Groupie
Groupie


Joined: 26 January 2005
Location: United States
Status: Offline
Points: 39
Post Options Post Options   Thanks (0) Thanks(0)   Quote Derk Quote  Post ReplyReply Direct Link To This Post Posted: 27 April 2005 at 6:24pm
sounds like I need to create my own scheduled task to purge the old messages.  You don't happen to have handy the basic equivalent SQL query I could run to accomplish the task?
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 27 April 2005 at 10:37pm
For flexibility we split it in two pieces:

UPDATE tblQuarantine SET Expire = 1 WHERE MsgDate <= :MsgDate:

DELETE tblMsgs FROM tblMsgs INNER JOIN tblQuarantine
    ON tblMsgs.MsgID = tblQuarantine.MsgID
    WHERE tblQuarantine.Expire <> 0

SpamFilter has a more complex query to take in consideration the existance of multiple instances of SpamFilter storing data in the same database, but the above should be fine when run from the SQL server itself.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.094 seconds.