[Pdns-users] Checking constraints on MySQL records and auto-rectify

2013-01-29 Thread Jan-Piet Mens
On long, solitary drives I get crazy ideas, and at a beastly hour this morning, it happened again: It ought to be possible (famous last words) to create a set of MySQL triggers and a couple of User Defined Functions (UDF) which ensure that data entered into PowerDNS' MysQL database tables (in part

Re: [Pdns-users] Record delegation to 3rd party NS

2013-01-29 Thread James Cloos
> "iic" == ivan i@vvpgroup com writes: iic> | 31 | mydomain.com | NULL | NULL | NATIVE |NULL | NULL| Change that NATIVE to MASTER to permit AXFR mirroring to your secondaries. -JimC -- James Cloos OpenPGP: 1024D/ED7DAEA6 ___

Re: [Pdns-users] Record delegation to 3rd party NS

2013-01-29 Thread Stefan Schmidt
On Tue, Jan 29, 2013 at 4:25 PM, iva...@vvpgroup.com wrote: > Hi, Hi Ivan, >> SELECT * FROM domains WHERE id = 31; > > ++--++++-+-+ > | id | name | master | last_check | type | notified_serial | > account | > ++---

Re: [Pdns-users] Record delegation to 3rd party NS

2013-01-29 Thread iva...@vvpgroup.com
Hi, SELECT * FROM domains WHERE id = 31; ++--++++-+-+ | id | name | master | last_check | type | notified_serial | account | ++--++++-+-+ | 31 | mydom

Re: [Pdns-users] Record delegation to 3rd party NS

2013-01-29 Thread Jan-Piet Mens
> And how about > > SELECT * FROM domains WHERE name='jabber.mydomain.com' Sorry, I meant SELECT * FROM domains WHERE id = 31; Also, a dig @yourpdns jabber.mydomain.com any might help. -JP ___ Pdns-users mailing l

Re: [Pdns-users] Record delegation to 3rd party NS

2013-01-29 Thread Jan-Piet Mens
> Of course! Output of "SELECT * FROM records WHERE > name='jabber.mydomain.com'": And how about SELECT * FROM domains WHERE name='jabber.mydomain.com' ? -JP ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.

Re: [Pdns-users] Record delegation to 3rd party NS

2013-01-29 Thread iva...@vvpgroup.com
Hi, Of course! Output of "SELECT * FROM records WHERE name='jabber.mydomain.com'": +-+---+-+--++--+--+--+-+ | id | domain_id | name| type | content| ttl | prio | auth | change_date | +-

[Pdns-users] Record delegation to 3rd party NS

2013-01-29 Thread iva...@vvpgroup.com
Hi All, Using PowerDNS 64-bit debian package, version 3.2-1 from http://www.powerdns.com/content/downloads.html with gMySQL backend and NO DNSSEC. Operating system: Ubuntu Server 12.04 LTS 64-bit. Trying to set up DNS record delegation to 3rd party NS. I have domain mydoman.com, which is served