[Pdns-users] New to PowerDNS

Filipe Cifali cifali.filipe at gmail.com
Mon Mar 16 19:54:38 UTC 2015


Yeah I'm switching now to 3.4.3 so I can use the docs, thanks for
everything :)

This patch helped me to find out what queries were failing:
https://github.com/PowerDNS/pdns/pull/2359.patch

I'm only switching because 'stable-env' but I'll post more if I need more
info

On Mon, Mar 16, 2015 at 3:30 PM, Aki Tuomi <cmouse at youzen.ext.b2.fi> wrote:

> 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 <cmouse at youzen.ext.b2.fi>
> 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
> > Pdns-users at mailman.powerdns.com
> > http://mailman.powerdns.com/mailman/listinfo/pdns-users
>
>


-- 
[ ]'s

Filipe Cifali Stangler
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20150316/82966f30/attachment-0001.html>


More information about the Pdns-users mailing list