[Pdns-users] How to get PowerDNS to answer all requests with,the same response...?

Marcin Krol admin at domeny.pl
Sat Nov 24 09:38:51 UTC 2007


> insert into domains (name,type) values ('','NATIVE');

> insert into records (domain_id, name,type,content,ttl,prio) select id
> ,'', 'SOA', 'ns1.mynameservers.com hostmaster.mynameservers.com 1
> 604800 86400 2419200 604800', 604800, 0 from domains where name='';

Well, this certainly isn't correct. I've ran queries above with '' replaced by some name and got this:

mysql> select * from records where name='t33.com'\G
*************************** 1. row ***************************
         id: 353162
  domain_id: 80008
       name: t33.com
       type: SOA
    content: ns1.somewhere.com 1 604800 86400 2419200 604800
        ttl: 604800
       prio: 0
change_date: NULL
1 row in set (0.00 sec)

So this structure is definitely different when compared to example in the manual:

INSERT INTO records (domain_id, name, content, type,ttl,prio)
	  VALUES (1,'test.com','dns-us1.powerdns.net','NS',86400,NULL);
	  INSERT INTO records (domain_id, name, content, type,ttl,prio)
	  VALUES (1,'test.com','dns-eu1.powerdns.net','NS',86400,NULL);

( http://downloads.powerdns.com/documentation/html/configuring-db-connection.html#CONFIGURING-MYSQL )

In the example NSes are not stored in one column together with remainder of SOA record except TTL field, while zone2sql implies they should be. 

PDNS masters? Hello? The manual is skimpy on such details, and there are people would like to be filled in on them.

Marcin Krol

More information about the Pdns-users mailing list