<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html;
      charset=windows-1252">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    I scripted it.  I can't rely on pdns replication.  The supermaster
    won't tell a slave to delete a zone for instance.  Adding a new zone
    may or may not happen properly or in a timely manner.  Sometimes
    transfers just don't happen and even if they do, the signed zones
    won't work until they're rectified. Don't get me started on
    dnsdist.  So to that end, I do:<br>
    <br>
    <br>
    <br>
    <tt>#!/bin/bash</tt><tt><br>
    </tt><tt># getdns.sh</tt><tt><br>
    </tt><tt>mysqldump -u root -p<password> -h <my database
      host> --opt --databases powerdns >/tmp/pdns.dump.sql</tt><tt><br>
    </tt><tt><br>
    </tt><tt>mysql -u root -p<password> powerdns
      </tmp/pdns.dump.sql</tt><tt><br>
    </tt><tt>mysql -u root -p<password> powerdns
      </usr/local/bin/pdns.sql</tt><tt><br>
    </tt><tt>/usr/bin/pdnsutil rectify-all-zones</tt><tt><br>
    </tt><br>
    <br>
    pdns.sql contains.<br>
    <br>
    <tt>USE powerdns;</tt><tt><br>
    </tt><tt>UPDATE domains SET type = 'SLAVE';</tt><tt><br>
    </tt><tt>UPDATE domains SET master = '<my primary pdns host>';</tt><tt><br>
    </tt><br>
    <br>
    <br>
    <div class="moz-cite-prefix">On 8/5/19 7:54 AM, frank+pdns--- via
      Pdns-users wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:C6A1B52A-8E9A-4A1C-A513-FB8929CC2C0A@louwers.be">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      Hi Thomas,
      <div class=""><br class="">
      </div>
      <div class="">A zone transfer will only include the contents of
        that particular zone, so I am a bit confused by your question.
        Could you rephrase it? (Or give an example how you would
        configure this in a another nameserver?)</div>
      <div class=""><br class="">
      </div>
      <div class="">Frank<br class="">
        <div class="">
          <div dir="auto" style="word-wrap: break-word;
            -webkit-nbsp-mode: space; line-break: after-white-space;"
            class="">
            <div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
              font-family: "Avenir Next"; font-size: 13px;
              font-style: normal; font-variant-caps: normal;
              font-weight: normal; letter-spacing: normal; text-align:
              start; text-indent: 0px; text-transform: none;
              white-space: normal; word-spacing: 0px;
              -webkit-text-stroke-width: 0px; text-decoration: none;">Frank
              Louwers<br class="">
              PowerDNS Certified Consultant @ <a
                href="http://Kiwazo.be" class="" moz-do-not-send="true">Kiwazo.be</a><br
                class="">
              <br class="">
            </div>
            <div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
              font-family: "Avenir Next"; font-size: 13px;
              font-style: normal; font-variant-caps: normal;
              font-weight: normal; letter-spacing: normal; text-align:
              start; text-indent: 0px; text-transform: none;
              white-space: normal; word-spacing: 0px;
              -webkit-text-stroke-width: 0px; text-decoration: none;"
              class=""><br class="">
            </div>
            <br class="Apple-interchange-newline">
          </div>
          <br class="Apple-interchange-newline">
        </div>
        <div><br class="">
          <blockquote type="cite" class="">
            <div class="">On 5 Aug 2019, at 13:49, Stanford Mings <<a
                href="mailto:stanford@tech.vi" class=""
                moz-do-not-send="true">stanford@tech.vi</a>> wrote:</div>
            <br class="Apple-interchange-newline">
            <div class="">
              <div dir="ltr" class="">
                <div dir="ltr" class="">Hello All,
                  <div class=""><br class="">
                  </div>
                  <div class="">This is a newbie question, so forgive
                    me.</div>
                  <div class=""><br class="">
                  </div>
                  <div class="">How do I configure PDNS to return all
                    domains in a zone transfer ?</div>
                  <div class=""><br class="" clear="all">
                    <div class="">
                      <div dir="ltr" class="gmail_signature">
                        <div dir="ltr" class="">
                          <div class="">
                            <div dir="ltr" class="">Stanford T. Mings
                              Jr. ~Technologist  ~ <br class="">
                              <a href="mailto:stanford@tech.vi"
                                style="color:rgb(17,85,204)"
                                target="_blank" class=""
                                moz-do-not-send="true">stanford@tech.vi</a> ~ <a
                                href="http://www.tech.vi/"
                                style="color:rgb(17,85,204)"
                                target="_blank" class=""
                                moz-do-not-send="true">http://www.tech.vi</a> ~ <span
                                style="font-size:small" class="">786-269-5718</span><br
                                style="font-size:small" class="">
                              <br class="">
                              VI Technical Services, LLC ~ 9160 Estate
                              Thomas ~ <br class="">
                              Suite 195 ~ St. Thomas, VI, 00802<br
                                class="">
                            </div>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
              _______________________________________________<br
                class="">
              Pdns-users mailing list<br class="">
              <a href="mailto:Pdns-users@mailman.powerdns.com" class=""
                moz-do-not-send="true">Pdns-users@mailman.powerdns.com</a><br
                class="">
              <a
                href="https://mailman.powerdns.com/mailman/listinfo/pdns-users"
                class="" moz-do-not-send="true">https://mailman.powerdns.com/mailman/listinfo/pdns-users</a><br
                class="">
            </div>
          </blockquote>
        </div>
        <br class="">
      </div>
      <div class="">
        <div dir="auto" style="word-wrap: break-word; -webkit-nbsp-mode:
          space; line-break: after-white-space;" class="">
          <div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
            font-family: "Avenir Next"; font-size: 13px;
            font-style: normal; font-variant-caps: normal; font-weight:
            normal; letter-spacing: normal; text-align: start;
            text-indent: 0px; text-transform: none; white-space: normal;
            word-spacing: 0px; -webkit-text-stroke-width: 0px;
            text-decoration: none;">Frank Louwers<br class="">
            PowerDNS Certified Consultant @ <a href="http://Kiwazo.be"
              class="" moz-do-not-send="true">Kiwazo.be</a><br class="">
            <br class="">
          </div>
          <div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
            font-family: "Avenir Next"; font-size: 13px;
            font-style: normal; font-variant-caps: normal; font-weight:
            normal; letter-spacing: normal; text-align: start;
            text-indent: 0px; text-transform: none; white-space: normal;
            word-spacing: 0px; -webkit-text-stroke-width: 0px;
            text-decoration: none;" class=""><br class="">
          </div>
          <br class="Apple-interchange-newline">
        </div>
        <br class="Apple-interchange-newline">
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <pre class="moz-quote-pre" wrap="">_______________________________________________
Pdns-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Pdns-users@mailman.powerdns.com">Pdns-users@mailman.powerdns.com</a>
<a class="moz-txt-link-freetext" href="https://mailman.powerdns.com/mailman/listinfo/pdns-users">https://mailman.powerdns.com/mailman/listinfo/pdns-users</a>
</pre>
    </blockquote>
    <br>
    <div class="moz-signature">-- <br>
      Best Regards
      Curtis Maurand<br>
      <a class="moz-txt-link-freetext" href="mailto:curtis@maurand.com">mailto:curtis@maurand.com</a></div>
  </body>
</html>