rocsca, > I'm currentry using @lookup_sql_dsn for storing quarantine in DB. > > So I have tried to include both DSN in @lookup_sql_dsn array: > > @lookup_sql_dsn = > ( > ['DBI:mysql:database=amavis;host=127.0.0.1;port=3306', > 'user1', 'apss1'], > ['DBI:mysql:database=postfix;host=127.0.0.1;port=3306', > 'user2', 'pass2'], > );
Having multiple data set names in the list is just a failover feature, they must all present the same schema, and only one of them is used at a time. > But after that Amavisd-new won't go on. Nevertheles gives error. How I > have to do to preserve both features (virus_lover that queries "postfix" > database, and SQL quarantine that interact with "amavis" database)? Amavisd can use (up to) two connections to a database, separating a read-only database used for lookups and white/black-listing (through @lookup_sql_dsn), from a read/write database access through @storage_sql_dsn, used for everything else, i.e. for SQL logging (pen pals) and quarantining. So in your case the split is natural, use @lookup_sql_dsn pointing to one database used only for lookups (such as virus_lover queries), and use @storage_sql_dsn pointing to a separate database, hosting a quarantine and logging. See also README_FILES/README.sql . Mark ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/