Inheriting blacklists question |
Post Reply 
|
| Author | |
WebGuyz 
Senior Member 
Joined: 09 May 2005 Location: United States Status: Offline Points: 348 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Inheriting blacklists questionPosted: 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
|
|
 |
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
yapadu
Senior Member
Joined: 12 May 2005 Status: Offline Points: 297 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
WebGuyz
Senior Member
Joined: 09 May 2005 Location: United States Status: Offline Points: 348 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
WebGuyz
Senior Member
Joined: 09 May 2005 Location: United States Status: Offline Points: 348 |
Post Options
Thanks(0)
Quote Reply
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
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
WebGuyz
Senior Member
Joined: 09 May 2005 Location: United States Status: Offline Points: 348 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Topic Options
LogSat wrote:|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.133 seconds.