Re: [AMaViS-user] X-Spam headers from another amavisd/SA

> [...] 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;164216...et/marketplace
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/