<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Oct 17, 2020, at 3:38 PM, Brian Candler <<a href="mailto:b.candler@pobox.com" class="">b.candler@pobox.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" class="">
<div class="">
<div class="moz-cite-prefix">On 17/10/2020 20:54, Nicholas Williams
wrote:<br class="">
</div>
<blockquote type="cite" cite="mid:A23F1D4E-AB1C-4BBB-BC6F-79880FA05472@nicholaswilliams.net" class="">
<pre class="moz-quote-pre" wrap="">First, the concern. I run MySQL in master/slave replication mode. I have a master MySQL server that I write to, and the PowerDNS servers connect to the slaves, not the master. Is there some way to tell PowerDNS to send updates to the master, or will I have to change one of the servers to connect to the master and explicitly send updates only to that server?</pre>
</blockquote><p class="">For DDNS updates, you'd need a powerDNS server which talks to the
master. It can be hidden from the rest of the Internet, and you
can use <a moz-do-not-send="true" href="https://docs.powerdns.com/authoritative/dnsupdate.html#dnsupdate-configuration-options" class="">forward-dnsupdate</a>
on the slaves to forward to the master.</p></div></div></blockquote>That would be nice, but unless I’m misunderstanding forward-dnsupdates, I don’t think I can use it. I don’t have a “master” DNS server and “slave” DNS servers. I just have several native DNS servers that all query MySQL directly. I rely completely on MySQL replication to distribute DNS updates. So I think I’ll have to send my updates directly to a single DNS server that talks to the master. But maybe I’m wrong.<br class=""><blockquote type="cite" class=""><div class=""><div class=""><p class="">There is a howto for the ISC dhcp server here:
<a class="moz-txt-link-freetext" href="https://docs.powerdns.com/authoritative/dnsupdate.html#dns-update-how-to-setup-dyndns-rfc2136-with-dhcpd">https://docs.powerdns.com/authoritative/dnsupdate.html#dns-update-how-to-setup-dyndns-rfc2136-with-dhcpd</a><br class="">
</p><p class="">It is of course moot if VyOS doesn't support DDNS updates: e.g.
<a class="moz-txt-link-freetext" href="https://forum.vyos.io/t/dhcp-service-and-dns-updates/245">https://forum.vyos.io/t/dhcp-service-and-dns-updates/245</a> (but the
last post was from 2016)</p></div></div></blockquote><div>Yep, I found that DHCPD how-to, and then some other searching led me to instructions on how to apply those configurations to UniFi’s EdgeOS, and then some searching through VyOS’s documentation led me to conclude that you can also do this in VyOS. Hooray! To be certain, I wrote up a forum post to clarify some things and posted it here, if anyone is interested:</div><div><br class=""></div><div><a href="https://forum.vyos.io/t/dhcp-multiple-shared-networks-vs-multiple-subnets-global-params-vs-shared-network-params-vs-subnet-params/6045" class="">https://forum.vyos.io/t/dhcp-multiple-shared-networks-vs-multiple-subnets-global-params-vs-shared-network-params-vs-subnet-params/6045</a></div><blockquote type="cite" class=""><div class=""><div class=""><p class="">
</p>
<blockquote type="cite" cite="mid:A23F1D4E-AB1C-4BBB-BC6F-79880FA05472@nicholaswilliams.net" class="">
<pre class="moz-quote-pre" wrap="">
Second, my question: Is there anyway to customize the queries that PowerDNS uses to update the records? Specifically, I would like to add a flag to records that were added or updated with Dynamic DNS so that my administrative console can differentiate between those and explicit records.</pre>
</blockquote><p class="">If the master server is *only* handling DDNS updates, then you
should be able to customise the query appropriately.</p><p class=""><a class="moz-txt-link-freetext" href="https://doc.powerdns.com/authoritative/backends/generic-sql.html#specifying-queries">https://doc.powerdns.com/authoritative/backends/generic-sql.html#specifying-queries</a></p><div class=""><br class=""></div>
</div>
</div></blockquote><br class=""></div><div>It might be easier to just do the opposite, and set a flag in my admin console for all domains managed by the admin console, instead of trying to set a flag in PowerDNS dynamic updates.</div><div><br class=""></div><div>Thanks,</div><div><br class=""></div><div>Nick</div><br class=""></body></html>