<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.18.3">
</HEAD>
<BODY>
Thanks Norbert (and others)<BR>
<BR>
I'll give this a shot today :)<BR>
<BR>
-Cheers Max.<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<BR>
</TD>
</TR>
</TABLE>
<BR>
<BR>
-----Original Message-----<BR>
<B>From</B>: Norbert Sendetzky <<A HREF="mailto:Norbert%20Sendetzky%20%3cnorbert@linuxnetworks.de%3e">norbert@linuxnetworks.de</A>><BR>
<B>To</B>: <A HREF="mailto:pdns-users@mailman.powerdns.com">pdns-users@mailman.powerdns.com</A><BR>
<B>Subject</B>: Re: [Pdns-users] gmysql backend and stored procedures<BR>
<B>Date</B>: Mon, 18 Aug 2008 22:48:01 +0200<BR>
<BR>
<PRE>
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
<A HREF="mailto:Pdns-users@mailman.powerdns.com">Pdns-users@mailman.powerdns.com</A>
<A HREF="http://mailman.powerdns.com/mailman/listinfo/pdns-users">http://mailman.powerdns.com/mailman/listinfo/pdns-users</A>
</PRE>
</BODY>
</HTML>