HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Developers' Forum (http://www.howtoforge.com/forums/forumdisplay.php?f=33)
-   -   Powerdns Plugin (http://www.howtoforge.com/forums/showthread.php?t=38137)

moglia 11th August 2009 12:25

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
);
----------------------------------------------------------------------

till 11th August 2009 12:46

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.


All times are GMT +2. The time now is 04:31.

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