Skip to content

GitLab

  • Menu
Projects Groups Snippets
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • I ISPConfig 3
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 552
    • Issues 552
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 45
    • Merge requests 45
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • ISPConfig
  • ISPConfig 3
  • Issues
  • #4665
Closed
Open
Created May 25, 2017 by AndyPL@andrzejs

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;
Assignee
Assign to
Time tracking