New SpamFilter Enterprise Release Candida |
Post Reply
|
Page <12 |
| Author | |
dabull07
Newbie
Joined: 20 March 2007 Status: Offline Points: 2 |
Post Options
Thanks(0)
Quote Reply
Posted: 20 March 2007 at 1:21pm |
|
send me spam: administrator@aps.lfca1.us
|
|
![]() |
|
Dan B
Senior Member
Joined: 09 February 2005 Location: United States Status: Offline Points: 105 |
Post Options
Thanks(0)
Quote Reply
Posted: 20 March 2007 at 12:03pm |
|
R, Here is a thought. When SF is checking for the tables is it comparing case sensitive? All my tables are lower case and they all exist. |
|
![]() |
|
Dan B
Senior Member
Joined: 09 February 2005 Location: United States Status: Offline Points: 105 |
Post Options
Thanks(0)
Quote Reply
Posted: 20 March 2007 at 12:01pm |
|
Roberto, I'm using MySQL 5.0.37 as the database. SF GUI would not create the tables and triggers. I had to manually run the sql script that was provided with the latest SF RC. As to the tblreloadtableinfo it's inserting the records to which tables are being modified and I'm seeing SF load the new settings within the activity log window but if I'm in the SF Settings window and a change is made to some records by the database. It's not refreshing the data automatically. I have to close the SF settings window and reopen it and the new data will display. i.e SMTP settings, testing the port change and the local domains table top left of window adding new domains by database. I have notice that If I try step 2 of the create / check database tables. I get the following errors. ------------------------------------------------ ================ ===========Done================== -- drop table if exists `tblbl_emailsfrom`; ===========Done================== -- drop table if exists `tblbl_emailsto`; ===========Done================== -- drop table if exists `tblbl_maps`; ===========Done================== -- drop table if exists `tblbl_keywords`; ===========Done================== -- drop table if exists `tblbl_attachments`; ===========Done================== -- drop table if exists `tblbl_surbl`; ===========Done================== -- drop table if exists `tblbl_ips`; ===========Done================== -- drop table if exists `tblbl_honeypotemails`; ===========Done================== -- drop table if exists `tblbl_honeypotblockedips`; ===========Done================== -- drop table if exists `tblbl_countries`; ===========Done================== -- drop table if exists `tblwl_authorizedtoemails`; ===========Done================== -- drop table if exists `tblwl_keywords`; ===========Done================== -- drop table if exists `tblwl_emailsfrom`; ===========Done================== -- drop table if exists `tblwl_emailsto`; ===========Done================== -- drop table if exists `tblwl_autowhitelistforcedelivery`; ===========Done================== -- drop table if exists `tblwl_domainsips`; ===========Done================== -- drop table if exists `tblreloadtableinfo`; ===========Done================== -- drop table if exists `tbl_filtersettings`; ===========Done================== -- drop table if exists `tbl_localdomains`; ===========Done================== alter table `tblbl_domains` add constraint `fktblbl_domains` foreign key `fktblbl_domains` (`domainid`) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) ******* Error:Duplicate entry ' ALL DOMAINS' for key 2 -- drop trigger tr_localdomains_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger tr_localdomains_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger tr_localdomains_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger tr_localdomains_bd; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_authorizedtoemails_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_authorizedtoemails_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_authorizedtoemails_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_keywords_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_keywords_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_keywords_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_emailsfrom_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_emailsfrom_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_emailsfrom_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_emailsto_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_emailsto_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_emailsto_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_domainsips_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_domainsips_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_domainsips_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_autowhitelistforcedelivery_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_autowhitelistforcedelivery_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trwl_autowhitelistforcedelivery_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_domains_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_domains_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_domains_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_emailsfrom_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_emailsfrom_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_emailsfrom_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_emailsto_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_emailsto_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_emailsto_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_countries_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_countries_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_countries_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_maps_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_maps_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_maps_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_keywords_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_keywords_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_keywords_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_attachments_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_attachments_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_attachments_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_surbl_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_surbl_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_surbl_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_ips_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_ips_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_ips_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_honeypotemails_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_honeypotemails_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_honeypotemails_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_honeypotblockedips_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_honeypotblockedips_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger trbl_honeypotblockedips_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger tr_filtersettings_au; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger tr_filtersettings_ai; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' -- drop trigger tr_filtersettings_ad; ******* Error:This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Can't create table '.\spamfilter\#sql-6ac_5a3.frm' (errno: 121) Duplicate entry ' ALL DOMAINS' for key 2 This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' ----------------------------------------------------- Again, we are using MySQL 5.0.37 a fresh install of SF and MySQL. I hope this helps. Thanks,
|
|
![]() |
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4106 |
Post Options
Thanks(0)
Quote Reply
Posted: 19 March 2007 at 6:21pm |
|
Dan,
The changes to the database should be seen by SpamFilter within 5 seconds. This is done by making the use of triggers. Whenever an entry in a table is added/deleted/modified, a trigger within that table causes a new record to be created in the table "tblreloadtableinfo" that will contain the domain id being modified, and the table name that was changed. SpamFilter continuosly monitors this table, and as soon as there is a new entry SpamFilter will reload the right table. I hope the competition doesn't see this and get ideas from us.... This said, could you verify that this is indeed happening (the addition of new records inthe tblreloadtableinfo)? Please note that if there is already an existing record for the domainid/tablename combination, we won't add another one. If this is not happening, there may be a trigger missing from your database. This could be possible if you had an older version of SpamFilter Enterprise create the tables, as previous versions were indeed buggy (but so could this version...) It is problem that your 1st and last posting are related. In regards to the 12 char limit, we've had another report about it, but could not replicate it. What database platform and version are you using? |
|
![]() |
|
Dan B
Senior Member
Joined: 09 February 2005 Location: United States Status: Offline Points: 105 |
Post Options
Thanks(0)
Quote Reply
Posted: 19 March 2007 at 3:38pm |
|
R, Here is another Exceprion occurred error in the log file. Ver 3.5.3.654 (872) Exception occurred during TFilterObject.SaveFilterSettings: Invalid field size
Dan |
|
![]() |
|
Dan B
Senior Member
Joined: 09 February 2005 Location: United States Status: Offline Points: 105 |
Post Options
Thanks(0)
Quote Reply
Posted: 19 March 2007 at 2:04pm |
|
R, Here is a bug that I just fould. Ver 3.5.3.654 From within the SF Setting GUI adding or editing a domain name it is limited to 12 chars. Dan B
|
|
![]() |
|
Dan B
Senior Member
Joined: 09 February 2005 Location: United States Status: Offline Points: 105 |
Post Options
Thanks(0)
Quote Reply
Posted: 19 March 2007 at 1:58pm |
|
R, I'm preforming direct database configuration of adding and removing domains and SF is not seeing the changes. If I restart the service it will then see that a domain had been added or removed and load those settings. Is this a bug? Or are we not allowed to make direct changes to the database? Thanks, |
|
![]() |
|
Dan B
Senior Member
Joined: 09 February 2005 Location: United States Status: Offline Points: 105 |
Post Options
Thanks(0)
Quote Reply
Posted: 19 March 2007 at 1:52pm |
|
Oops... Ver 3.5.3.654
|
|
![]() |
|
Dan B
Senior Member
Joined: 09 February 2005 Location: United States Status: Offline Points: 105 |
Post Options
Thanks(0)
Quote Reply
Posted: 19 March 2007 at 1:51pm |
|
Roberto, I'm noticing this error on our SF Ent Ver 3.1.3.615 Exception occurred during TFilterObject.LoadFilter: Access violation at address 005F30A8 in module 'SpamFilterSvc.exe'. Read of address 0000009C Thanks, |
|
![]() |
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4106 |
Post Options
Thanks(0)
Quote Reply
Posted: 18 March 2007 at 8:32am |
|
I apologize, the expiration was a month off. The RC expires 5/1/07. We're so close to the release date we didn't notice...
|
|
![]() |
|
__M__
Groupie
Joined: 30 August 2006 Location: Australia Status: Offline Points: 75 |
Post Options
Thanks(0)
Quote Reply
Posted: 18 March 2007 at 12:26am |
|
Roberto, can you confirm when the beta expiry date is for 3.5.3.654.
Judging by the download page it looks like April 1st, considering I need to run the beta version of SFE on our live server to resolve the mail-splitting issue this could be a problem for me after April 1. |
|
![]() |
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4106 |
Post Options
Thanks(0)
Quote Reply
Posted: 13 March 2007 at 11:39pm |
|
The new SpamFilter Enterprise 3.5.3.654 Release Candidate RC1 is now available in the registered user area. There is only one minor bug fix from the latest beta as can be seen in the release notes.
Perhaps the biggest change is the availability of a new manual and documentation. While this is still a work in progress, we hope it is pretty accurate as-is. The release note for this last build is as follows: // New to VersionNumber = '3.5.3.654'; {TODO -cFix : SpamFilter could send duplicate emails when executing the process that runs every 60 minutes that reprocesses emails in the queue, as it could re-send emails that were being delivered at that exact moment} |
|
![]() |
|
Post Reply
|
Page <12 |
|
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.281 seconds.



Topic Options
Post Options
Thanks(0)


