Powerdns Plugin

Discussion in 'Developers' Forum' started by moglia, Aug 11, 2009.

  1. moglia

    moglia New Member

    Previously im used powerdns with poweradmin to manage my dns. i have some experience of powerdns usage.

    Anyone can tell-me about powerdns database schema it´s static or not.
    can be changed using a pdns.conf. (i searched docs and not found anyting)

    Powerdns is on roadmap to version 3.0.2 i think start to make a plugin to manage powerdns.

    Im asking for possible change query for search records because it´s allows usage of existing database schematics of ispconfig to powerdns daemon.

    If it´s not possible i will start with standards pdns database schema.

    Alternative way is sync information on tables ispconfig > powerdns via crontab for example. It´s make possible change dns backend anytimes.

    ----------------------------------------------------------------------
    Powerdns Database Schematics
    ----------------------------------------------------------------------
    create table domains (
    id INT auto_increment,
    name VARCHAR(255) NOT NULL,
    master VARCHAR(128) DEFAULT NULL,
    last_check INT DEFAULT NULL,
    type VARCHAR(6) NOT NULL,
    notified_serial INT DEFAULT NULL,
    account VARCHAR(40) DEFAULT NULL,
    primary key (id)
    )type=InnoDB;

    CREATE UNIQUE INDEX name_index ON domains(name);

    CREATE TABLE records (
    id INT auto_increment,
    domain_id INT DEFAULT NULL,
    name VARCHAR(255) DEFAULT NULL,
    type VARCHAR(6) DEFAULT NULL,
    content VARCHAR(255) DEFAULT NULL,
    ttl INT DEFAULT NULL,
    prio INT DEFAULT NULL,
    change_date INT DEFAULT NULL,
    primary key(id)
    )type=InnoDB;

    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 table supermasters (
    ip VARCHAR(25) NOT NULL,
    nameserver VARCHAR(255) NOT NULL,
    account VARCHAR(40) DEFAULT NULL
    );
    ----------------------------------------------------------------------
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    As far as I know powerdns does not support custom SQL queries. There is already a plugin for powerdns made by falko which will be integrated in 3.0.2. As far as I know he has not published it yet. I will ask him to upload the code to svn.
     

Share This Page