Hi list, I`m trying to setup amavis-new (2.3.3) with postfix (2.2.10) on Ubuntu 6.06. I have a working setup with two policy banks defined in the config.
I decided to add a soft black/white lists, but I cannot find the right documentation for this. I created 4 tables as described here: http://infocenter.guardiandigital.com/archive/amavis/2004/Dec/0316.html and enabled sql lookups with @lookup_sql_dsn = ( ... ) I see in the logs that a query is done for policies: lookup_sql select: SELECT *,users.id FROM users LEFT JOIN policy ON users.policy_id=policy.id WHERE users.email IN (?,?,?,?,?,?) ORDER BY users.priority DESC which return no records (I dont need policies in SQL) and then when wbl check is made no actual sql queries are made: amavis[18915]: (18915-01) wbl: checking sender <xxx> amavis[18915]: (18915-01) lookup_sql_field(id), "xxx" no matching records amavis[18915]: (18915-01) lookup => undef, "xxx" does not match amavis[18915]: (18915-01) wbl: (SQL) recip <xxx>, 0 matches How do I enable sql lookups for score_sender_maps (an example would be appreciated). In general I dont need any configuration is sql, I only want to put sender addresses (that are global, not per recipient). Is it possible to have sql lookup only for this in a custom sql tables that would have only two fields - address and score. I only care of the envelope sender is listed in that table so that I can get the score for it. Thanks! ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ 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/
