Re: need help with pdns authoritative + gmysql backend with mysql group replication-based servers
Miod Vallat via Pdns-users <[email protected]> Thu, 24 Apr 2025 06:44:13 +0200
| Newsgroups | gmane.network.dns.powerdns.user |
|---|---|
| Message-ID | <[email protected]> |
Hello, [...] > 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. > 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. The PowerDNS mysql database schema is currently not compatible with mysql group replication. You will need to disable this feature for PowerDNS to work. > attempt 2: > Enter password: > Fatal error: Error in bind configuration '<my zone file>' on line 41: > syntax error This means that the bind zone file parser in PowerDNS is stricter than bind's, or lacks support for a particular bind construct. Can you share the actual zone file you are using (or at least the first 50 lines of it) so that we can investigate further? Regards, Miod