From 0ff9abf46316f73c77e7e784e869cbd331498e5b Mon Sep 17 00:00:00 2001 From: tbrehm <t.brehm@ispconfig.org> Date: Wed, 23 Nov 2005 12:15:57 -0500 Subject: [PATCH] some small changes --- config/exim4/exim4.conf.template | 12 ++++++++---- 1 files changed, 8 insertions(+), 4 deletions(-) diff --git a/config/exim4/exim4.conf.template b/config/exim4/exim4.conf.template index b99fded..cbb0e6d 100644 --- a/config/exim4/exim4.conf.template +++ b/config/exim4/exim4.conf.template @@ -147,7 +147,7 @@ fail_router: driver = redirect - domains = ${lookup mysql {SELECT SUBSTRING_INDEX(email,'@',-1) FROM MYSQL_EMAILTABLE WHERE email=CONCAT('${quote_mysql:$local_part}','@','${quote_mysql:$domain}') AND enabled='no'}{$value}} + domains = ${lookup mysql {SELECT SUBSTRING_INDEX(email,'@',-1) FROM MYSQL_EMAILTABLE WHERE email=CONCAT('${quote_mysql:$local_part}','@','${quote_mysql:$domain}') AND active='0'}{$value}} data = ":fail:" allow_fail @@ -204,6 +204,10 @@ allow_fail allow_defer data = ${lookup mysql{ SELECT destination FROM mail_redirect WHERE email='${local_part}@${domain}' AND type = 'alias'}} + +mysql_email_forward: + driver = redirect + data = ${lookup mysql{ SELECT destination FROM mail_redirect WHERE email='${local_part}@${domain}' AND type = 'forward'}} #spamcheck_router: # driver = manualroute @@ -400,20 +404,20 @@ fixed_plain: driver = plaintext public_name = PLAIN - server_condition = ${lookup mysql{SELECT email FROM MYSQL_EMAILTABLE WHERE email='${quote_mysql:$2}' AND cryptpwd=encrypt('${quote_mysql:$3}', cryptpwd)}{1}fail} + server_condition = ${lookup mysql{SELECT email FROM MYSQL_EMAILTABLE WHERE email='${quote_mysql:$2}' AND cryptpwd=encrypt('${quote_mysql:$3}' AND active = '1', cryptpwd)}{1}fail} server_set_id = $2 fixed_login: driver = plaintext public_name = LOGIN server_prompts = "Username:: : Password::" - server_condition = ${lookup mysql{SELECT email FROM MYSQL_EMAILTABLE WHERE email='${quote_mysql:$1}' AND cryptpwd=encrypt('${quote_mysql:$2}', cryptpwd)}{1}fail} + server_condition = ${lookup mysql{SELECT email FROM MYSQL_EMAILTABLE WHERE email='${quote_mysql:$1}' AND cryptpwd=encrypt('${quote_mysql:$2}' AND active = '1', cryptpwd)}{1}fail} server_set_id = $1 cram: driver = cram_md5 public_name = CRAM-MD5 - server_secret = "${lookup mysql {SELECT clearpwd FROM mail_box WHERE email = '${sg {$1}{'}{}}' AND is_enabled = 'yes'} {$value} fail}" + server_secret = "${lookup mysql {SELECT clearpwd FROM mail_box WHERE email = '${sg {$1}{'}{}}' AND active = '1'} {$value} fail}" server_set_id = $1 -- Gitblit v1.9.1