#1  
Old 11th August 2009, 12: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 its 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 its allows usage of existing database schematics of ispconfig to powerdns daemon.

If its not possible i will start with standards pdns database schema.

Alternative way is sync information on tables ispconfig > powerdns via crontab for example. Its 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
  #2  
Old 11th August 2009, 12:46
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,380
Thanks: 833
Thanked 5,480 Times in 4,314 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
moglia (11th August 2009)
Reply

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 15:03.


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