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

[Indunil Jayasooriya]

Hi Amavisd users;

I need to set up multiple domains with amavisd-new.

I need *one mysql database per domain with amavisd-new while having
multiple domains*. Is it posible?

Let's say i have a domain called *example.com <http://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
<http://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;


in addition to the above,  if used below mysql commands.

mysql> USE db_example;
Database changed
INSERT INTO users VALUES ( NULL, 5, 5, '@example.com',      NULL, 'Y');


mysql> USE db_client1;
Database changed
INSERT INTO users VALUES ( NULL, 5, 5, '@client1.com',      NULL, 'Y');

Your ideas are welcome.  Pls insert your INPUTS.







-- 
cat /etc/motd

Thank you
Indunil Jayasooriya
http://www.theravadanet.net/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.amavis.org/pipermail/amavis-users/attachments/20201030/a9ec8d1b/attachment.htm>