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
fsanti...@garbage-juice.com
Vernon Twp., NJ, USA
_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users
