Still no luck enabling soft black/white lists, any help here would be
appreciated.
In general I`m trying to enable soft black/white lists without putting any
other configuration in SQL, I have config files for this.
Here is my /etc/amavis/conf.d/50-user
use strict;
#
# Place your configuration directives here. They will override those in
# earlier files.
#
# See /usr/share/doc/amavisd-new/ for documentation and examples of
# the directives you can use in this file
#
$max_servers = 20;
# Enable mysql lookups
@lookup_sql_dsn = (
['DBI:mysql:database=amavisd;host=xxx', 'amavisd', 'xxx'],
);
#$sql_select_policy = undef;
#
$sql_select_white_black_list = 1;
#$log_level=5;
# Enable header tags for all domains
$local_domains_re ='.';
@local_domains_maps =
(\%local_domains,[EMAIL PROTECTED],\$local_domains_re);
# Enable Virus check
@bypass_virus_checks_maps = (
\%bypass_virus_checks, [EMAIL PROTECTED],
\$bypass_virus_checks_re);
# Enable smap check
@bypass_spam_checks_maps = (
\%bypass_spam_checks, [EMAIL PROTECTED], \$bypass_spam_checks_re);
$sa_local_tests_only = 0;
$notify_method = 'smtp:127.0.0.1:25';
# Set different policies
$inet_socket_port = [10040,10041];
$interface_policy{'10040'} = 'INCOMING_UNTRUSTED';
$interface_policy{'10041'} = 'OUTGOING_UNTRUSTED';
$policy_bank{'INCOMING_UNTRUSTED'} = {
# Set spam levels
spam_tag_level_maps => [-999.0],
spam_tag2_level_maps => [6.31], # add 'spam detected' headers at that level
spam_kill_level_maps => [16.31], # triggers spam evasive actions
final_spam_destiny => D_PASS,
forward_method => 'smtp:127.0.0.1:10126',
};
$policy_bank{'OUTGOING_UNTRUSTED'} = {
# Set spam levels
spam_tag_level_maps => [-999.0],
spam_tag2_level_maps => [3.31], # add 'spam detected' headers at that level
spam_kill_level_maps => [16.31], # triggers spam evasive actions
final_spam_destiny => D_PASS,
forward_method => 'smtp:127.0.0.1:25',
};
#------------ Do not modify anything below this line -------------
1; # insure a defined return
On Wednesday 08 August 2007 17:14:44 Pavel Georgiev wrote:
> 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/
-------------------------------------------------------------------------
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/
