<div dir="ltr">Hi again,<div><br></div><div>I've deleted the formatting (Hyper-links) to make the table more visible.<br><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

<div dir="ltr"><div><br></div><div>If I understand your question correctly, you want to add a new subdomain to your domain "<a href="http://annoying.com" target="_blank">annoying.com</a>"</div><div><br></div>
<div>It's enough to add a new "A" record and not "NS" in your case, like bellow:</div>
<div><br></div><div><br></div><div><font face="courier new, monospace"><span style="font-size:13px">| name              | type | content                                                              |</span><br style="font-size:13px">



<span style="font-size:13px">+-------------------+------+---</span><span style="font-size:13px">------------------------------</span><span style="font-size:13px">------------------------------</span><span style="font-size:13px">-------+</span><div>


<br style="font-size:13px">
<span style="font-size:13px">| </span><a href="http://annoying.com">annoying.com</a><span style="font-size:13px">      | SOA  | </span><a href="http://ns0.ninefold.com">ns0.ninefold.com</a><span style="font-size:13px"> </span><a href="http://hostmaster.annoying.com">hostmaster.annoying.com</a><span style="font-size:13px"> 7 10800 3600 604800 3600     |</span><br style="font-size:13px">



<span style="font-size:13px">| </span><a href="http://annoying.com">annoying.com</a><span style="font-size:13px">      | NS   | </span><a href="http://ns3.ninefold.com">ns3.ninefold.com</a><span style="font-size:13px">                                                     |</span></div>


</font></div>
<div><font face="courier new, monospace">| <a href="http://annoying.com">annoying.com</a><span style="font-size:13px">      | NS   | </span><a href="http://ns4.ninefold.com">ns4.ninefold.com</a><span style="font-size:13px">    </span><br style="font-size:13px">



<span style="font-size:13px">| sub1</span>.<a href="http://annoying.com">annoying.com</a><span style="font-size:13px"> | A    | </span>10.10.10.10<span style="font-size:13px">                                                           |</span><br style="font-size:13px">



<span style="font-size:13px">| sub2</span>.<a href="http://annoying.com">annoying.com</a><span style="font-size:13px"> | A    | </span>10.10.10.11<span style="font-size:13px">                                                          |</span><br style="font-size:13px">



<span style="font-size:13px">+-------------------+------+---</span><span style="font-size:13px">------------------------------</span><span style="font-size:13px">------------------------------</span><span style="font-size:13px">-------+</span><br>



</font></div><div><span style="font-family:arial,sans-serif;font-size:13px"><br></span></div><div><span style="font-family:arial,sans-serif;font-size:13px">For NS records, you don't have to put anything before "<a href="http://annoying.com" target="_blank">annoying.com</a>" in "name" field, you should put the FQDN name of the NS server in the "content".</span></div>



<div><span style="font-family:arial,sans-serif;font-size:13px">That means, the NS record for "<a href="http://annoying.com" target="_blank">annoying.com</a>" is the "<a href="http://ns3.annoying.com" target="_blank">ns3.annoying.com</a>".</span></div>



<div><span style="font-family:arial,sans-serif;font-size:13px"><br></span></div><div>I hope I could help a little bit :)</div><div><br></div><div>Mohamed</div><div><span style="font-family:arial,sans-serif;font-size:13px"><br>



</span></div><div><span style="font-family:arial,sans-serif;font-size:13px"><br></span></div></div><div class="gmail_extra"><br clear="all"><div><div dir="ltr">---<br><br>Mohamed Brahimi<br>Infrastructure Engineer and Unix, Linux, Windows Administrator <br>



MVS (z Series), Unix/Linux, Windows<br>E-mail: <a href="http://mohamed.brahimi.ma" target="_blank">mohamed.brahimi.ma</a>@<a href="http://gmail.com" target="_blank">gmail.com</a><br></div></div><div><div>
<br><br><div class="gmail_quote">On Fri, Jul 26, 2013 at 1:03 AM,  <span dir="ltr"><<a href="mailto:pdns-users-request@mailman.powerdns.com" target="_blank">pdns-users-request@mailman.powerdns.com</a>></span> wrote:<br>



<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send Pdns-users mailing list submissions to<br>
        <a href="mailto:pdns-users@mailman.powerdns.com" target="_blank">pdns-users@mailman.powerdns.com</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
        <a href="http://mailman.powerdns.com/mailman/listinfo/pdns-users" target="_blank">http://mailman.powerdns.com/mailman/listinfo/pdns-users</a><br>
or, via email, send a message with subject or body 'help' to<br>
        <a href="mailto:pdns-users-request@mailman.powerdns.com" target="_blank">pdns-users-request@mailman.powerdns.com</a><br>
<br>
You can reach the person managing the list at<br>
        <a href="mailto:pdns-users-owner@mailman.powerdns.com" target="_blank">pdns-users-owner@mailman.powerdns.com</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Pdns-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
   1. Re: What is a domain? (Marc Haber)<br>
   2. Re: updated patch to improve SQL db AXFR performance<br>
      (<a href="mailto:ktm@rice.edu" target="_blank">ktm@rice.edu</a>)<br>
   3. Re: What is a domain? (Wolfgang Faust)<br>
   4. Issue with subdoamin delegation and AFXR (Luca Salvatore)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Thu, 25 Jul 2013 12:06:46 +0200<br>
From: Marc Haber <<a href="mailto:mh%2Bpdns-users@zugschlus.de" target="_blank">mh+pdns-users@zugschlus.de</a>><br>
To: "<a href="mailto:pdns-users@mailman.powerdns.com" target="_blank">pdns-users@mailman.powerdns.com</a>"<br>
        <<a href="mailto:pdns-users@mailman.powerdns.com" target="_blank">pdns-users@mailman.powerdns.com</a>><br>
Subject: Re: [Pdns-users] What is a domain?<br>
Message-ID: <<a href="mailto:20130725100646.GA17290@torres.zugschlus.de" target="_blank">20130725100646.GA17290@torres.zugschlus.de</a>><br>
Content-Type: text/plain; charset=utf-8<br>
<br>
On Thu, Jul 25, 2013 at 09:45:13AM +0200, Stefan Schmidt wrote:<br>
> On Thu, Jul 25, 2013 at 8:08 AM, Marc Haber <<a href="mailto:mh%2Bpdns-users@zugschlus.de" target="_blank">mh+pdns-users@zugschlus.de</a>>wrote:<br>
> > > If it matters, I'm going to be using native replication to minimize<br>
> > > delays for updates. I've set up a MySQL cluster with a slave on the<br>
> > > same system as the PowerDNS server.<br>
> ><br>
> > If you're talking native MySQL replication as opposed to native DNS<br>
> > replication, your domain table have "master" in the type field for all<br>
> > zones.<br>
><br>
> Actually that would be 'NATIVE'.<br>
> When you have 'MASTER' in the domains table PowerDNS will send notifies to<br>
> all NS records in the zone apex provided that master=yes in pdns.conf.<br>
> Likewise you'd need slave=yes and 'SLAVE' in the domains table to enable<br>
> slave mode in PowerDNS where it reacts to such notifies and tries to AXFR<br>
> the zone from the master IP.<br>
<br>
You're right, of course. Idiot me.<br>
<br>
Greetings<br>
Marc<br>
<br>
--<br>
-----------------------------------------------------------------------------<br>
Marc Haber         | "I don't trust Computers. They | Mailadresse im Header<br>
Mannheim, Germany  |  lose things."    Winona Ryder | Fon: *49 621 31958061<br>
Nordisch by Nature |  How to make an American Quilt | Fax: *49 621 31958062<br>
<br>
<br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Thu, 25 Jul 2013 09:00:25 -0500<br>
From: "<a href="mailto:ktm@rice.edu" target="_blank">ktm@rice.edu</a>" <<a href="mailto:ktm@rice.edu" target="_blank">ktm@rice.edu</a>><br>
To: <a href="mailto:pdns-users@mailman.powerdns.com" target="_blank">pdns-users@mailman.powerdns.com</a><br>
Subject: Re: [Pdns-users] updated patch to improve SQL db AXFR<br>
        performance<br>
Message-ID: <<a href="mailto:20130725140025.GB3001@aart.rice.edu" target="_blank">20130725140025.GB3001@aart.rice.edu</a>><br>
Content-Type: text/plain; charset=us-ascii<br>
<br>
Argh! I forgot to include one patch in the posted patchset.<br>
Here it is:<br>
<br>
-------------------------<br>
--- pdns-3.3/pdns/dnsbackend.hh 2013-05-16 07:55:13.000000000 -0500<br>
+++ pdns-3.3-FINALIZEAXFR/pdns/dnsbackend.hh    2013-07-11 20:05:43.697847786 -0500<br>
@@ -181,7 +181,7 @@<br>
   }<br>
<br>
   //! commits the transaction started by startTransaction<br>
-  virtual bool commitTransaction()<br>
+  virtual bool commitTransaction(int id=-1)<br>
   {<br>
     return false;<br>
   }<br>
-------------------------<br>
<br>
Regards,<br>
Ken<br>
<br>
<br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Thu, 25 Jul 2013 10:05:41 -0400<br>
From: Wolfgang Faust <<a href="mailto:wolfgangmcq@gmail.com" target="_blank">wolfgangmcq@gmail.com</a>><br>
To: Peter van Dijk <<a href="mailto:peter.van.dijk@netherlabs.nl" target="_blank">peter.van.dijk@netherlabs.nl</a>><br>
Cc: pdns-users Users <<a href="mailto:pdns-users@mailman.powerdns.com" target="_blank">pdns-users@mailman.powerdns.com</a>><br>
Subject: Re: [Pdns-users] What is a domain?<br>
Message-ID:<br>
        <CAJvjBNY66AYWLuvNMPbM8L4=<a href="mailto:y2VtwbSMCo5ywHUXWzx9-7kZZA@mail.gmail.com" target="_blank">y2VtwbSMCo5ywHUXWzx9-7kZZA@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
Thanks for all the replies. Now I have a couple more questions: * Is the<br>
<a href="http://records.id" target="_blank">records.id</a> field used for anything? My records table is actually going to<br>
be a view onto a complex set of joins, unions, and cartesian joins, and<br>
trying to give each of the resulting records a unique id would be a major<br>
pain. * What are all the fields in the domains table for? For native<br>
replication, are they needed, or can I leave them out of the schema? The<br>
documentation seems to imply that I only need the name, id, and<br>
type='NATIVE' fields for native replication.<br>
<br>
(Sorry, I misrouted this before. I forgot to reply all, as this list works<br>
differently from most I use.)<br>
On Jul 25, 2013 5:27 AM, "Peter van Dijk" <<a href="mailto:peter.van.dijk@netherlabs.nl" target="_blank">peter.van.dijk@netherlabs.nl</a>><br>
wrote:<br>
<br>
> Hello,<br>
><br>
> On Jul 25, 2013, at 8:08 , Marc Haber wrote:<br>
><br>
> >> The documentation<br>
> >> (<a href="http://doc.powerdns.com/html/generic-mypgsql-backends.html" target="_blank">http://doc.powerdns.com/html/generic-mypgsql-backends.html</a>) is quite<br>
> >> good on explaining this for the `records` table, but rather sparse on<br>
> >> explanations for the `domains` table. The closest I can come is ?3.9<br>
> >> 'Native operation', which seems to imply that it's possible to drop<br>
> >> the foreign key constraint entirely and not use the domains table at<br>
> >> all.<br>
> ><br>
> > It does indeed suggest that. I have never used PowerDNS this way though.<br>
><br>
><br>
> It no longer suggests that :)<br>
><br>
> Kind regards,<br>
> --<br>
> Peter van Dijk<br>
> Netherlabs Computer Consulting BV - <a href="http://www.netherlabs.nl/" target="_blank">http://www.netherlabs.nl/</a><br>
><br>
><br>
> _______________________________________________<br>
> Pdns-users mailing list<br>
> <a href="mailto:Pdns-users@mailman.powerdns.com" target="_blank">Pdns-users@mailman.powerdns.com</a><br>
> <a href="http://mailman.powerdns.com/mailman/listinfo/pdns-users" target="_blank">http://mailman.powerdns.com/mailman/listinfo/pdns-users</a><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://mailman.powerdns.com/pipermail/pdns-users/attachments/20130725/964dcf09/attachment-0001.html" target="_blank">http://mailman.powerdns.com/pipermail/pdns-users/attachments/20130725/964dcf09/attachment-0001.html</a>><br>




<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Fri, 26 Jul 2013 09:03:06 +1000<br>
From: Luca Salvatore <<a href="mailto:Luca@ninefold.com" target="_blank">Luca@ninefold.com</a>><br>
To: "'<a href="mailto:pdns-users@mailman.powerdns.com" target="_blank">pdns-users@mailman.powerdns.com</a>'"<br>
        <<a href="mailto:pdns-users@mailman.powerdns.com" target="_blank">pdns-users@mailman.powerdns.com</a>><br>
Subject: [Pdns-users] Issue with subdoamin delegation and AFXR<br>
Message-ID:<br>
        <<a href="mailto:D16D8905A64EE64CA9FEA8B367EC1BED0A39DD93B0@MTVMEXM02.workgroup.macquarie.net.au" target="_blank">D16D8905A64EE64CA9FEA8B367EC1BED0A39DD93B0@MTVMEXM02.workgroup.macquarie.net.au</a>><br>
<br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
I have hit a very weird issue that I need help me.<br>
<br>
So, I'm trying to delegate a subdomain from my PDNS server to my slaves.<br>
I have the parent domain delegated without any problems at all.<br>
Let's call the domain '<a href="http://annoying.com" target="_blank">annoying.com</a>'<br>
<br>
I can delegate the parent domain <a href="http://annoying.com" target="_blank">annoying.com</a> with no issues. The records look like this:<br>
<br>
| name             | type | content                                                              |<br>
+------------------+------+----------------------------------------------------------------------+<br>
| <a href="http://annoying.com" target="_blank">annoying.com</a>      | SOA  | <a href="http://ns0.ninefold.com" target="_blank">ns0.ninefold.com</a> <a href="http://hostmaster.annoying.com" target="_blank">hostmaster.annoying.com</a> 7 10800 3600 604800 3600     |<br>




| <a href="http://annoying.com" target="_blank">annoying.com</a>      | NS   | <a href="http://ns3.ninefold.com" target="_blank">ns3.ninefold.com</a>                                                     |<br>
| <a href="http://annoying.com" target="_blank">annoying.com</a>      | NS   | <a href="http://ns4.ninefold.com" target="_blank">ns4.ninefold.com</a><br>
<br>
<br>
Now i want to create <a href="http://test.anoying.com" target="_blank">test.anoying.com</a> and delegate that to the same servers as above.  So now my records look like this:<br>
| name             | type | content                                                              |<br>
+------------------+------+----------------------------------------------------------------------+<br>
| <a href="http://annoying.com" target="_blank">annoying.com</a>      | SOA  | <a href="http://ns0.ninefold.com" target="_blank">ns0.ninefold.com</a> <a href="http://hostmaster.annoying.com" target="_blank">hostmaster.annoying.com</a> 7 10800 3600 604800 3600     |<br>




| <a href="http://annoying.com" target="_blank">annoying.com</a>      | NS   | <a href="http://ns3.ninefold.com" target="_blank">ns3.ninefold.com</a>                                                     |<br>
| <a href="http://test.annoying.com" target="_blank">test.annoying.com</a> | NS   | <a href="http://ns3.ninefold.com" target="_blank">ns3.ninefold.com</a>                                                     |<br>
| <a href="http://test.annoying.com" target="_blank">test.annoying.com</a> | NS   | <a href="http://ns4.ninefold.com" target="_blank">ns4.ninefold.com</a>                                                     |<br>
+------------------+------+----------------------------------------------------------------------+<br>
<br>
But this does not work.  In the pdns log file I get errors<br>
<br>
AXFR of domain '<a href="http://test.annoying.com" target="_blank">test.annoying.com</a>' initiated by '<a href="http://ns3.ninefold.com" target="_blank">ns3.ninefold.com</a>'<br>
AXFR of domain '<a href="http://test.annoying.com" target="_blank">test.annoying.com</a>' failed: not authoritative<br>
<br>
So why can I delegate the parent domain, but not a subdomain?<br>
<br>
Thanks<br>
<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://mailman.powerdns.com/pipermail/pdns-users/attachments/20130726/3a609a12/attachment.html" target="_blank">http://mailman.powerdns.com/pipermail/pdns-users/attachments/20130726/3a609a12/attachment.html</a>><br>




<br>
------------------------------<br>
<br>
_______________________________________________<br>
Pdns-users mailing list<br>
<a href="mailto:Pdns-users@mailman.powerdns.com" target="_blank">Pdns-users@mailman.powerdns.com</a><br>
<a href="http://mailman.powerdns.com/mailman/listinfo/pdns-users" target="_blank">http://mailman.powerdns.com/mailman/listinfo/pdns-users</a><br>
<br>
<br>
End of Pdns-users Digest, Vol 126, Issue 21<br>
*******************************************<br>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div></div></div>