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;