Hi! Your version has prepared statements patch in it, which means that the SQL syntax has been changed. You no longer use %s and %d, you use ? and statement variable placeholder.
You can see all the SQLs with pdns_server --launch=gmysql --config | grep gmysql Aki On Mon, Mar 16, 2015 at 03:21:02PM -0300, Filipe Cifali wrote: > Sorry, I forgot to mention that: > > pdns_control version > git > > MySQL 5.5.42 > > I'm running on Gentoo latest, > > ]# head /usr/local/install/pdns/config.log > This file contains any messages produced by compilers while > running configure, to aid debugging if configure makes a mistake. > > It was created by pdns configure git, which was > generated by GNU Autoconf 2.69. Invocation command line was > > $ ./configure --with-modules=bind gmysql pipe --without-lua > > The command output: > > pdns_server --launch=gmysql --config | grep gmysql-basic-query > Mar 16 15:20:33 Reading random entropy from '/dev/urandom' > # 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=? > > > > > On Mon, Mar 16, 2015 at 3:13 PM, Aki Tuomi <[email protected]> wrote: > > > On Mon, Mar 16, 2015 at 01:05:26PM -0300, Filipe Cifali wrote: > > > Hello all, > > > > > > I just subscribed to this mailing, I'm Filipe and I have some experience > > > with Bind/Named setups with MySQL. Since they both are good but not > > optimal > > > I was searching for a replacement and I came across PowerDNS and NSD, > > right > > > now I'm trying to do a custom layout for the MySQL queries since I use > > them > > > on Bind with the driver, which is quite easy, writing the queries.I came > > > across the custom queries in the docs: > > > https://doc.powerdns.com/md/authoritative/backend-generic-mypgsql/ > > > > > > And wrote a simple query: > > > > > > gmysql-basic-query=SELECT data,ttl,mx_priority,type,zone,host FROM > > DNSTable > > > WHERE type='%s' AND zone='%s' AND active=1 > > > > > > > Are you using which version of PowerDNS? Can you check > > > > pdns_server --launch=gmysql --config | grep gmysql-basic-query > > > > Aki Tuomi > > > > > > -- > [ ]'s > > Filipe Cifali Stangler > _______________________________________________ > Pdns-users mailing list > [email protected] > http://mailman.powerdns.com/mailman/listinfo/pdns-users _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
