Filter settings not sticking
Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096
Printed Date: 23 February 2025 at 12:32am
Topic: Filter settings not sticking
Posted By: Rifleman
Subject: Filter settings not sticking
Date Posted: 06 June 2007 at 10:52am
|
I have SF Ent .678 and I am still unable to get some filter settings to stick.
I check the box in the BlackList area "Do Not quarantine emails from this blacklist are" in certain categories, I click on "Save settings" but wwhen I close and re-open it, they are unchecked again. This is annoying because I am quarantining ALL emails. I do not want to quarantine emails for example in Keywords and the BlackList To lists.
|
Replies:
Posted By: Desperado
Date Posted: 06 June 2007 at 11:51am
|
Rifleman, Does this happen on all list? I tried to duplicate your issue and can not. And ... You did hit the save and not just "close"? ------------- The Desperado Dan Seligmann. Work: http://www.mags.net Personal: http://www.desperado.com |
Posted By: Rifleman
Date Posted: 06 June 2007 at 11:54am
| It happens on all the Blacklists. And yes, I hit save prior to closing. |
Posted By: WebGuyz
Date Posted: 06 June 2007 at 12:06pm
|
Try hitting the tab key to get off that checkbox. Seems that if you click on some fields but don't tab to the next the program doesn't 'know' about it and it requires moving to another field so it does. ------------- http://www.webguyz.net |
Posted By: Rifleman
Date Posted: 06 June 2007 at 12:09pm
Just tried that, same thing. It unchecks itself.
|
WebGuyz wrote:Posted By: Desperado
Date Posted: 06 June 2007 at 12:16pm
|
Can you look in one of your "domains" folders and see if each domain has a "Filters.ini" file? ------------- The Desperado Dan Seligmann. Work: http://www.mags.net Personal: http://www.desperado.com |
Posted By: WebGuyz
Date Posted: 06 June 2007 at 1:35pm
|
Just double checked my test server running 678 and it works correctly for separate domains as well as ALL Domains. ------------- http://www.webguyz.net |
Posted By: LogSat
Date Posted: 06 June 2007 at 4:24pm
|
Rifleman, We can't reproduce it either... Could you please note the computer's time just before clicking on the "Save Settings" button, and them email us the section of SpamFilter's activity logfile from that time on (include about 5 minutes worth of data after that point). ------------- Roberto Franceschetti http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |
Posted By: Rifleman
Date Posted: 08 June 2007 at 11:47am
Here is the Filter.ini file
[Filter Settings]
id=1 domainid=1 bl_domainsforcedelete=0 bl_emailsfromforcedelete=0 bl_emailstoforcedelete=0 bl_countriesforcedelete=0 bl_mapsforcedelete=0 bl_keywordsforcedelete=0 bl_attachmentsforcedelete=0 bl_surblforcedelete=0 bl_ipsforcedelete=0 bl_honeypotemailsforcedelete=0 rejectnoreverseforcedelete=0 rejectnomxforcedelete=0 spffilterenableforcedelete=0 rejectemptymailfromforcedelete=0 rejectsametofromdomainforcedelete=0 rejectsametofromforcedelete=0 sfdbforcedelete=0 maxrcpt_toforcedelete=0 authorizedtoforcedelete=0 antivirusforcedelete=0 imageforcedelete=0 surblforcedelete=0 bayesianfilterenable=1 bayesianforcedelete=0 spffilterenable=1 spfneutralfilter=1 spfsoftfailfilter=0 spffailfilter=0 allowpercent=1 tagspam=0 tagspamsubject=0 tagspamandquarantine=0 rejectnoreverse=1 rejectnomx=1 rejectemptymailfrom=1 rejectsametofrom=0 rejectsametofromdomain=0 enableipcacheblacklist=1 autowhitelistforcedeliveryenabled=1 minmaps=2 maxsubjectspaces=10 spamimagethreshold=10 sfdb_networkreliability=2 sfdb_filtersall=1 sfdb_filterslist= id_1=1 domainname= ALL DOMAINS destsmtpserver= |
Posted By: Rifleman
Date Posted: 08 June 2007 at 11:49am
Here is the logfile entry
06/08/07 08:50:11:695 -- (2560) Exception occurred during TFilterObject.SaveFilterSettings: Invalid field size - 12
|
Posted By: LogSat
Date Posted: 08 June 2007 at 10:09pm
|
Rifleman, We received your entire logfile, and the entry above is indeed what we believe is the problem. The error: Invalid field size is returned by the ODBC / OLEDB driver when SpamFilter tries to execute the following query against the database: select * from tbl_filtersettings where domainid=1; It's caused by a bug (#5427) in MySQL. There's a workaround, which is to try configuring the MySQL ODBC DNS to "Return Matching Rows". Please see the screenshot below for the exact location.  ------------- Roberto Franceschetti http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |
Posted By: Rifleman
Date Posted: 11 June 2007 at 4:19pm
| I just did that. and the results are the same. |
Posted By: LogSat
Date Posted: 12 June 2007 at 9:48pm
|
The issue was caused by using an earlier, unsupported version of the MySQL ODBC Driver (v3.51.11). Upgrading to the latest MySQL ODBC 3.51.15 solved the problem.
------------- Roberto Franceschetti http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |