| commit | author | age | ||
| 9200ad | 1 | use strict; |
| T | 2 | |
| 3 | # | |
| 4 | # Place your configuration directives here. They will override those in | |
| 5 | # earlier files. | |
| 6 | # | |
| 7 | # See /usr/share/doc/amavisd-new/ for documentation and examples of | |
| 8 | # the directives you can use in this file | |
| 9 | # | |
| 10 | ||
| 11 | @bypass_virus_checks_maps = ( | |
| 12 | \%bypass_virus_checks, \@bypass_virus_checks_acl, \$bypass_virus_checks_re); | |
| 13 | ||
| 14 | @bypass_spam_checks_maps = ( | |
| 15 | \%bypass_spam_checks, \@bypass_spam_checks_acl, \$bypass_spam_checks_re); | |
| 16 | ||
| 17 | # | |
| 18 | # Database connection settings | |
| 19 | # | |
| 20 | ||
| 21 | @lookup_sql_dsn = | |
| 22 | ( ['DBI:mysql:database={mysql_server_database};host={mysql_server_ip};port={mysql_server_port}', '{mysql_server_ispconfig_user}', '{mysql_server_ispconfig_password}'] ); | |
| 23 | ||
| 24 | # @storage_sql_dsn = @lookup_sql_dsn; # none, same, or separate database | |
| 25 | #$sql_select_policy = 'SELECT "Y" as local FROM mail_domain WHERE CONCAT("@",domain) IN (%k)'; | |
| 26 | # $banned_files_quarantine_method = 'sql'; | |
| 27 | # $spam_quarantine_method = 'sql'; | |
| 28 | ||
| 29 | # | |
| 30 | # SQL Select statements | |
| 31 | # | |
| 32 | ||
| 33 | $sql_select_policy = | |
| 34 | 'SELECT *,spamfilter_users.id'. | |
| 35 | ' FROM spamfilter_users LEFT JOIN spamfilter_policy ON spamfilter_users.policy_id=spamfilter_policy.id'. | |
| 36 | ' WHERE spamfilter_users.email IN (%k) ORDER BY spamfilter_users.priority DESC'; | |
| 37 | ||
| 38 | ||
| 39 | $sql_select_white_black_list = 'SELECT wb FROM spamfilter_wblist'. | |
| 40 | ' WHERE (spamfilter_wblist.rid=?) AND (spamfilter_wblist.email IN (%k))' . | |
| 41 | ' ORDER BY spamfilter_wblist.priority DESC'; | |
| 42 | ||
| 43 | ||
| 44 | # | |
| 45 | # Enable Logging | |
| 46 | # | |
| 47 | ||
| 48 | $DO_SYSLOG = 1; | |
| 49 | $LOGFILE = "/var/log/amavis.log"; # (defaults to empty, no log) | |
| 50 | ||
| 51 | $log_level = 5; # (defaults to 0) | |
| 52 | ||
| 53 | ||
| 54 | #------------ Do not modify anything below this line ------------- | |
| 55 | 1; # insure a defined return | |
