Request for comments 3

[Jeroen Koekkoek]

Hi All,

I work for an ISP in the Netherlands and we use MailScanner to filter spam from ham. We currently use the LDAP backend to store rules. To let our customers make changes to their own rulesets, they would have to make changes to the default/global ruleset. This is a security issue since one user can make a change that could impact all users. In my spare time I came up with a solution, it's not yet implemented and I have to test the code I wrote. But basically it works like Postfix maps. Multiple maps can be specified, leaving the system default rules in txt files and allows our customer to make per user configuration settings.

This feature makes it easy for administrators to come up with their own backends (MySQL, PostgreSQL, SQLite, LDAP, flat files, etc) and allows for different backends in one configuration. I would be more than happy to mail my code once I tested it.

Regards.

-----Original Message-----
From: mailscanner-bounces at lists.mailscanner.info [mailto:mailscanner-bounces at lists.mailscanner.info] On Behalf Of UxBoD
Sent: Monday, July 23, 2007 9:15 AM
To: MailScanner discussion
Subject: Re: Request for comments 3

Alex,

Yes my understanding, and what I would be in favour of, would be the choice between flat files or SQL.

Regards.

--[ UxBoD ]--
// PGP Key: "curl -s https://www.splatnix.net/uxbod.asc | gpg --import"
// Fingerprint: C759 8F52 1D17 B3C5 5854  36BD 1FB1 B02F 5DB5 687B
// Keyserver: www.keyserver.net Key-ID: 0x5DB5687B
// Phone: +44 845 869 2749 SIP Phone: uxbod at sip.splatnix.net

----- Original Message -----
From: "Alex Broens" <ms-list at alexb.ch>
To: "MailScanner discussion" <mailscanner at lists.mailscanner.info>
Sent: Monday, July 23, 2007 6:11:15 AM (GMT) Europe/London
Subject: Re: Request for comments 3

On 7/23/2007 2:02 AM, Yashodhan Barve wrote:
> Richard Lynch wrote:
>>>
>>>
>> Well I, for one, would be against such a change.  I prefer text
>> configuration files.  They're simple to understand and simple to
>> change.  I personally don't see the need for a SQL database in this
>> regard.  Use relational databases when you need access to complex
>> indexed data.  This is a classic SWAP  (a solution without a problem). 
>> It you want to put a user friendly GUI on top of it that's fine as long
>> as the underlying structure is simple text.
>>
>> Richard
>>
> 
> I share Richards' view and would be against such a change. The text
> files makes things like copying config files to another server, backing
> up configuration easy.
> 
> It is also easy to diff your configurations with text files.
> imho, why fix something that is not broken?

Wasn't this about ADDING SQL support to MailScanner and NOT replacing 
the conf files with a DB layer?

Alex

-- 
MailScanner mailing list
mailscanner at lists.mailscanner.info
http://lists.mailscanner.info/mailman/listinfo/mailscanner

Before posting, read http://wiki.mailscanner.info/posting

Support MailScanner development - buy the book off the website! 

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-- 
MailScanner mailing list
mailscanner at lists.mailscanner.info
http://lists.mailscanner.info/mailman/listinfo/mailscanner

Before posting, read http://wiki.mailscanner.info/posting

Support MailScanner development - buy the book off the website!