Spam Filter ISP Forums : SpamFilter Enterprise bug reports

SpamFilter Enterprise bug reports : It has been a while, so I thought...

Sun, 10 Dec 2006 03:44:34 +0000

Author: caratking
Subject: 5846
Posted: 10 December 2006 at 3:44am

It has been a while, so I thought I would share another bug.

I setup a test box, and was running mysql 5.x on Windows. The scripts to setup the database still needed some work, but with some manual work I got things going OK.

Today I decided to move mysql over to a centos linux install (because I don't want to run it on windows).

I did a backup and restore of the database, right away Spam Filter starts giving errors:

Exception occurred during ChecktblReloadTableInfo: [MySQL][ODBC 3.51 Driver][mysqld-5.0.22]Table 'sf.tblReloadTableInfo' doesn't exist

This is a simple error of case. Windows does not care about the case, and linux does. The database tables are all in lower case however the code is calling them in upper case.... Guess I gotta stick with Windows until at least the next beta :-(

SpamFilter Enterprise bug reports : Not sure if this is related, but...

Sun, 19 Nov 2006 09:08:25 +0000

Author: caratking
Subject: 5846
Posted: 19 November 2006 at 9:08am

Not sure if this is related, but this is in the log after I release a message:

11/19/06 08:54:52:187 -- (5236) Adding to C:\Program Files\SpamFilter\domains\email.ca\AutoWhiteListForceDelivery .txt:gun@cableco.ca|nahomi@email.ca
11/19/06 08:54:52:187 -- (5236) Delivering quarantined email from to nahomi@email.ca
11/19/06 08:54:52:328 -- Exception occurred during PrepareQuarantineGrid: Operation cannot be performed while executing asynchronously

SpamFilter Enterprise bug reports : Another possible issue I am seeing.I...

Sun, 19 Nov 2006 08:58:19 +0000

Author: caratking
Subject: 5846
Posted: 19 November 2006 at 8:58am

Another possible issue I am seeing.

I have the following in the ini file:

AutoWhiteListForceDeliveryEnabled=1

However, when clicking Deliver Selected button in the Quarantine area the message will get delivered but it does not whitelist the sender of the message as the next day I see email from the same sender (google news alerts in this case) being blocked.

SpamFilter Enterprise bug reports : Another error I just noticed in...

Wed, 15 Nov 2006 07:09:06 +0000

Author: ayjayef
Subject: 5846
Posted: 15 November 2006 at 7:09am

Another error I just noticed in the logs...

11/15/06 22:36:54:927 -- (6932) Connection from: 82.49.162.33 - Originating country : Italy
11/15/06 22:36:56:958 -- (6932) Exception occurred during TestForReject: Access violation at address 005BDA7A in module 'SpamFilterSvc.exe'. Read of address 0000009C
11/15/06 22:36:59:724 -- (6932) Exception occurred during RECEIVEMESSAGE: ( 1 2 2b 3 3a 4 5 6 7 8 9 11 12 13 15 16 17 18 18b 19 111) Access violation at address 005C1182 in module 'SpamFilterSvc.exe'. Read of address 00000088 --
11/15/06 22:37:00:396 -- (6932) Disconnect

I should add, that apart from a few little flaws it's a darn good product. In this test domain I'm catching most of the junk and starting to get excited that this might be a real winner as it has enough performance and configuration choices to suit a whole host of customer domains. THANKS!

SpamFilter Enterprise bug reports : Found another interesting little...

Sat, 11 Nov 2006 19:20:23 +0000

Author: caratking
Subject: 5846
Posted: 11 November 2006 at 7:20pm

Found another interesting little issue.

When inserting keywords (into MySQL).

Something like the following:

\/iaagra will end up becomming

/iaagra

SpamFilter Enterprise bug reports : Andy,I started getting that error...

Fri, 10 Nov 2006 08:56:55 +0000

Author: caratking
Subject: 5846
Posted: 10 November 2006 at 8:56am

Andy,

I started getting that error message today as well. It was working, so I assumed that something was probably wrong with the communication from my test server to the lookup server it was trying to use.


11/10/06 08:31:25:359 -- (2448) Exception occurred during DoSURBLCheck: Access violation at address 005BC2A3 in module 'SpamFilterSvc.exe'. Read of address 2E5812EB
11/10/06 08:31:25:359 -- (2448) Exception occurred during DoSURBLCheck: Access violation at address 005BC2A3 in module 'SpamFilterSvc.exe'. Read of address 2E5812EB
11/10/06 08:31:25:359 -- (2448) Exception occurred during DoSURBLCheck: Access violation at address 005BC2A3 in module 'SpamFilterSvc.exe'. Read of address 2E5812EB

SpamFilter Enterprise bug reports : I think I have one too... The...

Wed, 08 Nov 2006 23:42:01 +0000

Author: ayjayef
Subject: 5846
Posted: 08 November 2006 at 11:42pm

I think I have one too...

The Surbl lookups (and blocking) were working fine in until I configured the quarantine in MySQL. The domain is still configured for multi.surbl.org and this is the error in the activity log.

Exception occurred during DoSURBLCheck: Access violation at address 005BC2A3 in module 'SpamFilterSvc.exe'. Read of address 2E3A13DE

11/09/06 15:23:12:674 -- (4240) Connection from: 210.9.99.999 - Originating country : Australia
11/09/06 15:23:12:877 -- (4240) Resolving 210.9.99.999 - fromdomain.com.au
11/09/06 15:23:13:596 -- (4240) - SPF analysis for fromdomain.com.au done: - none
11/09/06 15:23:13:612 -- (4240) Mail from: andy@fromdomain.com.au
11/09/06 15:23:16:362 -- (4240) - MAPS search done...
11/09/06 15:23:16:362 -- (4240) RCPT TO: postmaster@todomain.net.au accepted
11/09/06 15:23:16:393 -- (4240) EMail from andy@fromdomain.com.au to postmaster@todomain.net.au passes Bayesian filter - 0% spam (0ms)
11/09/06 15:23:16:393 -- (4240) Exception occurred during DoSURBLCheck: Access violation at address 005BC2A3 in module 'SpamFilterSvc.exe'. Read of address 2E3A13DE
11/09/06 15:23:16:440 -- (4240) Exception occurred during DoSURBLCheck: Access violation at address 005BC2A3 in module 'SpamFilterSvc.exe'. Read of address 2E3A13DE
11/09/06 15:23:16:455 -- (4240) EMail from andy@fromdomain.com.au to postmaster@todomain.net.au was queued. Size: 2 KB, 2048 bytes
11/09/06 15:23:16:471 -- (3132) Sending email from andy@fromdomain.com.au to postmaster@todomain.net.au --
11/09/06 15:23:16:487 -- (5596) Time to add Msg to Bayes corpus:0
11/09/06 15:23:16:518 -- (4240) Disconnect
11/09/06 15:23:16:627 -- (3132) EMail from andy@fromdomain.com.au to postmaster@todomain.net.au -- was forwarded to mail.todomain.net.au:26

Andy.

SpamFilter Enterprise bug reports : Ok, I think I got one!Amazing...

Wed, 08 Nov 2006 05:49:57 +0000

Author: caratking
Subject: 5846
Posted: 08 November 2006 at 5:49am

Ok, I think I got one!

Amazing there are no real issues with this first beta, impressive.

Anyway here is a problem I'm having.

Black lists, for each domain. It is reporting 0 hits for all countries (for all domains), when this obviously can't be right - even if I have had only one email for a given domain.

The other thing is, in the standard edition you can click on the country, hits, description to sort the field. This is useful when seeing which countries send the most email and if you want to find a specific country to ban etc.

Hmmm... I just noticed another thing. I can't even enable country filtering even if I want to. I check the country, and click save settings but nothing takes. If I leave the specified domain and come back all countries are blank.

Edited by caratking

SpamFilter Enterprise bug reports : Yep, I was aware that 5.0 was...

Wed, 01 Nov 2006 22:37:41 +0000

Author: caratking
Subject: 5846
Posted: 01 November 2006 at 10:37pm

Yep, I was aware that 5.0 was required. It was a new install, so I did not have any upgrade issues for mysql.

SpamFilter Enterprise bug reports : Yes, I confirm. Unfortunately...

Tue, 31 Oct 2006 17:58:44 +0000

Author: LogSat
Subject: 5846
Posted: 31 October 2006 at 5:58pm

Yes, I confirm. Unfortunately MySQL 4 does not have support for triggers, which are essential in SFE.