SQL Integration

[portase.florin at medianetork.ro]

take a look at this :: 
http://lists.amavis.org/pipermail/amavis-users/2011-August/000707.html

and readabout SPAMASSASSIN SQL userpref.


On Fri, 26 Aug 2011 12:28:46 +0100, James Day wrote:
> Hello,
>
> This seems like a basic issue but despite my best efforts on google I
> have been unable to find an answer.
>
> Currently I am handling per domain black/white lists using the 
> following:
>
> $per_recip_blacklist_sender_lookup_tables= {'.mydomain.co.uk' =>
> [@domainblacklist]};
>
> Where @domainblacklist is defined as:
>
> My @domainblacklist = ('user at domain','user2 at domain2');
>
> And this works fine. But is not very scalable in the long term.
>
> I understand that amavis can integrate with MySQL which would make
> the whole thing simpler.
>
> I believe I need to user:
>
> @lookup_sql_dsn
>
> To tell amavis which database to connect to and what credentials to
> use. And I think I might also need to use:
>
> @storage_sql_dsn
>
> I have found the required schema for the database.
>
> My question is this:
>
> What do I have to set "$per_recip_blacklist_sender_lookup_tables" to
> in order to query the database?
>
> Kind Regards,
>
> James Day