[Pdns-users] New PowerDNS Authoritative Server snapshot with DNSSEC + Release Notes

[Leen Besselink]

I did notice one mistake in my sqlite3-dump, the domain-id did not
match, but adding the right id to the table didn't work either:

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE domains (
              id                INTEGER PRIMARY KEY,
              name              VARCHAR(255) NOT NULL COLLATE NOCASE,
              master            VARCHAR(128) DEFAULT NULL,
              last_check        INTEGER DEFAULT NULL,
              type              VARCHAR(6) NOT NULL,
              notified_serial   INTEGER DEFAULT NULL,
              account           VARCHAR(40) DEFAULT NULL
            );
INSERT INTO "domains" VALUES(1,'test.net',NULL,NULL,'NATIVE',NULL,NULL);
CREATE TABLE records (
              id              INTEGER PRIMARY KEY,
              domain_id       INTEGER DEFAULT NULL,
              name            VARCHAR(255) DEFAULT NULL,
              type            VARCHAR(6) DEFAULT NULL,
              content         VARCHAR(255) DEFAULT NULL,
              ttl             INTEGER DEFAULT NULL,
              prio            INTEGER DEFAULT NULL,
              change_date     INTEGER DEFAULT NULL
            );
INSERT INTO "records" VALUES(1,1,'test.net','SOA','ns1.test.net
hostmaster.test.net 2011012731 10800 3600 604800 38400',14400,0,NULL);
INSERT INTO "records"
VALUES(2,1,'test.net','NS','ns2.test.net',14400,0,NULL);
INSERT INTO "records"
VALUES(3,1,'test.net','NS','ns1.test.net',14400,0,NULL);
INSERT INTO "records"
VALUES(4,1,'test.net','NS','ns3.test.net',14400,0,NULL);
INSERT INTO "records"
VALUES(5,1,'ns1.test.net','A','10.0.0.101',3600,0,NULL);
INSERT INTO "records"
VALUES(6,1,'ns2.test.net','A','10.0.0.102',3600,0,NULL);
INSERT INTO "records"
VALUES(7,1,'ns3.test.net','A','10.0.1.13',3600,0,NULL);
INSERT INTO "records"
VALUES(8,1,'web.test.net','A','10.0.0.238',3600,0,NULL);
INSERT INTO "records"
VALUES(9,1,'www.test.net','CNAME','web.test.net',3600,0,NULL);
INSERT INTO "records"
VALUES(10,1,'test.net','MX','mx1.test.net',14400,100,NULL);
INSERT INTO "records"
VALUES(11,1,'test.net','MX','mx2.test.net',14400,100,NULL);
INSERT INTO "records"
VALUES(12,1,'test.net','MX','mx3.test.net',14400,400,NULL);
INSERT INTO "records"
VALUES(13,1,'test.net','MX','mx4.test.net',14400,400,NULL);
INSERT INTO "records"
VALUES(14,1,'mx1.test.net','A','10.0.0.111',3600,0,NULL);
INSERT INTO "records"
VALUES(15,1,'mx2.test.net','A','10.0.0.112',3600,0,NULL);
INSERT INTO "records"
VALUES(16,1,'mx3.test.net','A','10.0.0.116',3600,0,NULL);
INSERT INTO "records"
VALUES(17,1,'mx4.test.net','A','10.0.0.117',3600,0,NULL);
CREATE TABLE supermasters (
              ip          VARCHAR(25) NOT NULL,
              nameserver  VARCHAR(255) NOT NULL COLLATE NOCASE,
              account     VARCHAR(40) DEFAULT NULL
            );
CREATE UNIQUE INDEX name_index ON domains(name);
CREATE INDEX rec_name_index ON records(name);
CREATE INDEX nametype_index ON records(name,type);
CREATE INDEX domain_id ON records(domain_id);
COMMIT;

It does not help.

I noticed many other problems to:
$ dig +norec test.net @127.0.0.1 mx

; <<>> DiG 9.7.1-P2 <<>> +norec test.net @127.0.0.1 mx
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 9213
;; flags: qr aa; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 0

;; QUESTION SECTION:
;test.net.                      IN      MX

;; Query time: 2 msec
;; SERVER: 127.0.0.1#53(127.0.0.1)
;; WHEN: Sat Jan 29 01:32:02 2011
;; MSG SIZE  rcvd: 26

$ dig +norec test.net. @127.0.0.1 ns

; <<>> DiG 9.7.1-P2 <<>> +norec test.net. @127.0.0.1 ns
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 56125
;; flags: qr aa; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 0

;; QUESTION SECTION:
;test.net.                      IN      NS

;; Query time: 0 msec
;; SERVER: 127.0.0.1#53(127.0.0.1)
;; WHEN: Sat Jan 29 01:32:32 2011
;; MSG SIZE  rcvd: 26

Something isn't right. :-(