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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.