Infact,
>> 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. > doing so.. @storage_sql_dsn = ( ['DBI:mysql:database=amavis;host=127.0.0.1;port=3306','user1', 'apss1'], ); @lookup_sql_dsn = ( ['DBI:mysql:database=postfix;host=127.0.0.1;port=3306','user2', 'pass2'], ); it works! :-) > 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 . Thanks Mark, rocsca ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
