[Exim] Exim + MySQL + Spam Filter

Top Page
Delete this message
Reply to this message
Author: Alain Stucki
Date:  
To: exim-users
Subject: [Exim] Exim + MySQL + Spam Filter
--
Hi there

i'm using exim 3.36 with MySQL support.
all works well, but i don't found any usable spam (and virus) filter.
all spam filter i've found, need the ~/.forward file or procmail.

have anyone a idea?

i'm confused, can i use procmail together with the mysql config ?

i've attached my exim config file

greetz

--
****************************************
ZiC internet & communication AG
Alain Stucki
Programmierer
Steinbachstrasse 92a
3123 Belp

Tel : 031 812 40 00
Fax: 031 812 40 05
Mail: stucki@???
****************************************
--
Content-Description: Exim config file

hide mysql_servers = localhost/mailserver/mailserver/xxxxx
qualify_domain = newsservice.ch
local_domains = localhost:mysql;SELECT userid FROM domains WHERE userid='$key';
local_domains_include_host = true
local_domains_include_host_literals = true
#relay_domains =
#relay_domains_include_local_mx = true
never_users = root
host_lookup = *
#rbl_domains = rbl.mail-abuse.org/reject : dialups.mail-abuse.org/warn
host_accept_relay = 127.0.0.1 : ::::1
host_auth_accept_relay = *
# percent_hack_domains=*
trusted_users = mail:root:nobody
smtp_verify = true
gecos_pattern = ^([^,:]*)
gecos_name = $1
errors_copy = admin@???
errors_address = admin@???
smtp_accept_queue_per_connection = 30
freeze_tell_mailmaster = true
received_header_text = "Received: \
         ${if def:sender_rcvhost {from ${sender_rcvhost}\n\t}\
         {${if def:sender_ident {from ${sender_ident} }}\
         ${if def:sender_helo_name {(helo=${sender_helo_name})\n\t}}}}\
         by ${primary_hostname} \
         ${if def:received_protocol {with ${received_protocol}}} \
         (Exim ${version_number} #${compile_number})\n\t\
         id ${message_id}\
         ${if def:received_for {\n\tfor <$received_for>}}"


smtp_banner = "ZiC internet & communication AG\nESMTP Mailservice\nHave a nice day!\nsv-02.sophokles.net ESMTP"

auto_thaw=2h
delay_warning = 24h:1920h
timeout_frozen_after = 21d

receiver_try_verify = true
accept_8bitmime = true
#local_interfaces = 127.0.0.1
#queue_list_requires_admin = false
no_local_from_check

warning_t:
  driver        = autoreply
  text          = ${lookup mysql{select data from autoreply where email='$local_part@$domain'}{$value}fail}
  subject       = ${lookup mysql{select subject from autoreply where email='$local_part@$domain'}{$value}fail}
  from          = $local_part@$domain
  to            = $sender_address
  user          = mail


address_pipe:
driver = pipe
path = /usr/bin:/bin:/usr/local/bin
return_output

address_file:
driver = appendfile
envelope_to_add = true
return_path_add = true

address_directory:
driver = appendfile
no_from_hack
prefix = ""
suffix = ""
maildir_format
create_directory
directory = /tmp/test/${host}/

remote_smtp:
driver = smtp


auto_warning_d:
  driver        = smartuser
  condition     = ${lookup mysql{select email from autoreply where email='$local_part@$domain' and active='yes'}{$value}fail}
  transport     = warning_t
  no_verify
  unseen


mysql_aliases:
driver = aliasfile
file_transport = address_file
directory_transport = address_directory
pipe_transport = address_pipe
search_type = mysql
query = "SELECT maildir FROM users where id = '$local_part@$domain';"
user = mail
group = mail

#majordomo director
mdom_aliases:
domains = "newsservice.ch"
driver = aliasfile
file_transport = address_file
pipe_transport = address_pipe
file = /etc/majordomo/newsservice.ch/aliases
search_type = lsearch
user = mdom
group = mail


virtual_aliases:
driver = aliasfile
search_type = mysql
query ="select alias from aliases where id = '$local_part@$domain'"
include_domain = true

virtual_daliases:
driver = aliasfile
search_type = mysql
query ="select alias from daliases where domain = '$domain'"
include_domain = true



lookuphost:
driver = lookuphost
transport = remote_smtp

literal:
driver = ipliteral
transport = remote_smtp



# Domain               Error       Retries
# ------               -----       -------
*                      *           F,2h,15m; G,16h,2h,1.5; F,4d,8h




--