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

2020-08-28 Thread Xan Charbonnet via Pdns-users
Hello Peter, On 8/27/20 2:19 PM, Peter van Dijk via Pdns-users wrote: ? It would be great if you could include the definition of a stored procedure that works with our default schema, and the pdns.conf query override to use that procedure. Thanks! I've put some detailed steps-to-reproduce in t

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

2020-08-27 Thread Peter van Dijk via Pdns-users
Hello Xan, On Wed, 2020-08-26 at 11:29 -0500, Xan Charbonnet via Pdns-users wrote: > When I move from MariaDB 10.1 to MariaDB 10.2 (or greater), all three > pdns versions fail with the "Prepared statement contains no metadata" > error. Masood's experience leads me to believe that the same break

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

2020-08-26 Thread Xan Charbonnet via Pdns-users
Apologies for the out-of-context post: I was attempting to respond to this message: https://mailman.powerdns.com/pipermail/pdns-users/2020-July/026762.html and clearly I messed up! ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mail

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

2020-08-26 Thread Xan Charbonnet via Pdns-users
I believe I am having the same problem as you, Masood. It seems to not be related to the PowerDNS version but rather to the version of MySQL. Using stored procedures with the pdns MySQL backend works fine for me on Debian Stretch with MariaDB 10.1 on pdns versions 4.0.3, 4.1.6, and 4.3.0. I

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

2020-07-06 Thread Masood Rahim via Pdns-users
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 Bust