Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Inheriting blacklists question
  FAQ FAQ  Forum Search   Register Register  Login Login

Inheriting blacklists question

 Post Reply Post Reply
Author
WebGuyz View Drop Down
Senior Member
Senior Member


Joined: 09 May 2005
Location: United States
Status: Offline
Points: 348
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebGuyz Quote  Post ReplyReply Direct Link To This Post Topic: Inheriting blacklists question
    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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
yapadu View Drop Down
Senior Member
Senior Member


Joined: 12 May 2005
Status: Offline
Points: 272
Post Options Post Options   Thanks (0) Thanks(0)   Quote yapadu Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
WebGuyz View Drop Down
Senior Member
Senior Member


Joined: 09 May 2005
Location: United States
Status: Offline
Points: 348
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebGuyz Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebGuyz View Drop Down
Senior Member
Senior Member


Joined: 09 May 2005
Location: United States
Status: Offline
Points: 348
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebGuyz Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
WebGuyz View Drop Down
Senior Member
Senior Member


Joined: 09 May 2005
Location: United States
Status: Offline
Points: 348
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebGuyz Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.062 seconds.