<div dir="ltr">That does clear up a couple of points, I appreciate it! What I am trying to do is limit the response of records via the query so I need to edit the query itself. In essence I'm doing DNS Round-robin but limiting the responses. If I have a record with 100 IPs associated, when the db is queried I only want to return "X" (lets say 3) of the possible 100 returned. Conversely, I can write the query and call it out ...it's just the where to do it (for both cases) that's alluding me.<div><br></div><div>-S </div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Sep 9, 2019 at 12:33 PM Brian Candler <<a href="mailto:b.candler@pobox.com" target="_blank">b.candler@pobox.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF">
<div class="gmail-m_-8634689985399048227gmail-m_7924822359005734753moz-cite-prefix">On 09/09/2019 16:30, Shawn Augenstein
wrote:<br>
</div>
<blockquote type="cite">
<div><font face="arial, sans-serif">##################################</font></div>
<div><font face="arial, sans-serif">#gmysql-launchname-queryname
Override the default queries with custom parameters</font></div>
<div><font face="arial, sans-serif"><br>
</font></div>
<div><font face="arial, sans-serif">gmysql-launchname-queryname=SELECT
content,ttl,prio,type,domain_id,disabled,name,auth FROM
records WHERE disabled=0 and type=? and name=? LIMIT 5 OFFSET
5</font></div>
<div><font face="arial, sans-serif"><br>
</font></div>
<div><font face="arial, sans-serif"><br>
</font></div>
<div><font face="arial, sans-serif">Using the Basic Query as my
template</font></div>
<div>
<div><font face="arial, sans-serif">#################################</font></div>
<div><font face="arial, sans-serif"># gmysql-basic-query<span class="gmail-m_-8634689985399048227gmail-m_7924822359005734753gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>Basic
query</font></div>
<div><font face="arial, sans-serif">#</font></div>
<div><font face="arial, sans-serif"># gmysql-basic-query=SELECT
content,ttl,prio,type,domain_id,disabled,name,auth FROM
records WHERE disabled=0 and type=? and name=?</font></div>
</div>
<div><font face="arial, sans-serif"><br>
</font></div>
</blockquote>
<p>The only reference I can find to <font face="arial, sans-serif"><code style="box-sizing:border-box;padding:0.2em 0.4em;margin:0px;background-color:rgba(27,31,35,0.0470588);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(36,41,46)">gmysql-launchname-queryname</code></font>
is here: <a href="https://github.com/PowerDNS/pdns/wiki/gmysql-gpgsql-FAQ" target="_blank">https://github.com/PowerDNS/pdns/wiki/gmysql-gpgsql-FAQ</a></p>
<p>I'm not an expert in this area, but I don't think there's any
option with that name: I think it means</p>
<p> <gmysql-launchname>-<queryname></p>
<p>That is, if you've specified --launch=gmysql when you start pdns
(or "launch+=gmysql" in pdns.conf), and you want to set the
basic-query, then the setting is "gmysql-basic-query"</p>
<p>There's a more explicit example in the main documentation:<br>
</p>
<p><a href="https://doc.powerdns.com/authoritative/backends/generic-sql.html" target="_blank">https://doc.powerdns.com/authoritative/backends/generic-sql.html</a></p>
<p>which shows:</p>
<pre style="box-sizing:border-box;overflow:auto;font-family:Consolas,monospace;font-size:15px;display:block;padding:14px 0px 14px 20px;margin:20px 0px;line-height:23px;word-break:break-all;color:rgb(51,51,51);background-color:rgb(255,255,255);border-width:0px 0px 0px 2px;border-style:solid;border-color:rgb(238,238,238);border-top-left-radius:4px;border-top-right-radius:4px;border-bottom-right-radius:4px;border-bottom-left-radius:4px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;word-spacing:0px">gmysql-basic-query=SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=?</pre>
<p>Does that help?<br>
</p>
</div>
</blockquote></div>