Print Page | Close Window

Inheriting blacklists 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=6860
Printed Date: 18 December 2017 at 2:13am


Topic: Inheriting blacklists question
Posted By: WebGuyz
Subject: Inheriting blacklists question
Date Posted: 04 August 2010 at 11:28am
I have a qustion on how best to proceed with this option. I have SFE with about 500  domains with custom settings and about 3000 bl keywords for each domain. I'm currently updating all the domains bl_keywords sql entries for every domain every time I add a new blacklisted keyword (2-3 a day).
 
I assume that once I enable the feature you recently added I will be able to remove all those redundant bl_keyords as wel as things like MAPS and SURBL servers.
 
I assume the first thing I would do is a sql command to enable that option for each and every domain to turn that feature on. Could you tell me the table and which field that was added to support this feature?
 
Thanks!
Andy
 
 
 


-------------
http://www.webguyz.net



Replies:
Posted By: LogSat
Date Posted: 04 August 2010 at 8:20pm
Andy,

The new settings are located in the tbl_FilterSettings. The field name used to trigger the keyword inheritance is bl_KeywordsUseDefaults. If you set this to "True" (or 1) for a domain that is configured for customized settings, this will cause the bl_keywords for that domain to be inherited from the default "ALL DOMAINS" settings.
For MAPS and SURBL the fields are bl_mapsusedefaults and bl_surblusedefaults. You can easily see the other entries by scanning thru the various columns in that table.


-------------
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: yapadu
Date Posted: 04 August 2010 at 8:35pm
Andy,

One thing you want to watch out is if you enable this, it will use the settings of all domains but you then can't add any custom ones.

So if you have domain A that uses all the defaults and domain B uses all the defaults, you can't have domain B have additional keywords.

I am doing the same as you, replicating all the keywords to all domains.  I thought when this feature came out I would be able to add custom keywords specific to a single domain and have that domain then inherit the additional keywords from the all domains but it does not work that way.  It is all domains settings or custom, but not mixed Disapprove


-------------
--------------------------------------------------------------
I am a user of SF, not an employee. Use any advice offered at your own risk.


Posted By: WebGuyz
Date Posted: 04 August 2010 at 8:54pm
As long as I can keep adding sql entries to the All Domain bl_keywords its not a problem. I figure that 99% of spam is the same for everybody, that few that actually might have a problem with words like 'breasts' (we have a few plastic surgeons :-) I can just add those entries to their individual wl_keywords. Just trying to cut down on the ever growing bl_keywords database.
 
Thanks!


-------------
http://www.webguyz.net


Posted By: WebGuyz
Date Posted: 04 August 2010 at 8:58pm
Originally posted by LogSat LogSat wrote:

Andy,

The new settings are located in the tbl_FilterSettings. The field name used to trigger the keyword inheritance is bl_KeywordsUseDefaults. If you set this to "True" (or 1) for a domain that is configured for customized settings, this will cause the bl_keywords for that domain to be inherited from the default "ALL DOMAINS" settings.
For MAPS and SURBL the fields are bl_mapsusedefaults and bl_surblusedefaults. You can easily see the other entries by scanning thru the various columns in that table.
 
This isn't a one time deal, right? If I keep making upates to the All Domain bl_keywords table it will propagate to all the domains? Is this correct?
 
Its the only thing that makes sense but gotta do due diligence and ask  :-)


-------------
http://www.webguyz.net


Posted By: LogSat
Date Posted: 04 August 2010 at 10:06pm
Yeap... we had a few bugs with the triggers that implemented this (propagating all the settings to the domains that inherited them), but it looks like with the last build (834) we got it right. 834 will probably be released as our next "official" version this weekend.

-------------
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: WebGuyz
Date Posted: 04 August 2010 at 10:36pm
Roberto,
 
   When you say propagate do you mean it just creates the bl_keywords text file  for each domain using the table from the ALL Domains as a template, or are you saying it creates SQL table entries for every domain using the bl_keywords from ALL Domains as the model?
 
I assume it would just create the text file that SFE just imports when it detects a change and not mess with SQL, correct?
 
 
Thanks!


-------------
http://www.webguyz.net


Posted By: LogSat
Date Posted: 05 August 2010 at 9:44pm
That is correct - only the text file is modified. Any "prior" keywords that you had defined for that domain will remain in the database however (for that domain), so that if you ever decide to uncheck the inheritance for that blacklist, your previous entries will still be there.

-------------
Roberto Franceschetti

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

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



Print Page | Close Window