WHM DNS-only with PowerDNS and MySQL 8

dragos03

Member
Jun 7, 2018
16
3
3
Bucuresti
cPanel Access Level
DataCenter Provider
Hello,

I want to replace our old DNS cluster, so I provisioned 2 DNS-only servers with PowerDNS and MySQL 8.
After I added them to our DNS cluster on 2 of our shared hosting servers, PowerDNS fails to start on both nodes.

It throws a number of errors regarding invalid zones, similar to: pdns_server: Trying to insert non-zone data

Then it fails with these errors:
Jun 19 13:36:47 powerdns2 pdns_server: Caught an exception instantiating a backend, cleaning up
Jun 19 13:36:47 powerdns2 pdns_server: Exiting because of STL error: empty dnsnames aren't part of anything
Jun 19 13:36:47 powerdns2 pdns_server: Exiting because of STL error: empty dnsnames aren't part of anything

What can be the cause? Is the "backend" in the logs the MySQL service, maybe the setup is not fully compatible with MySQL 8?

Thank you,
DRagos
 

ffeingol

Well-Known Member
PartnerNOC
Nov 9, 2001
426
99
328
cPanel Access Level
DataCenter Provider
We have not switched to PDNS yet, but I did not think that cPanel's version used a MySQL back end. I though they just ready the bind zone files for non-DNSSEC stuff.
 
  • Like
Reactions: cPanelLauren

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,297
1,251
313
Houston
@ffeingol is correct cPanel's pdns uses a bind-backend not MySQL though there are some files stored in MySQL when DNSSEC is present. Was your ticket addressed @dragos03