Print Page | Close Window

Can the white\black lists be imported from tables

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=2277
Printed Date: 19 April 2025 at 3:42pm


Topic: Can the white\black lists be imported from tables
Posted By: Guests
Subject: Can the white\black lists be imported from tables
Date 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


Replies:
Posted By: LogSat
Date 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

Posted By: Guests
Date 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

Posted By: LogSat
Date 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

Posted By: Dan B
Date 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

Posted By: Guests
Date 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 

Posted By: Desperado
Date 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.


Print Page | Close Window