Spam Filter ISP Forums : Filter settings not sticking https://www.logsat.com/spamfilter/forums/ Wed, 11 Mar 2026 08:39:57 +0000 Tue, 12 Jun 2007 21:48:30 +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=6096 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[Filter settings not sticking : The issue was caused by using...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10319&title=filter-settings-not-sticking#10319 Author: LogSat
Subject: 6096
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.]]> Tue, 12 Jun 2007 21:48:30 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10319&title=filter-settings-not-sticking#10319 <![CDATA[Filter settings not sticking : I just did that. and the results...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10310&title=filter-settings-not-sticking#10310 Author: Rifleman
Subject: 6096
Posted: 11 June 2007 at 4:19pm

I just did that. and the results are the same. ]]> Mon, 11 Jun 2007 16:19:25 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10310&title=filter-settings-not-sticking#10310 <![CDATA[Filter settings not sticking : Rifleman,We received your entire...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10301&title=filter-settings-not-sticking#10301 Author: LogSat
Subject: 6096
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 isto try configuring the MySQL ODBC DNS to "Return Matching Rows".
Please see the screenshot below for the exact location.




]]> Fri, 08 Jun 2007 22:09:22 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10301&title=filter-settings-not-sticking#10301 <![CDATA[Filter settings not sticking : LogSat wrote:Rifleman,We can&#039;t...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10299&title=filter-settings-not-sticking#10299 Author: Rifleman
Subject: 6096
Posted: 08 June 2007 at 11:49am

Originally posted by LogSat LogSat wrote:

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).
 
Here is the logfile entry
 
06/08/07 08:50:11:695 -- (2560) Exception occurred during TFilterObject.SaveFilterSettings: Invalid field size - 12
]]> Fri, 08 Jun 2007 11:49:18 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10299&title=filter-settings-not-sticking#10299 <![CDATA[Filter settings not sticking : Desperado wrote:Can you look...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10298&title=filter-settings-not-sticking#10298 Author: Rifleman
Subject: 6096
Posted: 08 June 2007 at 11:47am

Originally posted by Desperado Desperado wrote:

Can you look in one of your "domains" folders and see if each domain has a "Filters.ini" file?
 
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=
]]> Fri, 08 Jun 2007 11:47:22 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10298&title=filter-settings-not-sticking#10298 <![CDATA[Filter settings not sticking : Rifleman,We can&#039;t reproduce...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10286&title=filter-settings-not-sticking#10286 Author: LogSat
Subject: 6096
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).
]]> Wed, 06 Jun 2007 16:24:26 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10286&title=filter-settings-not-sticking#10286 <![CDATA[Filter settings not sticking : Just double checked my test server...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10285&title=filter-settings-not-sticking#10285 Author: WebGuyz
Subject: 6096
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.]]> Wed, 06 Jun 2007 13:35:10 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10285&title=filter-settings-not-sticking#10285 <![CDATA[Filter settings not sticking : Can you look in one of your &#034;domains&#034;...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10283&title=filter-settings-not-sticking#10283 Author: Desperado
Subject: 6096
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?

Edited by Desperado]]> Wed, 06 Jun 2007 12:16:34 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10283&title=filter-settings-not-sticking#10283 <![CDATA[Filter settings not sticking : WebGuyz wrote:Try hitting the...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10281&title=filter-settings-not-sticking#10281 Author: Rifleman
Subject: 6096
Posted: 06 June 2007 at 12:09pm

Originally posted by WebGuyz WebGuyz wrote:

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.
 
Just tried that, same thing. It unchecks itself.
]]> Wed, 06 Jun 2007 12:09:04 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10281&title=filter-settings-not-sticking#10281 <![CDATA[Filter settings not sticking : Try hitting the tab key to get...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10280&title=filter-settings-not-sticking#10280 Author: WebGuyz
Subject: 6096
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.]]> Wed, 06 Jun 2007 12:06:20 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6096&PID=10280&title=filter-settings-not-sticking#10280