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