SQL Integration

[James Day]

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