Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Can the white\black lists be imported from tables
  FAQ FAQ  Forum Search   Register Register  Login Login

Can the white\black lists be imported from tables

 Post Reply Post Reply
Author
Richw View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote Richw Quote  Post ReplyReply Direct Link To This Post Topic: Can the white\black lists be imported from tables
    Posted: 20 October 2003 at 10:01pm

We're using 1.2.0.206 Registered.   We'd like the software to suck current versions of the whitelists and or the blacklists from a table in the database.  Is that possible?  Will it be possible in any future upgrade?

Thanks,

Rich Wilson

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 20 October 2003 at 11:28pm

Rich,

Not all SpamFilter administrators chose to use a database backend for the quarantined emails. They prefer the simplicity of a standalone SpamFilter just blocking unwanted emails. For this reason we cannot currently move out some of the settings, including black/white lists, into a database table.

Roberto F.
LogSat Software

Back to Top
RichW View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote RichW Quote  Post ReplyReply Direct Link To This Post Posted: 21 October 2003 at 12:06am

No Problem.

Any chance for a radio given options?   Or a selection to commit to either the lists or tables?  I can see reasons for both cases.

Thanks,

Rich Wilson

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 21 October 2003 at 12:33am

Honestly I do not think we'll duplicate the settings, it would become too confusing and error-prone.

Another aspect to consider is that we try to maintain SpamFilter's stability as high as possible. Should the database server not be available, currently SpamFilter continues to process incoming email as if nothing happened, and simply skips the quarantining process until the DB is back online. Should the settings also be stored in the database, SpamFilter would depend on it's availability to work, and we'd like to avoid dependencies if possible.

Roberto F.
LogSat Software

Back to Top
Dan B View Drop Down
Senior Member
Senior Member
Avatar

Joined: 09 February 2005
Location: United States
Status: Offline
Points: 104
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dan B Quote  Post ReplyReply Direct Link To This Post Posted: 22 October 2003 at 9:46am

Rich,

 

We store all our white & black lists in a database.  I wrote a Cold Fusion app that launches every hour to rewrite the text files that SF reads and imports in automatically.  You can use any language to write such a process.  ASP, Perl, C++, JAVA, etc.

Thanks,
Dan B

Back to Top
RichW View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote RichW Quote  Post ReplyReply Direct Link To This Post Posted: 22 October 2003 at 10:05am

Dan, Thanks were basically goingdoing that.  The question came up, however, if those lists are being imported by SF every minute.. what happens when the app is writing the file, and it is simultaneously being imported?  Have you had any issues with that.

We thought about nightly (or some frequency) stopping the SF service, updating the files and restarting the service.  

Rich 

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: 22 October 2003 at 8:03pm

Rich,

I am not speaking for Dan (B)  (I am Dan S)   but I do something that sounds VERY much the same as Dan but I have MSSQL Transactionaly (is that a word?) replicating to my text files.  That way I do not need a "timer" to fire off the updating.

In answer to the potential conflict .... perhaps God knows on that one (or maybe Roberto).  I have been running this way for a couple of months and if I had a problem, it was transparent to me.  I assume (Yep ... I really used tat word) if SpamFilter tried to read at the EXACT same time as SQL was writing, something real bad could happen but if you have ever driven on the Autobond, you kinda do things by statistics .... Last time I passed a care there was no problem ... so, I may as well keep doing it!

Dan S.

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.141 seconds.