Spam Filter ISP Forums : New to VersionNumber = '4.1.3.822'; https://www.logsat.com/spamfilter/forums/ Wed, 11 Mar 2026 06:01:01 +0000 Wed, 31 Mar 2010 16:40:55 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=6817 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[New to VersionNumber = '4.1.3.822'; : Good question, but we wouldn&#039;t...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13541&title=new-to-versionnumber-413822#13541 Author: LogSat
Subject: 6817
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
]]> Wed, 31 Mar 2010 16:40:55 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13541&title=new-to-versionnumber-413822#13541 <![CDATA[New to VersionNumber = '4.1.3.822'; : Roberto, I assume there are...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13539&title=new-to-versionnumber-413822#13539 Author: WebGuyz
Subject: 6817
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 :)
 
 
]]> Wed, 31 Mar 2010 09:31:54 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13539&title=new-to-versionnumber-413822#13539 <![CDATA[New to VersionNumber = '4.1.3.822'; : Option #2. It would not be true...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13536&title=new-to-versionnumber-413822#13536 Author: LogSat
Subject: 6817
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.]]> Tue, 30 Mar 2010 19:42:37 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13536&title=new-to-versionnumber-413822#13536 <![CDATA[New to VersionNumber = '4.1.3.822'; : Just to make sure I&#039;m clear...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13534&title=new-to-versionnumber-413822#13534 Author: WebGuyz
Subject: 6817
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!
]]> Tue, 30 Mar 2010 08:23:56 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13534&title=new-to-versionnumber-413822#13534 <![CDATA[New to VersionNumber = '4.1.3.822'; : WebGuyz wrote: I assume...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13530&title=new-to-versionnumber-413822#13530 Author: LogSat
Subject: 6817
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.

]]> Mon, 29 Mar 2010 23:20:09 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13530&title=new-to-versionnumber-413822#13530 <![CDATA[New to VersionNumber = '4.1.3.822'; : yapadu wrote:Something that...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13528&title=new-to-versionnumber-413822#13528 Author: WebGuyz
Subject: 6817
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.
]]> Sun, 28 Mar 2010 09:20:51 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13528&title=new-to-versionnumber-413822#13528 <![CDATA[New to VersionNumber = '4.1.3.822'; : Something that inherited the base...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13527&title=new-to-versionnumber-413822#13527 Author: yapadu
Subject: 6817
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...
]]> Sun, 28 Mar 2010 02:00:52 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13527&title=new-to-versionnumber-413822#13527 <![CDATA[New to VersionNumber = '4.1.3.822'; : If a domain is configured for...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13525&title=new-to-versionnumber-413822#13525 Author: LogSat
Subject: 6817
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).
]]> Sun, 28 Mar 2010 00:52:32 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13525&title=new-to-versionnumber-413822#13525 <![CDATA[New to VersionNumber = '4.1.3.822'; : I agree it is a big deal, much...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13524&title=new-to-versionnumber-413822#13524 Author: yapadu
Subject: 6817
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. 
]]> Fri, 26 Mar 2010 12:20:16 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13524&title=new-to-versionnumber-413822#13524 <![CDATA[New to VersionNumber = '4.1.3.822'; : Thats a pretty big deal! Right...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13523&title=new-to-versionnumber-413822#13523 Author: WebGuyz
Subject: 6817
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!
]]> Fri, 26 Mar 2010 11:53:16 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6817&PID=13523&title=new-to-versionnumber-413822#13523