Quarantine Release Question |
Post Reply 
|
| Author | |
dotme 
Newbie 
Joined: 27 October 2008 Status: Offline Points: 20 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Quarantine Release QuestionPosted: 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 |
|
 |
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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?
|
|
|
|
|
dotme
Newbie
Joined: 27 October 2008 Status: Offline Points: 20 |
Post Options
Thanks(0)
Quote Reply
Posted: 08 September 2011 at 11:17am |
Guilty as charged... thanks for pointing me in the right direction. I found the problem in one of my overnight routines. Thanks again!!
|
|
|
|
Topic Options
LogSat wrote:|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.079 seconds.