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: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6860
Printed Date: 27 December 2024 at 12:15pm
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  ------------- -------------------------------------------------------------- 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
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 |
LogSat wrote: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 |