Is PowerDNS version 4 supported in ISPconfig 3?

Discussion in 'General' started by pvanthony, Jul 19, 2017.

  1. pvanthony

    pvanthony Member

    Hi,
    I know PowerDNS version 3 is supported and working with ISPconfig 3.
    Because of the CAA record requirement for letsencrypt certs, I was wondering if PowerDNS version 4 is supported with ISPconfig 3.
    Any advice?
    P.V.Anthony
     
  2. Jesse Norell

    Jesse Norell Well-Known Member

    I believe there are no PowerDNS versions currently supported, though it seems like someone recently was using one with old code/plugin. I believe CAA records will be supported soon, maybe in the next release? (@florian030 had mentioned it recently)
     
  3. pvanthony

    pvanthony Member

    While testing out PowerDNS version 3 and version 4 with ispconfig 3 on centos 6 and 7, there were some issues with the mysql database. I have made some modifications to the database. With the modified sql statements, it seems to work.
    Of course the full support of PowerDNS version 4 is currently not there. As for PowerDNS version 3, it seems to be there and working great.
    Here are the modified sql statements to create the powerdns database. These seem to work.

    ---------------- start of sql for creating powerdns database -------------------
    CREATE TABLE `domains` (
    `id` int(11) NOT NULL auto_increment,
    `name` varchar(255) NOT NULL,
    `master` varchar(128) default NULL,
    `last_check` int(11) default NULL,
    `type` varchar(6) NOT NULL,
    `notified_serial` int(11) default NULL,
    `account` varchar(40) default NULL,
    `ispconfig_id` int(11) NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    CREATE UNIQUE INDEX name_index ON domains(name);

    CREATE TABLE `records` (
    `id` int(11) NOT NULL auto_increment,
    `domain_id` int(11) default NULL,
    `name` varchar(255) default NULL,
    `type` varchar(6) default NULL,
    `content` varchar(255) default NULL,
    `ttl` int(11) default NULL,
    `prio` int(11) default NULL,
    `change_date` int(11) default NULL,
    `disabled` TINYINT(1) DEFAULT 0,
    `ordername` VARCHAR(255) BINARY DEFAULT NULL,
    `auth` TINYINT(1) DEFAULT 1,
    `ispconfig_id` int(11) NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    CREATE INDEX rec_name_index ON records(name);
    CREATE INDEX nametype_index ON records(name,type);
    CREATE INDEX domain_id ON records(domain_id);
    CREATE INDEX recordorder ON records (domain_id, ordername);

    CREATE TABLE `supermasters` (
    `ip` varchar(25) NOT NULL,
    `nameserver` varchar(255) NOT NULL,
    `account` varchar(40) default NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    CREATE TABLE domainmetadata (
    id INT AUTO_INCREMENT,
    domain_id INT NOT NULL,
    kind VARCHAR(32),
    content TEXT,
    PRIMARY KEY (id)
    ) Engine=InnoDB DEFAULT CHARSET=utf8;

    CREATE INDEX domainmetadata_idx ON domainmetadata (domain_id, kind);
    ------------------------------------- end ----------------------------------------------
     
    till likes this.

Share This Page