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.