Title: Datanet Email
Hello Max,
It is a pdns problem (at least for gmysql backend... i don't know the
opendbx). It doesn't use CLIENT_MULTI_STATEMENT flag when connecting to
mysql server. To call mysql stored procedures from c/c++ you have to
use this flag because stored procedures return mult
Hmm, seems that OpenDBX fails too. :(
Aug 19 11:52:23 ns3 pdns[17227]: [OpendbxBackend] execStmt: Unable to
execute query - PROCEDURE dns.pdns_any_query can't return a result set
in the given context
Aug 19 11:52:23 ns3 pdns[17227]: Backend error: Error: odbx_query()
failed
I'm thinking it's a m
Thanks Norbert (and others)
I'll give this a shot today :)
-Cheers Max.
-Original Message-
From: Norbert Sendetzky <[EMAIL PROTECTED]>
To: pdns-users@mailman.powerdns.com
Subject: Re: [Pdns-users] gmysql backend and stored procedures
Date: Mon, 18 Aug 2008 22:48:01 +02
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 multi
Hi folks,
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
