[Pdns-users] gmysql backend and stored procedures

[Max Lock]

Thanks Norbert (and others)

 I'll give this a shot today :)

 -Cheers Max.



-----Original Message-----
From: Norbert Sendetzky <norbert at linuxnetworks.de>
To: pdns-users at mailman.powerdns.com
Subject: Re: [Pdns-users] gmysql backend and stored procedures
Date: Mon, 18 Aug 2008 22:48:01 +0200


Hi Max

>  I'm trying to integrate powerdns with our legacy mysql database here. I
> have to create a union of three tables to get something that powerdns
> will use. This takes about 0.4 seconds per query, and hammers the cpu.
> due to needing to use the %s replacements in the config file in multiple
> places in a more optimised version of my queries I've had to use stored
> procedures that take 0.14 seconds to run (still not good enough, but
> getting better). The problem is I can run the query just fine by hand,
> but powerdns times out with the valid entry below, and gives and error
> for anything that should go to the recursor?

The gmysql backend doesn't support stored procedures. If you use the OpenDBX 
backend with the mysql driver instead, your queries will work.


Norbert
_______________________________________________
Pdns-users mailing list
Pdns-users at mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20080819/cbac1e99/attachment-0001.html>