On 1/16/08, Rocco Scappatura wrote: > Hello. > > I'm starting to use SQL for storing quarantine. > > I have set: > > @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, > > rocsca -- 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 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/