Print Page | Close Window

Quarantine Release Question

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6977
Printed Date: 17 December 2017 at 8:28pm


Topic: Quarantine Release Question
Posted By: dotme
Subject: Quarantine Release Question
Date 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...



Replies:
Posted By: LogSat
Date 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

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP


Posted By: dotme
Date 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!!



Print Page | Close Window