Spam Filter ISP Forums : Release Mail via Database https://www.logsat.com/spamfilter/forums/ Wed, 17 Jun 2026 06:38:37 +0000 Mon, 08 Sep 2014 20:27:59 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=7098 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[Release Mail via Database : Thank you very much!Deliver =...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=7098&PID=14656&title=release-mail-via-database#14656 Author: insitec
Subject: 7098
Posted: 08 September 2014 at 8:27pm

Thank you very much!

Deliver = 1 in tblQuarantine was exactly the missing piece of my puzzle!

Much appreciated,

Andy.
]]> Mon, 08 Sep 2014 20:27:59 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=7098&PID=14656&title=release-mail-via-database#14656 <![CDATA[Release Mail via Database : Hi Andy,You can run the following...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=7098&PID=14655&title=release-mail-via-database#14655 Author: LogSat
Subject: 7098
Posted: 08 September 2014 at 9:02am

Hi Andy,

You can run the following directly against the database:

UPDATE    tblQuarantine
SET              Deliver = 1
WHERE     EmailFrom = 'some_user@some_domain.com'

replacing the sample email address above with the actual sender's email address.

Note that after sending all the emails quarantined having that email address as the sender, SpamFilter will then add entries to its internal whitelist matching that sender with any recipients for which that email was blocked. This causes any future emails from that specific sender to any of those recipients to be automatically whitelisted from that point on.

If you want to see what emails will be delivered by that query before actually delivering them, you can run this query instead:

SELECT * FROM tblQuarantine WHERE  EmailFrom='some_user@some_domain.com'
]]> Mon, 08 Sep 2014 09:02:59 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=7098&PID=14655&title=release-mail-via-database#14655 <![CDATA[Release Mail via Database : Hi folks,I just had a request...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=7098&PID=14654&title=release-mail-via-database#14654 Author: insitec
Subject: 7098
Posted: 08 September 2014 at 12:43am

Hi folks,

I just had a request to release any and all mail from a particular address, irrespective of to whom it was addressed.

Anyone ever done that - or anything similar - before? I'm guessing I could change a flag in the database, after selecting all the emails from that address... but I'm really not sure.

Any help greatly appreciated.

Cheers,
Andy
]]> Mon, 08 Sep 2014 00:43:59 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=7098&PID=14654&title=release-mail-via-database#14654