<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 09/09/2019 16:30, Shawn Augenstein
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAAtTNS-R37uLV2Ejp7zYoK5Xd37FASc7LxjMbmUXQW7x-d+xBA@mail.gmail.com">
<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-Apple-tab-span" style="white-space:pre"> </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">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">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; overflow-wrap: normal; 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-image: initial; border-radius: 4px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">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>
</body>
</html>