Powerdns bug - tested on IPSC 3.1.3
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;