New SpamFilter Enterprise beta v3.5.3.630 |
Post Reply |
Author | |
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Posted: 26 December 2006 at 10:20am |
An updated beta version of SpamFilter Enterprise v3.5.3.630 is now available to registered users. Please see notes below for details on the fixes and new features available in this beta.
Please note that all new features are (and always will be) available in both SpamFilter Enterprise and SpamFilter ISP "standard". SpamFilter Enterprise can be configured to run in "SpamFilter ISP standard" mode, which will cause SpamFilter to run pretty much as it always has, and does not require Microsoft SQL or MySQL to run. Major Changes introduced in SpamFilter ISP Enterprise v3.5 - The new SpamFilter ISP Enterprise v3.5 allows administrators to configure most filter settings individually for each domain being hosted. Most settings are now stored in a database, making it simpler for administrators to access them via custom web applications. Technical notes - SpamFilter ISP Enterprise can be configured to run in "Standard" mode and in "Enterprise" mode. When configured for "Standard" mode, the functionality will be the same as in previous versions. When configured for "Enterprise" mode, the new functionality is activated. The Quarantine Database must be enabled and active for the Enterprise mode. New Database functionality - In Enterprise mode, most settings are saved to the database. However, to avoid downtime if the database server is not available, all settings are automatically exported from the database to the file system. SpamFilter uses the files located on the file system to read all settings. SpamFilter will *not* read the database directly for its settings. SpamFilter will however continuously monitor the database, and if any settings stored in the database are changed, they are automatically saved to files and re-imported within seconds. New Database Requirements - SpamFilter Enterprise only supports Microsoft SQL 7 or higher and MySQL v5 or higher. Support for MS Access and Oracle will not be added. The new database functionality relies heavily on the use of database triggers to ensure replication of database data to the file system. Triggers where added to MySQL starting from version 5, which explains the minimum requirement for this platform. SpamFilter will try to add the necessary tables, indexes and triggers automatically. If this procedure fails, please manually execute the MicrosoftSQL-Enterprise.sql and/or the MySql-Enterprise.sql update scripts found in the database directory.
New .ini settings structure - In both the Enterprise and the
Standard modes, the SpamFilter.ini file has been greatly modified. Several
of the settings in the SpamFilter.ini file can now be specified
individually for each domain. For this reason, these settings have been
moved to a new Filter.ini file. In Enterprise mode, each domain will have
an associated Filter.ini file. All files relative to a domain are now
stored in a subdirectory named after that domain. Special folder names are:
Updates since previous beta - In addition to several bug fixes, this
version changes the way emails with multiple recipients are handles. Two
major issues in the past have been: Disclaimer - This version is a pre-release beta. As such, problems are expected. Using this version in a live production environment is not recommended. This beta will expire on March 1, 2007. |
|
NITF
Newbie Joined: 07 November 2006 Location: United States Status: Offline Points: 1 |
Post Options
Thanks(0)
|
Thank you for working so hard on the Enterprise version! Edited by NITF |
|
caratking
Groupie Joined: 13 March 2006 Location: United States Status: Offline Points: 79 |
Post Options
Thanks(0)
|
Thanks for the new beta, I have installed it and here are a list of bugs
I had previously reported, and their status as I see them in the new beta: 1) Country blocks per domain - Working 2) Sorting by titles on Country Filters tab - Not working (not sure if this is by design or not - it works in current release) 3) Using the '\' character in keyword filters not possible (on mysql server) - Not working (major bummer! RegEX is difficult without this) 4) Auto whitelisting - Not working When I click deliver message from the quarantine, it does add the email address combination to the domains AutoWhiteListForceDelivery.txt file. The email combination does NOT get added to tblwl_autowhitelistforcedelivery 5) CaSe IsSuEs with database names MySQL on Linux - Have not tested yet New Features Suggested 1) Que messages that are going to be quarantined if DB server not available - Have not tested yet, suspect not added just yet (still hope). I think those were the only issues I had reported, can't recall any others anyway. |
|
WebGuyz
Senior Member Joined: 09 May 2005 Location: United States Status: Offline Points: 348 |
Post Options
Thanks(0)
|
I'm trying to understand how SFE works for redundancy with a second server. Lets say I have 10 domains (or 500) and get a second copy of SFE for redundancy. Since your sharing a common database, how would you have both SFE's text files get updated with the same info?? How about 3 SFE's, how is redundancy/syncronisation accomplished in a multiple SFE environment?
|
|
http://www.webguyz.net
|
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
Thanks for the updates on the bugs caratking, we know the new beta has not fixed all pending issues, there were some serious flaws that took priority and had to be fixed sooner. We also had to release the new beta before the old one expired, so were forced to ignore some fixes, sorry!
WebGuyz, thanks for the observation. Your scenario is still untested, but I believe there would indeed be problems with the current beta to support multiple servers sharing the same database. We'll try to address this in the next beta in a few weeks. |
|
caratking
Groupie Joined: 13 March 2006 Location: United States Status: Offline Points: 79 |
Post Options
Thanks(0)
|
I did not know what WebGuyz was referring to. After Roberto's comments I now realize that the tblreloadtableinfo has nothing to indicate what server has / has not picked up the latest changes that need to be synced.
I thought I would update my previous bug comment thread: 5) CaSe IsSuEs with database names MySQL on Linux - Is working (previously I had not retested). I now have the SF pointing to a DB running on CentOS and MySQL 5. |
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
Thanks for the MySQL report. Please let us know if there's anything you see in the future causing issues with case sensitivity. We had to practically rewrite all our SQL code to fix this, and may have skipped a few...
WebGuyz is, as is usually the case :-) correct. The tblReloadTableInfo contains an indication of the changes made to tables and the domains they apply to. When SpamFilter sees records in that table, it knows that changes were made, and will reload the correct records from the updated tables. After this is done though, SpamFilter will clear the temp data in tblReloadTableInfo. If there are multiple SpamFilter servers pointing to the same database, only one SpamFilter will see the changes, as by the time others check that temp table, the 1st SpamFilter will have deleted the records. We will have to figure out somehting... this is a scenario we hadn't thought about, but must of course fix it! |
|
__M__
Groupie Joined: 30 August 2006 Location: Australia Status: Offline Points: 75 |
Post Options
Thanks(0)
|
Apologies if this is a red herring but I am running V3.5.3.631 and I think that the feature to add AllowedDomainFilterMatrix.txt has been left out of \domains\SFI\filters.ini
It does appear to be in the SpamFilter.ini file however regardless of the path I specify it always tries to grab the file from the default install path of SFI. Can anyone confirm this is the case please. Test Enviroment: SpamFilter V3.5.3.631 BETA in Standard Mode (not Enterprise) Edited by __M__ |
|
caratking
Groupie Joined: 13 March 2006 Location: United States Status: Offline Points: 79 |
Post Options
Thanks(0)
|
Found another situation where cAsE on mySQL on linux is an issue:
01/03/07 08:08:00:796 -- Exception occurred during ChecktblReloadTableInfo: [MySQL][ODBC 3.51 Driver][mysqld-5.0.22]Table 'mx.tblReloadTableInfo' doesn't exist I've been able to work around the problem by creating a view called tblReloadTableInfo that is simply a view of the lowercase table name. Edited by caratking |
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
__M__ and caratking, unfortunately we confirm (just verified...) both bugs still exist in the new beta.
|
|
__M__
Groupie Joined: 30 August 2006 Location: Australia Status: Offline Points: 75 |
Post Options
Thanks(0)
|
Roberto, no probs mate.
Glad to be able to assist with the testing of the beta, this problem by no means is causing us any great problem. I'm just very thankful that you guys are constantly addressing our concerns/wishes especially with major rewrite like the split mail processing. I continue to be more than happy with my decision to rely on SFI for our filtering needs. |
|
__M__
Groupie Joined: 30 August 2006 Location: Australia Status: Offline Points: 75 |
Post Options
Thanks(0)
|
Roberto, I have been testing V3.5.3.635 today on our test server and it appears to be working fine however this evening when I upgraded our live server I discovered that our MySQL case issue is still haunting us.
We are running in "standard" mode with our Quarantine database running on a Linux MySQL database called "SpamFilter_Quarantine". The following error is occuring because I believe of the case of tblquarantine (previous versions such as x.605 retail used tblQuarantine). Exception occurred during TDeliverQuarantineThread.Execute: [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-standard]Table 'SpamFilter_Quarantine.tblquarantine' doesn't exist Now obviously I could just rename the database table however considering our web-based Quarantine interface was designed for use with the old naming convention I think it's best that the case sensitive issue is addressed and Logsat standardizes on the naming previously used. To make life a little easier (although I'm sure you could look up old code) here is what the naming was previously. tblLogins tblMsgs tblQuarantine tblRejectCodes tblServers Let me know when you have another revision ready and I'll just punch it straight onto the live server to confirm that you can put these niggly little bugs to rest. Thanks again, Mike |
|
Rifleman
Groupie Joined: 08 August 2005 Location: United States Status: Offline Points: 53 |
Post Options
Thanks(0)
|
Is there a trick to adding domains? I cannot add more than 12 characters to the domain list. It will not let me. What am I doing wrong?
|
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
Could you please email/post a screenshot of where this is happening?
|
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
Mike,
We've actually converted all SQL queries in the new beta to lowercase, so this will require all table names to be changed to lowercase as well. This way to proceed was the simplest and safet way to avoid case-sensitivity problems in the future. Sorry for the delay! |
|
jerbo128
Senior Member Joined: 06 March 2006 Status: Offline Points: 178 |
Post Options
Thanks(0)
|
Roberto I have been seeing a lot of this in the log: Exception occurred during DoSURBLCheck: Access violation at address 005E397B in module 'SpamFilter.exe'. Read of address 2EC712EB I have tried disabling the surbl checks by unchecking under custom domain filters, but the error is still logged. Is this a known problem? I am running x.x.635. I sent you an email with the complete log of several threads with ip's and domains. Thanks |
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
Got it, thanks. We had fixed this error in the new beta, but the one you reported is a different one and no, it was not a known problem. It is now!
|
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
Jerbo128,
Actually the bug you found was more serious, as the problem was occurring on practically every SURBL filter check, rendering that filter useless... We've just uploaded a new beta with the fix (3.5.3.636). Thanks again for the report. |
|
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.334 seconds.