Re: [Pdns-users] PDNS Recursor - Fail to start - Main proces exist

2015-11-22 Thread Federico Olivieri
Hi, Thanks for your reply. I'm quite new in load-balancing in DNS (and in DNS i general) and I'm trying to understand what it could be the best practice for dnsdist. I have a server pdns recursor and a second dns recursor (still with power dns) where I would send all doggy traffic that I receive

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

2015-11-22 Thread a b
If I recall correctly, every backend has its own schema. Unfortunately, this is not immediately obvious when one starts using pdns. The good news is, the "oracle" backend gets some serious abuse, it's well tested, rock solid in its operation, and in my opinion, the schema is optimized for it. Yo

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

2015-11-22 Thread a b
I did not INSERT TTL values for the A records, and had it not been for "another pair of eyes" scrutinizing what I did, I would be running around in circles for who knows how long. What drove this home is when I looked at all the other A records I added way, way back... and they all had TTL valu

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
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. # pdnssec check-zone dmz Checked

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