I've got to the bottom of it, sort of. Firstly, only dig seems to cause this problem If I try it with nslookup on Windows, it seemed to work.
It works if I put in a manual serial number in the SOA records. Otherwise PowerDNS was putting out 0 a serial number in the SOA, which dig didn't like. Any idea how to get automatic serial numbers working? According to the manual: "If left at 0, the default, PDNS will perform an internal list of the domain to determine highest change_date field of all records within the zone, and use that as the zone serial number. " So what goes in the change_date field? I tried putting 20100526 as a numerical representation of now, but it was still putting out 0 as a serial number. David On 26 May 2010 12:21, David J Craigon <da...@craigon.co.uk> wrote: > DB schema is exactly as here: > > http://doc.powerdns.com/generic-mypgsql-backends.html > > with the only difference that I have put these tables in a schema > "dns" in the database, since I want to use the database for other > things too. > > These are my database queries- they are exactly the same as the > defaults, except for adding dns. to the beginning of every table name. > > # database queries > > gpgsql-basic-query=select content,ttl,prio,type,domain_id,name from > dns.records where type='%s' and name='%s' > > gpgsql-id-query=select content,ttl,prio,type,domain_id,name from > dns.records where type='%s' and name='%s' and domain_id=%d > > gpgsql-any-query=select content,ttl,prio,type,domain_id,name from > dns.records where name='%s' > > gpgsql-any-id-query=select content,ttl,prio,type,domain_id,name from > dns.records where name='%s' and domain_id=%d > > gpgsql-list-query=select content,ttl,prio,type,domain_id,name from > dns.records where domain_id=%d > > > > gpgsql-master-zone-query=select master from dns.domains where > name='%s' and type='SLAVE' > > gpgsql-info-zone-query=select > id,name,master,last_check,notified_serial,type from dns.domains where > name='%s' > > gpgsql-info-all-slaves-query=select id,name,master,last_check,type > from dns.domains where type='SLAVE' > > gpgsql-supermaster-query=select account from dns.supermasters where > ip='%s' and nameserver='%s'); > > gpgsql-insert-slave-query=insert into dns.domains > (type,name,master,account) values('SLAVE','%s','%s','%s') > > gpgsql-insert-record-query=insert into dns.records > (content,ttl,prio,type,domain_id,name) values > ('%s',%d,%d,'%s',%d,'%s') > > gpgsql-update-serial-query=update dns.domains set notified_serial=%d where > id=%d > > gpgsql-update-lastcheck-query=update dns.domains set > notified_serial=%d where id=%d > > gpgsql-info-all-master-query=select > id,name,master,last_check,notified_serial,type from dns.domains where > type='MASTER' > > gpgsql-delete-zone-query=delete from dns.records where domain_id=%d > > > > gpgsql-wildcard-query=select content,ttl,prio,type,domain_id,name from > dns.records where type='%s' and name like '%s' > > gpgsql-wildcard-id-query=select content,ttl,prio,type,domain_id,name > from dns.records where type='%s' and name like '%s' and domain_id=%d > > gpgsql-wildcard-any-query=select content,ttl,prio,type,domain_id,name > from dns.records where name like '%s' > > gpgsql-wildcard-any-id-query=select > content,ttl,prio,type,domain_id,name from dns.records where name='%s' > and domain_id=%d > > > David > > On 26 May 2010 12:00, bert hubert <bert.hub...@netherlabs.nl> wrote: >> On Wed, May 26, 2010 at 11:59:31AM +0100, David J Craigon wrote: >>> Adding a TTL doesn't help. Without one, ordinary queries are responded >>> to with the default TTL. >> >> Ok - can you show all your queries from the configuration? And your db >> schema? >> >> Bert >> > _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users