Skip to content

PowerDNS of Debian Buster not working with Ispconfig >=3.2.2

When running powerdns with the ispconfig >= 3.2.2 it throws several sql errors. The provided schema seems to be a little bit outdated. Had to apply the following patch:

diff --git a/install/sql/powerdns.sql b/install/sql/powerdns.sql
index c9bf8280..780cbbdc 100644
--- a/install/sql/powerdns.sql
+++ b/install/sql/powerdns.sql
@@ -20,6 +20,8 @@ CREATE TABLE IF NOT EXISTS `records` (
`ttl` int(11) default NULL,
`prio` int(11) default NULL,
`change_date` int(11) default NULL,
+  `disabled` tinyint(1) default 0,
+  `auth` tinyint(1) default 1,
`ispconfig_id` int(11) NOT NULL,
PRIMARY KEY  (`id`),
KEY `rec_name_index` (`name`),
@@ -32,3 +34,11 @@ CREATE TABLE IF NOT EXISTS `supermasters` (
`nameserver` varchar(255) NOT NULL,
`account` varchar(40) default NULL
) ENGINE=InnoDB;
+
+CREATE TABLE IF NOT EXISTS `domainmetadata` (
+  `id` int auto_increment,
+  `domain_id` int NOT NULL,
+  `kind` varchar(32),
+  `content` TEXT,
+  PRIMARY KEY (`id`)
+) Engine=InnoDB;