Thread: Powerdns Plugin
View Single Post
  #1  
Old 11th August 2009, 13:25
moglia moglia is offline
Member
 
Join Date: Apr 2009
Posts: 92
Thanks: 7
Thanked 15 Times in 11 Posts
Lightbulb Powerdns Plugin

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
);
----------------------------------------------------------------------
Reply With Quote
Sponsored Links