Marc, > since now I'm not using any SQL in AMaViSd / SpamAssassin. > I'm planning to go to bayes in SQL and to make use of the pen pal / > bounce killer feature with MySQL. > > There are no per user settings, so there is no need to store anything > else in SQL at the moment (as I can see).
Right. > I'm not quite clear what tables the logging mechanism in AMaViSd uses > and which I have to define to use bounce killer. Any hint? You need tables maddr, msgs, msgrcpt, and quarantine, search for "R/W part of the dataset" in README.sql-mysql / README.sql-pg. (even though a table 'quarantine' should exist, it need not be used, you can continue quarantining to files or wherever you like) To enable their use, the SQL dataset info needs to be provided by @storage_sql_dsn - it can be a dedicated r/w dsn, or can use the same dataset as SQL lookups (if in use), in which case it can be just its copy: @storage_sql_dsn = @lookup_sql_dsn; For example: @storage_sql_dsn = (['DBI:Pg:database=mail_log', 'amavis', 'my-secret-password']); SQL logging is enabled as soon as @storage_sql_dsn is nonempty. To enable penpals feature (which uses these tables), do: $penpals_bonus_score = 8; $penpals_threshold_high = $sa_kill_level_deflt; # don't waste time on hi spam To enable bounce killer: $bounce_killer_score = 100; # spam score points to add for joe-jobbed bounces Mark ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ 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/
