I am using Debian Buster and trying to call a mysql stored procedure via: gmysql-any-id-query=call getdns(?,?)
The stored procedure works fine on pdns 4.0.3-1 on Debian Stretch. When calling the stored procedure via the mysql console it returns the same results on both Buster and Stretch. On Buster I'm seeing the following in the logs: Jul 6 07:01:46 ns pdns_server[25975]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=? Jul 6 07:01:46 ns pdns_server[25975]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=? Jul 6 07:01:46 ns pdns_server[25975]: Query: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=? and domain_id=? Jul 6 07:01:46 ns pdns_server[25975]: Query: call getdns(?,?) Jul 6 07:01:46 ns pdns_server[25975]: Query: call getdns(?,?) Jul 6 07:01:46 ns pdns_server[25975]: Backend reported permanent error which prevented lookup (GSQLBackend get: Could not bind parameters to mysql statement: call getdns(?,?): Prepared statement contains no metadata), aborting Jul 6 07:01:46 ns pdns_server[25975]: Query: call getdns(?,?) Jul 6 07:01:46 ns pdns_server[25975]: Backend reported permanent error which prevented lookup (GSQLBackend get: Could not bind parameters to mysql statement: call getdns(?,?): Prepared statement contains no metadata), aborting Jul 6 07:01:46 ns pdns_server[25975]: Backend error: GSQLBackend get: Could not bind parameters to mysql statement: call getdns(?,?): Prepared statement contains no metadata On Buster I am using mysql 5.7.30 and on Stretch I am using mysql 5.6.30.
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
