Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Quarantine Release Question
  FAQ FAQ  Forum Search   Register Register  Login Login

Quarantine Release Question

 Post Reply Post Reply
Author
dotme View Drop Down
Newbie
Newbie


Joined: 27 October 2008
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote dotme Quote  Post ReplyReply Direct Link To This Post Topic: Quarantine Release Question
    Posted: 07 September 2011 at 10:03am
Maybe I coded something wrong?
 
1) Email sent to 3 users on same domain gets quarantined.
2) User 1 releases email and receives it
3) Users 2 and 3 can't release the message any more, because it's already been delivered to User 1.
 
Is that normal? Are there three copies quarantined when an email comes in for three people at example.com, or only one? Hints and tips appreciated...


Edited by dotme - 07 September 2011 at 10:03am
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: 07 September 2011 at 5:59pm
No - that is not normal. For every spam email that is quarantined, a record is added to the tblQuarantine table for each recipient of that email. The tblQuarantine holds simple header data relative to the email (ex. subject, to/from, etc). The actual content of the email is added to the tblMsgs. Only one record with the content is added in order to save space (since it's the same content for all recipients).

In your case, 3 records would thus be added to the tblQuarantine table, and just one record with the body of the email is added to the table tblMsgs. Each of the 3 records in the tblQuarantine then points to the same record in the tblMsgs table for the content. When a user release the email from the quarantine, after the delivery, their record in the tblQuarantine is marked for deletion. When SpamFilter performs its cleanup routines (by default every hour), it will delete that one record from the tblQuarantine. The remaining 2 records for the other users in the tblQuarantine, along with the email body in the tblMsgs, are not touched and should thus remain available for the other users to see (and deliver).

Are you certain you do not have some customized cleanup routines configured in SQL Server (or in an external application) that may be modifying the SpamFilter database directly, bypassing SpamFilter?
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
dotme View Drop Down
Newbie
Newbie


Joined: 27 October 2008
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote dotme Quote  Post ReplyReply Direct Link To This Post Posted: 08 September 2011 at 11:17am
Originally posted by LogSat LogSat wrote:

Are you certain you do not have some customized cleanup routines configured in SQL Server (or in an external application) that may be modifying the SpamFilter database directly, bypassing SpamFilter?
Guilty as charged... thanks for pointing me in the right direction. I found the problem in one of my overnight routines. Thanks again!!
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.078 seconds.