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. :-( _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users