[Pdns-users] Edit gMySQL Queries

[Shawn Augenstein]

Crushing it Brian!

Looks like I'm 99% of the way there. It *seems* I can update the query
with pdns_server
--gmysql-basic-query=

I just have to dial in the query (I believe...) unless the non-option is
referring to the LIMIT itself

# pdns_server --gmysql-basic-query=SELECT
content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE
disabled=0 and type=? and name=? LIMIT=5
Sep 10 14:11:13 Reading random entropy from '/dev/urandom'
Sep 10 14:11:13 Loading '/usr/lib/x86_64-linux-gnu/pdns/libbindbackend.so'
Sep 10 14:11:13 Loading '/usr/lib/x86_64-linux-gnu/pdns/libgmysqlbackend.so'
Fatal: non-option on the command line, perhaps a '--setting=123' statement
missed the '='?

-S

On Tue, Sep 10, 2019 at 7:12 AM Brian Candler <b.candler at pobox.com> wrote:

> On 10/09/2019 14:07, Shawn Augenstein wrote:
> > How does one edit the gmysql queries that pdns uses?
>
>
> https://doc.powerdns.com/authoritative/backends/generic-sql.html#specifying-queries
>
> To see the existing queries powerdns uses, run "pdns_server --config"
>
> If you don't see them, add "--launch gmysql" to that command line.
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20190910/95dcba06/attachment.htm>