Thanks Norbert (and others) I'll give this a shot today :)
-Cheers Max. -----Original Message----- From: Norbert Sendetzky <[EMAIL PROTECTED]> To: [email protected] 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 [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
_______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
