Black-/Whitelists in SQL Database (WAS: RE: SQL user options)

[Oliver Pitzeier]

Hi Julian!
Hi folks!

Julian Field wrote:
> >On Wednesday 11 June 2003 07:37 am, Jody Cleveland wrote:
> > > > OK. I did it. :-) I wrote some code (SQL_Backlist, 
> > > > SQL_Whitelist), 
> > > > which is - at least a bit - configurable trough variables in 
> > > > CustomConfig.pm. You can imagine what it does... Exactly what I 
> > > > wanted. :-)
> > > >
> > > > So... Is someone interested in this code?
> > >
> > > I would love to have that. Thanks!
> > I would second that. I am not ready to use it yet but I have been 
> > looking for a way to do per user black/white lists. Sounds very 
> > promising.
> 
> If all you need is file-based per-user and per-domain 
> black+whitelists, then there is already code in 
> CustomConfig.pm to do this for you. It's only the SQL bit 
> that's missing.

First: It's the SQL bit, which was - as I told you - really easy to code, since
MailScanner is Perl! :-)
Second: You can easily create a frontend (which will follow within the next
days) with SQL-based black-/whitelists, to let your users do the
black-/whitelisting theirself.

I do use a Cyrus IMAPd/Sendmail combination here, which is fine, since we do use
Sieve as well... Now I do also have the posibility to give my users the option
to not only add some Sieve-rules, but add black-/whitelists. You cannot imagine
how happy my users are. :-))))

Best regards,
 Oliver