one mysql database per domain with amavisd-new while having multiple domains

Damian amavis at arcsin.de
Fri Oct 30 08:14:22 CET 2020


> I need *one mysql database per domain with amavisd-new while having multiple domains*. Is it possible?
> 
> Let's say i have a domain called *example.com*. I want everything for that domain to be stored in mysql database called *db_example*.
> Now, Let's say I have another domain called *client1.com*.  I want everything for that domain to be stored in mysql database 
> called *db_client1*.
> 
> in  amavisd.conf, Will  these lines reach my goal?
> 
> @lookup_sql_dsn =  ( ['DBI:mysql:database=db_example;host=127.0.0.1;port=3306', 'admin_db_example', 'secret'],
>                                      ['DBI:mysql:database=db_client1;host=127.0.0.1;port=3306', 'admin_db_client1', 'secret']);
> @storage_sql_dsn = @lookup_sql_dsn;

README.sql says:

> - a list can contain one or more triples: [dsn,user,passw]; more than one
>   triple may be specified to specify multiple (backup) SQL servers - the first
>   that responds will be used as long as it works, then search is retried
Additionally @*_sql_dsn are global confvars, so one cannot use different values in different policy banks.

So, no.


More information about the amavis-users mailing list