From a38244c4eb70b27b763b36631ec36ccff0969ce4 Mon Sep 17 00:00:00 2001 From: bert hubert Date: Wed, 7 Sep 2016 18:23:34 +0200 Subject: [PATCH] fix up mydns backend to properly return SOA records in ANY queries. --- modules/mydnsbackend/mydnsbackend.cc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/modules/mydnsbackend/mydnsbackend.cc b/modules/mydnsbackend/mydnsbackend.cc index a9ef7ea753..8df0abeb28 100644 --- a/modules/mydnsbackend/mydnsbackend.cc +++ b/modules/mydnsbackend/mydnsbackend.cc @@ -129,7 +129,7 @@ MyDNSBackend::MyDNSBackend(const string &suffix) { d_listQuery_stmt = d_db->prepare(listQuery, 1); - anyQuery += ") UNION (SELECT 'SOA' AS type, origin AS data, '0' AS aux, ttl, id AS zone FROM `"+soatable+"` WHERE id = ? AND origin = ?"; + anyQuery += ") UNION (SELECT 'SOA' AS type, CONCAT_WS(' ', ns, mbox,serial,refresh,retry,expire,minimum) AS data, '0' AS aux, ttl, id AS zone FROM `"+soatable+"` WHERE id = ? AND origin = ?"; if (!soawhere.empty()) { anyQuery += " AND "+soawhere; -- 2.47.2