[Pdns-users] need help with pdns authoritative + gmysql backend with mysql group replication-based servers

[fsantiago at garbage-juice.com]

hello pdns world,

i've been here before but it's been many years, and i certainly did it 
differently back then and now i'm stuck again;

i have 2 servers, intended to be a pair of authoritative dns servers. 
they both match these general specs:
Ubuntu 24.04.2 LTS
pdns-server 4.9.4-1pdns.noble
pdns-backend-bind 4.9.4-1pdns.noble
pdns-backend-mysql 4.9.4-1pdns.noble (I'm using this backend)
mysql  Ver 8.0.41-0ubuntu0.24.04.1

mysql wise, the 2 servers are replicating their data using mysql group 
replication. pdns itself is NOT doing anything primary -vs- secondary; 
they're just going to host native zones.

the default powerdns mysql db was created using the sql template 
included with pdns. i used the default pdns db and db user names 
('powerdns'), along with my chosen password.

in the pdns conf file, i've only specified those values that are NOT 
default.

for reference, i've tried managing my servers with pdnsutil cli and with 
poweradmin (the github project), same failure either way.

right now starting with a bind zone file (syntax/structure confirmed 
with named-checkzone), i've attempted to create my 1st zone with 3 
different commands:

1.> pdnsutil load-zone <my zone name> <my bind zone file>
or
2.> zone2sql --named-conf=<my zone file> --gmysql | mysql -u powerdns -p 
powerdns

and i also tried just creating an empty zone with command:

3.> pdnsutil create-zone <zone name>

in all cases above, they error out.

error from attempt 1:
Apr 23 20:48:38 [bindbackend] Done parsing domains, 0 rejected, 0 new, 0 
removed
Creating '<my zone name>'
Error: Database failed to start transaction for domain '<my zone name>': 
Could not execute mysql statement: delete from records where 
domain_id=?: The table does not comply with the requirements by an 
external plugin.

attempt 2:
Enter password:
Fatal error: Error in bind configuration '<my zone file>' on line 41: 
syntax error

attempt 3:
Apr 23 11:29:58 [bindbackend] Done parsing domains, 0 rejected, 0 new, 0 
removed
Creating empty zone '<my zone name>'
Error: Database failed to start transaction for domain '<my zone name>': 
Could not execute mysql statement: delete from records where 
domain_id=?: The table does not comply with the requirements by an 
external plugin.

in all 3 cases, plus when i try via poweradmin, it does create what 
appears to be an incomplete / partial sql record in the domains table:

id
name
master
last_check
type
notified_serial
account
options
catalog

43
<zone name>
NULL
NATIVE
NULL
NULL
NULL

so now, all that being said, what am i doing wrong? Thank you for your 
help and please let me know if you need any more information from me. 
thanks again.

--

Fabian Santiago
fsantiago at garbage-juice.com
Vernon Twp., NJ, USA