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.cand...@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. > > >
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
