C/R is not necessary... it could even flag an email update the subject with something like "Not a Customer" or "Possible Spam". Or, even forward it to another email address.
For myself, I use spambytes for Outlook and it works about 95% of the time. But for the powers above me.. does not use Outlook (and won't move to Outlook or any other email client) and wants something down at the server end without the need for the user (himself) to mess with. The mail server we use has spamassassin built in. If I could figure out how to configuration the local.cf to read the SQL table, I could possibly work. I have been playing with this for the last hour. The problem we have is that most built in spam filters won't work for us. If you happen to look at the domain of my email address (NSFW), quite a few emails will be rejected. -----Original Message----- From: Kurt Buff [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2008 11:02 AM To: NT System Admin Issues Subject: Re: challenge/response SQL based white list On Wed, Aug 6, 2008 at 9:40 AM, Jacob <[EMAIL PROTECTED]> wrote: > We are looking at different solution for spam protection. OK > What we are looking for a solution that can challenge/response an incoming > email based on a white list that is SQL database based. Don't do it. For the love of all things sacred - spare your users and their correspondents the pain and aggravation. C/R systems should all be called Hoover - they all suck badly. > Anybody have any suggestions they have uses/tried for white list > centralization? Yes - don't do it. Get something that the users can manage themselves, like Maia Mailguard, or ASSP, or something like that. You can have whitelists in those, and blacklists (which are much less useful than you might think), but either of those are infinitely superior to a C/R system, and are much better for all concerned. Also, don't use catchall addresses, and make sure that your system refuses mail for invalid recipients. Lastly, if you can, publish SPF records in DNS. Kurt ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~ ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
