--
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
--