Hi Xan, * Xan Charbonnet <x...@charbonnet.com> [200827 17:42]: > PowerDNS supports using stored procedures for its backend MySQL queries. > However, it seems > that when the database is MariaDB >= 10.2 (or MySQL >= 5.7), stored > procedures fail to work. > > I have tested this on Stretch, using three different PowerDNS versions: 4.0.3 > (from Stretch), > 4.1.6 (from Buster), and 4.3.0 (from Bullseye), all compiled on Stretch. > They all have the > same behavior: on MariaDB 10.1, stored procedures work great. On MariaDB > 10.2, calls to > procedures which return any rows give the error "Could not bind parameters to > mysql > statement". The various versions of MariaDB came from the MariaDB Debian > repositories. > > I have also tried this on a clean Bullseye test system, using the versions of > PowerDNS and > MariaDB which are native to Bullseye. Same problem. This is the system > where I'm running > reportbug.
I'm a bit puzzled by this. Debian has an autopkgtest that sets up MariaDB and pdns-server + pdns-backend-mysql. This (simple) test appears to work fine: https://ci.debian.net/packages/p/pdns/unstable/amd64/ As you can see in this list, even MariaDB 10.4 from experimental appears to work properly. There might be some additional info that we are missing here. Chris
