Print Page | Close Window

New to VersionNumber = '4.1.3.822';

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=6817
Printed Date: 24 November 2017 at 10:07am


Topic: New to VersionNumber = '4.1.3.822';
Posted By: yapadu
Subject: New to VersionNumber = '4.1.3.822';
Date Posted: 26 March 2010 at 3:29am
// New to VersionNumber = '4.1.3.822';
{TODO -cNew Added ability in SpamFilter Enterprise to have, for domains with customized settings, the ability to configure each blacklist/whitelist so that it inherits the default values for ALL DOMAINS}
{TODO -cFix Fixed issue that would cause SpamFilterto crash when scanning for viruses emails with specific malformed headers}

Oh, I like this inherits feature.  I was excited when spamfilter enterprise came out, but I thought having to define the 'same rules' for each domain to be silly.

I would like to clarify how this works.

I see the new checkboxes in the GUI, and I noticed the database changes as well.  If you elect to use the settings from ALL DOMAINS does it use the settings from ALL DOMAINS only, or does it inherit from ALL DOMAINS as the base and then add any custom filters on the specific domain level?



Replies:
Posted By: WebGuyz
Date Posted: 26 March 2010 at 11:53am
Thats a pretty big deal! Right now I have scripts to update all 400 domains whenever a BL keyword is added. Would be great to just update ALL DOMAINS.
 
Is this implemented as a trigger? Haven't downloaded it yet but it sounds like something we have been needing for a long time.
 
Thanks!


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


Posted By: yapadu
Date Posted: 26 March 2010 at 12:20pm
I agree it is a big deal, much like you we have developed a table external to spamfilter.  When we add a keyword it pushes the keyword into all domain configurations. 

If you have 20,000 domains and hundreds of keywords and lists of various types it really adds to the load time of spamfilter.  I don't have 20,000 domains :-( but still not very efficient.

Now wait, Roberto will say it just uses all domains and ignores any additional filter at the local level. 


Posted By: LogSat
Date Posted: 28 March 2010 at 12:52am
If a domain is configured for customized settings (by unchecking the "Use Defaults" options), then all the domain blacklists/whitelist become independent from the default "ALL DOMAINS". You thus need to specify the values you want for the various MAPS, SURBL, keywords, etc etc blacklists/whitelists for the customized domains.

This new feature now allows you, for any customized domain, to configure each blacklist/whitelist filter to be inherited from the "ALL DOMAINS" settings. If you thus wish to keep the MAPS and SURBL the same for your customized domains, you can by checking the new "Use defaults" option for each black/white list. Please note that the inheritance is "all or nothing". Either you configure a list to inherit the settings in their entirety, or you configure it to be customizable. You can't thus configure one to inherit *and* also be able to add on more entries to it.

Also please note that we found a bug in this feature that prevents new changes to the "ALL DOMAINS" filters to be propagated to these "inherited" filters unless SpamFilter is restarted. We have been testing a fix for a while (which required us to rewrite ALL the triggers in the database.... thus it was quite major) and will most likely release it this weekend or Mon-Tue at the latest (unless of course we find issue during the final testing).


-------------
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: 28 March 2010 at 2:00am
Cry

Something that inherited the base rules from all domains if selected, and then would add to them any custom items would be much better for us. 

Nice to see a new feature anyway...


Posted By: WebGuyz
Date Posted: 28 March 2010 at 9:20am
Originally posted by yapadu yapadu wrote:

Cry

Something that inherited the base rules from all domains if selected, and then would add to them any custom items would be much better for us. 

Nice to see a new feature anyway...
 
Yes, this would be the ultimate! But this is a good first step.
 
 I assume by default this will be off and as the feature is enabled for a domain, it will overwrite the custom domains entries with whatever the All Domains entry is for that particular filter.


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


Posted By: LogSat
Date Posted: 29 March 2010 at 11:20pm
Originally posted by WebGuyz WebGuyz wrote:


 I assume by default this will be off and as the feature is enabled for a domain, it will overwrite the custom domains entries with whatever the All Domains entry is for that particular filter.
We can do one better on this one, as when you toggle back and forth between the "inherit" setting, SpamFilter will remember the customized list you had configured for that specific domain if you toggle back to "not inherit".

As a side-note, we just made this pre-release build (4.1.3.827) available for download in the user's area.



-------------
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: 30 March 2010 at 8:23am

Just to make sure I'm clear on this. Once a domain is checked to inherit, is it a one time thing, or does it happen that every time after when I add a entry (like bl_keywords)  to ALL DOMAINS, every custom domain that has the inherit checked for that table will receive the upate for the bl_keywords?

 
Thanks!


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


Posted By: LogSat
Date Posted: 30 March 2010 at 7:42pm
Option #2. It would not be true inheritance if you made a change to black/whitelist in "ALL DOMAINS", and the changes did not propagate down to the various domains configured to "inherit" that list. Once you change "ALL DOMAINS", new database triggers will cause the update to be sent to all other domains within 5 seconds.

-------------
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: 31 March 2010 at 9:31am
Roberto,
 
   I assume there are db update scripts to add these new triggers. I assume they will only add new triggers and not mess with any exisiting ones?  I've added several to triggers in various tables to do various things and would hate to have it all screwed up :)
 
 


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


Posted By: LogSat
Date Posted: 31 March 2010 at 4:40pm
Good question, but we wouldn't mess with your triggers Smile!

We do however not only mess with, but completely delete and re-create our triggers.

During the years, we've had several database upgrades that needed to be performed to support new functionality. These updates occur automatically in the background when the new releases of SpamFilter startup, and so far (amazingly... even though now of course I'll jinx it...) this has never caused any issues.

Some updates are minor by only adding fields or increasing their field size, other times they're bigger... in this update we're deleting and re-creating most of the triggers used by SpamFilter.

The update process is performed by SpamFilter downloading the update scripts and executing them once. You can see them yourself by downloading them from the following URLs. Please note these are not zip files, we just use the .zip extension to prevent any issues with firewalls blocking the .sql extension... so simply rename the files to .sql or .txt to see them. The files with "4.1.3.827" are the ones being applied with this update.

www.logsat.com/spamfilter/pub/MicrosoftSQL-Enterprise-Update-v3.5.3.690.sql.zip
www.logsat.com/spamfilter/pub/MicrosoftSQL-Enterprise-Update-v3.5.3.696.sql.zip
www.logsat.com/spamfilter/pub/MicrosoftSQL-Enterprise-Update-v4.0.0.767.sql.zip
www.logsat.com/spamfilter/pub/MicrosoftSQL-Enterprise-Update-v4.0.0.770.sql.zip
www.logsat.com/spamfilter/pub/MicrosoftSQL-Enterprise-Update-v4.0.1.780.sql.zip
www.logsat.com/spamfilter/pub/MicrosoftSQL-Enterprise-Update-v4.1.2.794.sql.zip
www.logsat.com/spamfilter/pub/MicrosoftSQL-Enterprise-Update-v4.1.3.821.sql.zip
www.logsat.com/spamfilter/pub/MicrosoftSQL-Enterprise-Update-v4.1.3.827.sql.zip
www.logsat.com/spamfilter/pub/MySQL-Enterprise-Update-v3.5.3.690.sql.zip
www.logsat.com/spamfilter/pub/MySQL-Enterprise-Update-v3.5.3.696.sql.zip
www.logsat.com/spamfilter/pub/MySQL-Enterprise-Update-v4.0.0.767.sql.zip
www.logsat.com/spamfilter/pub/MySQL-Enterprise-Update-v4.0.0.770.sql.zip
www.logsat.com/spamfilter/pub/MySQL-Enterprise-Update-v4.0.1.780.sql.zip
www.logsat.com/spamfilter/pub/MySQL-Enterprise-Update-v4.1.2.794.sql.zip
www.logsat.com/spamfilter/pub/MySQL-Enterprise-Update-v4.1.3.821.sql.zip
www.logsat.com/spamfilter/pub/MySQL-Enterprise-Update-v4.1.3.827.sql.zip


-------------
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