On 1/16/08, Rocco Scappatura wrote: > > > > @storage_sql_dsn = ( > > > ['DBI:mysql:database=***;host=10.166.231.245;port=3306', > > '***', '***'] > > > ); $timestamp_fmt_mysql = 1; # if using MySQL *and* > > msgs.time_iso is > > > TIMESTAMP; > > > # defaults to 0, which is good for non-MySQL or if > > msgs.time_iso is > > > CHAR(16) > > > $virus_quarantine_method = '@sql'; > > > $spam_quarantine_method = '@sql'; > > > $banned_quarantine_method = '@sql'; > > > $bad_header_quarantine_method = '@sql'; > > > > > > I have restarted. The messages are correctly stored in msgs > > table (it > > > has been written maddr,msgrcpt tables too). But no spam > > messages was > > > detected. Maybe do I have to fill the RO tables before to run > > > amavisd-new+SQL? > > > > Should be: > > > > $virus_quarantine_method = 'sql:'; > > $spam_quarantine_method = 'sql:'; > > $banned_quarantine_method = 'sql:'; > > $bad_header_quarantine_method = 'sql:'; > > Thanks. But, it must exists at least a policy so that messages are > filtered for spam? > > > thanks, > > rocsca >
I could be wrong, but I don't think you need to create the read only tables. These following settings cannot be undefined (undef) if you want to quarantine to them, so I suggest leaving them at their default values. Setting them to undef means mail will not get quarantined (to each respective content type). # $virus_quarantine_to = 'virus-quarantine'; # $banned_quarantine_to = 'banned-quarantine'; # $bad_header_quarantine_to = 'bad-header-quarantine'; # $spam_quarantine_to = 'spam-quarantine'; Then, for instance, with no recipient in SQL, spam should get quarantined at $sa_kill_level_default. Also, remember that spam that scores at or above $sa_quarantine_cutoff_level will not get quarantined, so check that setting too. -- Gary V ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ 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/
