New to VersionNumber = '4.1.3.822'; |
Post Reply 
|
| Author | |
yapadu 
Senior Member 
Joined: 12 May 2005 Status: Offline Points: 297 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: New to VersionNumber = '4.1.3.822';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? |
|
 |
|
|
WebGuyz
Senior Member
Joined: 09 May 2005 Location: United States Status: Offline Points: 348 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
yapadu
Senior Member
Joined: 12 May 2005 Status: Offline Points: 297 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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). |
|
|
|
|
yapadu
Senior Member
Joined: 12 May 2005 Status: Offline Points: 297 |
Post Options
Thanks(0)
Quote Reply
Posted: 28 March 2010 at 2:00am |
 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... |
|
|
|
|
WebGuyz
Senior Member
Joined: 09 May 2005 Location: United States Status: Offline Points: 348 |
Post Options
Thanks(0)
Quote Reply
Posted: 28 March 2010 at 9:20am |
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
|
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
Posted: 29 March 2010 at 11:20pm |
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. |
|
|
|
|
WebGuyz
Senior Member
Joined: 09 May 2005 Location: United States Status: Offline Points: 348 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
WebGuyz
Senior Member
Joined: 09 May 2005 Location: United States Status: Offline Points: 348 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
Posted: 31 March 2010 at 4:40pm |
|
Good question, but we wouldn't mess with your triggers
 !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 |
|
|
|
Topic Options
yapadu 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.248 seconds.