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