<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hello Max,<br>
<br>
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 multiple result sets. I
am using mysql stored procedures with gmysql backen after modifying the
source code and rebuilding powerdns from source.<br>
<br>
Pavel<br>
<br>
<br>
Max Lock wrote:
<blockquote cite="mid:1219143336.5827.6.camel@maxwell-desktop"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="GENERATOR" content="GtkHTML/3.18.3">
<title>Datanet Email</title>
<br>
Hmm, seems that OpenDBX fails too. :(<br>
<br>
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<br>
Aug 19 11:52:23 ns3 pdns[17227]: Backend error: Error: odbx_query()
failed<br>
<br>
I'm thinking it's a mysql problem as opposed to a pdns problem.<br>
<br>
-Max<br>
<br>
<pre>> The gmysql backend doesn't support stored procedures. If you use the OpenDBX
> backend with the mysql driver instead, your queries will work.
</pre>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
Pdns-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Pdns-users@mailman.powerdns.com">Pdns-users@mailman.powerdns.com</a>
<a class="moz-txt-link-freetext" href="http://mailman.powerdns.com/mailman/listinfo/pdns-users">http://mailman.powerdns.com/mailman/listinfo/pdns-users</a>
</pre>
</blockquote>
<br>
</body>
</html>