Re: one mysql database per domain with amavisd-new while having multiple domains
Damian <[email protected]>
| Newsgroups | gmane.mail.virus.amavis.user |
|---|---|
| Message-ID | <[email protected]> |
> 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.