From f665ce7637d94da1d7193e624de692ed8edc2a5a Mon Sep 17 00:00:00 2001
From: Dominik <info@profi-webdesign.com>
Date: Fri, 30 Jan 2015 09:18:14 -0500
Subject: [PATCH] Texts for greylisting
---
install/tpl/mysql-virtual_policy_greylist.cf.master | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/install/tpl/mysql-virtual_policy_greylist.cf.master b/install/tpl/mysql-virtual_policy_greylist.cf.master
index 9f5546f..6172450 100644
--- a/install/tpl/mysql-virtual_policy_greylist.cf.master
+++ b/install/tpl/mysql-virtual_policy_greylist.cf.master
@@ -1,5 +1,5 @@
user = {mysql_server_ispconfig_user}
password = {mysql_server_ispconfig_password}
dbname = {mysql_server_database}
-query = SELECT 'greylisting' FROM mail_user WHERE email='%s' AND greylisting='y' and server_id = {server_id}
+query = SELECT DISTINCT('greylisting') FROM mail_forwarding mf, mail_user mu where (mf.source='%s' and mf.greylisting='y' and mf.server_id = {server_id}) or (mu.email='%s' and mu.greylisting='y' and mu.server_id = {server_id})
hosts = {mysql_server_ip}
\ No newline at end of file
--
Gitblit v1.9.1