Can the white\black lists be imported from tables |
Post Reply 
|
| Author | |
Richw 
Guest Group 
|
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Can the white\black lists be imported from tablesPosted: 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 |
|
 |
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4106 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
RichW
Guest Group
|
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4106 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
Dan B
Senior Member 
Joined: 09 February 2005 Location: United States Status: Offline Points: 105 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
RichW
Guest Group
|
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
Desperado
Senior Member
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.332 seconds.