[Pdns-users] Edit Queries gmysql

[Shawn Augenstein]

Understood however I seem to be a bit dense in understanding.

What I attempted o do in pdfs.conf is:

##################################
#gmysql-launchname-queryname   Override the default queries with custom
parameters

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


Using the Basic Query as my template
#################################
# gmysql-basic-query Basic query
#
# gmysql-basic-query=SELECT
content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE
disabled=0 and type=? and name=?


Unless what I need to do is:

##################################
#gmysql-launchname-queryname   Override the default queries with custom
parameters

gmysql-launchname-queryname=gmysql-basic-query
SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records
WHERE disabled=0 and type=? and name=? LIMIT 5 OFFSET 5

On Mon, Sep 9, 2019 at 8:38 AM Brian Candler <b.candler at pobox.com> wrote:

> On 09/09/2019 14:41, Shawn Augenstein wrote:
>
> I have a simple edit to the Basic Query that I'd like to Test and I am
> unsure of how to either 1. edit the basic query or where to add in the new
> one to be used.
>
> I've read the documentation and found, "you can override the default
> queries by specifying them as gmysql-launchname-queryname= in pdns.conf.
> You can find the default queries with pdns_server --launch=gmysql
> --config"
>
> ...but haven't found the info on where to actually edit / add. Any help
> that could be provided would be appreciated!!
>
> It says "in pdns.conf".  You will probably find that under /etc/powerdns/,
> and the order of entries in pdns.conf is not significant.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20190909/ae8194f3/attachment.htm>