Rocky Linux 8: Can't determine path to MySQL schema

[Sispheor]

Hello there 👋

I'm trying to deploy the thing on Rocky 8.5.

Inventory conf:

pdns_install_repo: ""

PowerDNS version

pdns_server --version
Mar 16 09:21:40 PowerDNS Authoritative Server 4.6.0 (C) 2001-2022 PowerDNS.COM BV
Mar 16 09:21:40 Using 64-bits mode. Built using gcc 8.5.0 20210514 (Red Hat 8.5.0-4) on Jan 25 2022 16:50:33 by mockbuild@localhost.
Mar 16 09:21:40 PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the terms of the GPL version 2.
Mar 16 09:21:40 Features: libcrypto-ecdsa libcrypto-ed25519 libcrypto-ed448 libcrypto-eddsa lua lua-records PKCS#11 protobuf sodium curl 
Mar 16 09:21:40 Built-in modules: 
Mar 16 09:21:40 Configured with: " '--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib64' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/var/lib' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--enable-option-checking=fatal' '--sysconfdir=/etc/pdns' '--disable-static' '--disable-dependency-tracking' '--disable-silent-rules' '--with-modules=' '--with-lua=luajit' '--with-dynmodules= bind gmysql gpgsql pipe remote ldap lua2 gsqlite3 tinydns' '--enable-tools' '--with-libsodium' '--enable-unit-tests' '--enable-lua-records' '--enable-experimental-pkcs11' '--enable-systemd' '--enable-ixfrdist' 'build_alias=x86_64-redhat-linux-gnu' 'host_alias=x86_64-redhat-linux-gnu' 'CFLAGS=-O2 -g -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -grecord-gcc-switches -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=generic -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection' 'LDFLAGS=-Wl,-z,relro  -Wl,-z,now -specs=/usr/lib/rpm/redhat/redhat-hardened-ld' 'CPPFLAGS=-DLDAP_DEPRECATED' 'CXXFLAGS=-O2 -g -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -grecord-gcc-switches -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=generic -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection' 'PKG_CONFIG_PATH=:/usr/lib64/pkgconfig:/usr/share/pkgconfig'"

Here is the issue I have.

TASK [PowerDNS.pdns : Determine location of the SQL file] **********************************************************************************************************************************************************************************************************************************************************************************************************************************
fatal: [ns2.si.gre.hpecorp.net]: FAILED! => {"changed": false, "cmd": "for p in /usr/share/doc/pdns-backend-mysql-4.6.0/schema.mysql.sql /usr/share/doc/pdns-backend-mysql/schema.mysql.sql /usr/share/pdns-backend-mysql/schema/schema.mysql.sql /usr/share/dbconfig-common/data/pdns-backend-mysql/install/mysql /usr/share/doc/powerdns/schema.mysql.sql; do\n  if [ -f $p ]; then\n    echo $p\n    exit 0\n  fi\ndone\necho \"Can't determine path to MySQL schema\">&2\nexit 1\n", "delta": "0:00:00.007071", "end": "2022-03-16 09:16:14.409430", "msg": "non-zero return code", "rc": 1, "start": "2022-03-16 09:16:14.402359", "stderr": "Can't determine path to MySQL schema", "stderr_lines": ["Can't determine path to MySQL schema"], "stdout": "", "stdout_lines": []}
fatal: [ns1.si.gre.hpecorp.net]: FAILED! => {"changed": false, "cmd": "for p in /usr/share/doc/pdns-backend-mysql-4.6.0/schema.mysql.sql /usr/share/doc/pdns-backend-mysql/schema.mysql.sql /usr/share/pdns-backend-mysql/schema/schema.mysql.sql /usr/share/dbconfig-common/data/pdns-backend-mysql/install/mysql /usr/share/doc/powerdns/schema.mysql.sql; do\n  if [ -f $p ]; then\n    echo $p\n    exit 0\n  fi\ndone\necho \"Can't determine path to MySQL schema\">&2\nexit 1\n", "delta": "0:00:00.008073", "end": "2022-03-16 09:16:14.556212", "msg": "non-zero return code", "rc": 1, "start": "2022-03-16 09:16:14.548139", "stderr": "Can't determine path to MySQL schema", "stderr_lines": ["Can't determine path to MySQL schema"], "stdout": "", "stdout_lines": []}

Path in the lookup script:

• /usr/share/doc/pdns-backend-mysql-4.6.0/schema.mysql.sql
• /usr/share/doc/pdns-backend-mysql/schema.mysql.sql
• /usr/share/pdns-backend-mysql/schema/schema.mysql.sql
• /usr/share/dbconfig-common/data/pdns-backend-mysql/install/mysql
• /usr/share/doc/powerdns/schema.mysql.sql

The real path on the system:

ls /usr/share/doc/pdns/
3.4.0_to_4.1.0_schema.mysql.sql  4.1.0_to_4.2.0_schema.mysql.sql  4.2.0_to_4.3.0_schema.mysql.sql  dnssec-3.x_to_3.4.0_schema.mysql.sql  enable-foreign-keys.mysql.sql  nodnssec-3.x_to_3.4.0_schema.mysql.sql  README  schema.mysql.sql