Package: pdns-backend-mysql Version: 4.0.3-1+deb9u2 Severity: important Tags: patch
Dear Maintainer, PowerDNS versions 4.x (the versions in Jessie, Stretch, Buster, and Sid) fails to handle stored procedures. When a stored procedure is used as one of the PowerDNS queries, it works the first time, but subsequent queries return really weird results. It appears that these results are from some kind of cache, but they're simply broken. The troubleshooting described at this link mirrors my diagnostic process: https://github.com/PowerDNS/pdns/issues/6115 The fix: https://github.com/PowerDNS/pdns/pull/6134/files was merged 5 days ago into upstream. There has not yet been an upstream release containing this fix. Because it has been accepted upstream, I don't believe anything special needs to be done for Buster or Sid, other than keeping up with upstream. I'm asking you to consider updating the version in Stretch (and possibly the one in Jessie). While I don't believe this is a security issue, PowerDNS in these distributions is plainly broken when used with stored procedures. Nobody will be inconvenienced by this change in behavior, and it will allow PowerDNS to work as documented and intended. I successfully merged this patch into the Debian version of PowerDNS from Stretch for my own local use. It worked great. It would be really nice if the official package could include this fix. -- System Information: Debian Release: 9.3 APT prefers stable APT policy: (1000, 'stable'), (900, 'stable'), (750, 'testing') Architecture: amd64 (x86_64) Kernel: Linux 4.9.0-5-amd64 (SMP w/1 CPU core) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages pdns-backend-mysql depends on: ii dbconfig-common 2.0.8 ii dbconfig-mysql 2.0.8 ii debconf [debconf-2.0] 1.5.61 ii libc6 2.24-11+deb9u1 ii libgcc1 1:6.3.0-18 ii libmariadbclient18 10.1.26-0+deb9u1 ii libstdc++6 6.3.0-18 ii pdns-server 4.0.3-1+deb9u2 ii ucf 3.0036 ii zlib1g 1:1.2.8.dfsg-5 pdns-backend-mysql recommends no packages. Versions of packages pdns-backend-mysql suggests: pn default-mysql-server <none> -- debconf information excluded