[Pdns-users] Problem with stored procedure pdns 4.1.6-3

[Masood Rahim]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20200706/d7b72e4c/attachment.htm>