GitLab

Bugs:

• missing column in database powerdns;
• missing add permitions to database "powerdns" for ispconfig@user;
• missing add configuration after install for Powerdns file: pdns.local.gmysql.conf;
• not working resync from ISPConfig panel

Steps to reproduce:

• install powerdns on Debian Jessie and create database like powerdns;
• install ISPConfig client on new VPS, configure ISPC in expert mode, add VPS instance to multisetup ISPC; ISPC do not configure files pdns.local.gmysql.conf, no add permisions for ispconfig@user to database "powerdns" We must add manualy permissions to database Powerdns and add this lines to pdns.local.gmysql.conf file

gmysql-host=sql-host.ltd
gmysql-user=ispconfig
gmysql-password=password
gmysql-dbname=powerdns
gmysql-port=3306
slave=yes
master=yes
disable-axfr=no

• next configure VPS with Powerdns as a mirror another VPS with Bind9

After doing these steps at the panel adds a new DNS zone that works but we have many zone add before install new VPS with Powerdns. Now from the panel I enforce DNS synchronization, and I see that DNS zones and records are added to the powerdns database. After synchronization I check with nslookup whether there are new zones but Powerdns do not see them.

Below is a valid dump of the powerdns table

-- Zrzut struktury tabela powerdns.comments
CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `modified_at` int(11) NOT NULL,
  `account` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `comment` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `comments_domain_id_idx` (`domain_id`),
  KEY `comments_name_type_idx` (`name`,`type`),
  KEY `comments_order_idx` (`domain_id`,`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Data exporting was unselected.
-- Zrzut struktury tabela powerdns.cryptokeys
CREATE TABLE IF NOT EXISTS `cryptokeys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL,
  `flags` int(11) NOT NULL,
  `active` tinyint(1) DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `domainidindex` (`domain_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Data exporting was unselected.
-- Zrzut struktury tabela powerdns.domainmetadata
CREATE TABLE IF NOT EXISTS `domainmetadata` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL,
  `kind` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `domainmetadata_idx` (`domain_id`,`kind`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Data exporting was unselected.
-- Zrzut struktury tabela powerdns.domains
CREATE TABLE IF NOT EXISTS `domains` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `master` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_check` int(11) DEFAULT NULL,
  `type` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
  `notified_serial` int(11) DEFAULT NULL,
  `account` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ispconfig_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_index` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Data exporting was unselected.
-- Zrzut struktury tabela powerdns.records
CREATE TABLE IF NOT EXISTS `records` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` mediumtext COLLATE utf8_unicode_ci,
  `ttl` int(11) DEFAULT NULL,
  `prio` int(11) DEFAULT NULL,
  `change_date` int(11) DEFAULT NULL,
  `ispconfig_id` int(11) NOT NULL,
  `disabled` tinyint(1) DEFAULT '0',
  `ordername` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `auth` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `nametype_index` (`name`,`type`),
  KEY `domain_id` (`domain_id`),
  KEY `recordorder` (`domain_id`,`ordername`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Data exporting was unselected.
-- Zrzut struktury tabela powerdns.supermasters
CREATE TABLE IF NOT EXISTS `supermasters` (
  `ip` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `nameserver` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `account` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ip`,`nameserver`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Data exporting was unselected.
-- Zrzut struktury tabela powerdns.tsigkeys
CREATE TABLE IF NOT EXISTS `tsigkeys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `algorithm` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `secret` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `namealgoindex` (`name`,`algorithm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;