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/
