From e4a138be2414e06bf4002d6e1eec16637b73bd50 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Sun, 6 Mar 2011 20:12:04 +0100 Subject: [PATCH] Checks domain with too many aliasing levels. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- bin/cron/checkdb.php | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/bin/cron/checkdb.php b/bin/cron/checkdb.php index 5eef761..fee4057 100755 --- a/bin/cron/checkdb.php +++ b/bin/cron/checkdb.php @@ -210,6 +210,13 @@ check("SELECT p.* WHERE p.link_id = g.id)", "Téléphones de type 'group' reliés à un groupe inexistant."); +// List domain aliasing with depth higher than 1: they will not be found by postfix. +check("SELECT evd.name + FROM email_virtual_domains AS evd + INNER JOIN email_virtual_domains AS evd2 ON (evd.aliasing = evd2.id) + WHERE evd2.id != evd2.aliasing", + "Domaines aliasés de niveau 2 ou plus qui ne sont pas vu par postfix."); + // Counts empty profile fields that should never be empty. infoCountEmpty('profile_addresses', 'type'); infoCountEmpty('profile_phones', 'link_type'); -- 2.1.4