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 multiple result sets. I
am using mysql stored procedures with gmysql backen after modifying the
source code and rebuilding powerdns from source.
Pavel
Max Lock wrote:
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 mysql problem as opposed to a pdns problem.
-Max
> The gmysql backend doesn't support stored procedures. If you use the OpenDBX
> backend with the mysql driver instead, your queries will work.
_______________________________________________
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
