> [...] I should be able to get around that by > setting @lookup_sql_dsn to undef and leaving @storage_sql_dsn set.
This also didn't work, but I found a way around it. It appears that with @storage_sql_dsn set, an undef value for @lookup_sql_dsn will cause amavisd to abort when attempting to look up a policy for that address. Mar 28 15:08:39 mailhost01 amavis[31006]: (31006-01) connect_to_sql: trying '' Mar 28 15:08:39 mailhost01 amavis[31006]: (31006-01) (!!)TROUBLE in process_request: Can't connect to data source '' because I can't work out what driver to use (it doesn't seem to contain a 'dbi:driver:' prefix and the DBI_DRIVER env var is not set) at (eval 110) line 229 Mar 28 15:08:39 mailhost01 amavis[31006]: (31006-01) (!)Requesting process rundown after fatal error I created a dummy database with an empty policy table and set @lookup_sql_dsn separately: @storage_sql_dsn = ( ['DBI:mysql:database=spamassassin;host=dbhost01.foo.com;port=3307', 'spam', 'edited'] ); @lookup_sql_dsn = ( ['DBI:mysql:database=sa_dummy;host=dbhost01.foo.com;port=3307', 'spam', 'edited'] ); This seems to work, but is somewhat of a kludge. Is there a cleaner way to override the sql policies with those defined in amavisd.conf? >> We use sql logging, so my solution is to insert a dummy amavisd on one >> of the common internal mail exchanger hosts and log all traffic to a >> common database. >> > So you _are_ in position to get hold of such traffic, why not just > re-route it to wherever you like. It's complicated. Our customers all have different rules about routing and storing mail (all data, actually,) and things can get a bit hairy with respect to what data goes where. So our mail routing is necessarily complex to guarantee that we live up to all of our agreements and protect everyone's IP. This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated. ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ 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/
