[Pdns-users] Reverse DNS - sqlite backend

[Andy Rabagliati]

Folks,

  We have a small block - 196.21.78.16/28 - and a hidden master
  nameserver for that block.

  Our upstream has entries like this in the zone file :-

16-31.78.21.196.in-addr.arpa. 86400 IN  NS      disa.tenet.ac.za.
16-31.78.21.196.in-addr.arpa. 86400 IN  NS      kingklip.aims.ac.za.

18.78.21.196.in-addr.arpa. 86400 IN     CNAME 18.16-31.78.21.196.in-addr.arpa.
20.78.21.196.in-addr.arpa. 86400 IN     CNAME 20.16-31.78.21.196.in-addr.arpa.

  And we slave the whole class C from them as well.

  I have a PowerDNS server managing Forward for aims.ac.za, using the LDAP backend.

  I have added the sqlite backend, and want to use that as the slave server.

  I have this in sqlite :-

sqlite> .dump
BEGIN TRANSACTION;
create table domains ( id INTEGER PRIMARY KEY, name VARCHAR(255) NOT NULL, master VARCHAR(20) 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,'78.21.196.in-addr.arpa','196.21.78.18',NULL,'SLAVE',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 );
create table supermasters ( ip VARCHAR(25) NOT NULL, nameserver VARCHAR(255) NOT NULL, 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;


  But I get errors like this after

	pdns_server --config-name=external --daemon=no  --slave  --loglevel=9

Jan 16 18:25:07 gsqlite: connection to '/var/lib/powerdns/pdns.sqlite' succesful
Jan 16 18:25:07 No serial for '78.21.196.in-addr.arpa' found - zone is missing?
Jan 16 18:25:07 AXFR started for '78.21.196.in-addr.arpa', transaction started
Jan 16 18:25:07 Remote 196.21.78.18 sneaked in out-of-zone data 'kingklip.aims.ac.za' during AXFR of zone '78.21.196.in-addr.arpa'


  I also expected to see more stuff in the sqlite database - like the whole class C ?

  Isn't that where the slave zone should appear ? Does that "sneak"
  message indicate a refusal to load any info into the database ?
  (to test, I am slaving off my old bind9 nameserver - is that the problem?)

  The database is owned by user "pdns", and I am running on Ubuntu Dapper.

Cheers,    Andy!