Re: [Pdns-users] Multiple A records cause AXFR failure

2015-11-22 Thread a b
13:35 To: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] Multiple A records cause AXFR failure Ahh, so it's Oracle, yeah I should have known from the SQL> prompt. I didn't know the Oracle backend uses other table names, an euh.. interesting choice. Never really looked at th

Re: [Pdns-users] Multiple A records cause AXFR failure

2015-11-22 Thread a b
ll had TTL values. Thank you. This is why I love the this mailing list. From: Philippe [m_phili...@rocketmail.com] Sent: Sunday, November 22, 2015 13:30 To: a b Subject: AW: [Pdns-users] Multiple A records cause AXFR failure May be a stupid question, but did

Re: [Pdns-users] Multiple A records cause AXFR failure

2015-11-22 Thread leen
On 2015-11-22 12:19, a b wrote: Good idea! pdnssec check-zone dmz Error: Received NULL where a value was expected SQL> delete from records where (id = 16 or id = 66); 2 rows deleted. SQL> update zones set serial = 2015112209 where name = 'dmz'; 1 row updated. SQL> commit; Commit complete.

Re: [Pdns-users] Multiple A records cause AXFR failure

2015-11-22 Thread a b
Sent: Sunday, November 22, 2015 12:01 To: l...@consolejunkie.net Cc: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] Multiple A records cause AXFR failure You can also try pdnssec check-zone zonename to find out why it's broken. It work

Re: [Pdns-users] Multiple A records cause AXFR failure

2015-11-22 Thread Aki Tuomi
You can also try pdnssec check-zone zonename to find out why it's broken. It works even if you aren't using dnssec. Aki On Sun, Nov 22, 2015 at 11:37:25AM +0100, l...@consolejunkie.net wrote: > Hi a b, > > Based on your queries below, you seem to not be using the default > table schema and quer

Re: [Pdns-users] Multiple A records cause AXFR failure

2015-11-22 Thread a b
> Based on your queries below, you seem to not be using the default table > schema and queries: > https://doc.powerdns.com/md/authoritative/backend-generic-mypgsql/#regular-queries >Can you post your query configuration and schema ? Actually, this describes my schema much better: https://doc.po

Re: [Pdns-users] Multiple A records cause AXFR failure

2015-11-22 Thread a b
> Based on your queries below, you seem to not be using the default table > schema and queries: > https://doc.powerdns.com/md/authoritative/backend-generic-mypgsql/#regular-queries >Can you post your query configuration and schema ? That is because I am not using the "mypgsql", but the "oracle"

Re: [Pdns-users] Multiple A records cause AXFR failure

2015-11-22 Thread leen
Hi a b, Based on your queries below, you seem to not be using the default table schema and queries: https://doc.powerdns.com/md/authoritative/backend-generic-mypgsql/#regular-queries Can you post your query configuration and schema ? Seems to me it might be related to that. Have a good day,

[Pdns-users] Multiple A records cause AXFR failure

2015-11-22 Thread a b
I added two A records, as follows: SQL> insert into records(id, zone_id, fqdn, content, type) values(16, (select id from zones where name = 'dmz'), 'ntp.dmz', '172.16.2.2', 'A'); 1 row created. SQL> insert into records(id, zone_id, fqdn, content, type) values(66, (select id from zones where na