Print Page | Close Window

Release Mail via Database

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=7098
Printed Date: 20 September 2024 at 8:57pm


Topic: Release Mail via Database
Posted By: insitec
Subject: Release Mail via Database
Date 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


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


-------------
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: insitec
Date 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.


Print Page | Close Window