Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Filter settings not sticking
  FAQ FAQ  Forum Search   Register Register  Login Login

Filter settings not sticking

 Post Reply Post Reply
Author
Rifleman View Drop Down
Groupie
Groupie


Joined: 08 August 2005
Location: United States
Status: Offline
Points: 53
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rifleman Quote  Post ReplyReply Direct Link To This Post Topic: Filter settings not sticking
    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.
 
Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
Rifleman View Drop Down
Groupie
Groupie


Joined: 08 August 2005
Location: United States
Status: Offline
Points: 53
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rifleman Quote  Post ReplyReply Direct Link To This Post Posted: 06 June 2007 at 11:54am
It happens on all the Blacklists. And yes, I hit save prior to closing.
Back to Top
WebGuyz View Drop Down
Senior Member
Senior Member


Joined: 09 May 2005
Location: United States
Status: Offline
Points: 348
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebGuyz Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Rifleman View Drop Down
Groupie
Groupie


Joined: 08 August 2005
Location: United States
Status: Offline
Points: 53
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rifleman Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post 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
The Desperado
Dan Seligmann.
Work: http://www.mags.net
Personal: http://www.desperado.com

Back to Top
WebGuyz View Drop Down
Senior Member
Senior Member


Joined: 09 May 2005
Location: United States
Status: Offline
Points: 348
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebGuyz Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
Rifleman View Drop Down
Groupie
Groupie


Joined: 08 August 2005
Location: United States
Status: Offline
Points: 53
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rifleman Quote  Post ReplyReply Direct Link To This Post 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=
Back to Top
Rifleman View Drop Down
Groupie
Groupie


Joined: 08 August 2005
Location: United States
Status: Offline
Points: 53
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rifleman Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
Rifleman View Drop Down
Groupie
Groupie


Joined: 08 August 2005
Location: United States
Status: Offline
Points: 53
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rifleman Quote  Post ReplyReply Direct Link To This Post Posted: 11 June 2007 at 4:19pm
I just did that. and the results are the same.
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.145 seconds.