Prev Previous Post   Next Post Next
  #1  
Old 11th August 2009, 12:25
moglia moglia is offline
Member
 
Join Date: Apr 2009
Posts: 89
Thanks: 6
Thanked 13 Times in 10 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
 

Bookmarks

Tags
powerdns

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Spamsnake - Problem with spamassassin, FuzzyOcr and MySQL debuguser HOWTO-Related Questions 6 16th September 2008 18:37
Spamassassin not working hairydog2 General 7 12th July 2008 21:15
spamassasin/clamAV not working Daisy Installation/Configuration 32 15th February 2007 00:09
postfix-tls sasl2 mysql courier-authmysql gabrix Server Operation 4 12th January 2007 22:09
help with the Postfix Spam Filter using Ubuntu Dapper, MailScanner... tutorial the block Suggest HOWTO 1 8th November 2006 18:20


All times are GMT +2. The time now is 00:27.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.