Using PowerDNS with MySQL

florius

• August 07, 2017 14:40

Hello. I'd like to use PowerDNS with MySQL but I can't get it working. I installed pDNS as follow: I first removed cpanel-pdns as I need pdns-backend-mysql. Then I removed pdns as this is a dependancy of pdns-backend-mysql. I then reinstalled cpanel-pdns via WHM. Then I setup pDNS as follow: setuid=pdns setgid=pdns launch=gmysql gmysql-host=localhost gmysql-user=powerdns gmysql-password=MYPASSWORD gmysql-dbname=powerdns The plan is using database replication with my nameservers. I'll be using multiple cPanel and DirectAdmin servers as well for my nameservers. However the issue I'm having is that cPanel doesn't create the records in the database. Well, PowerDNS doesn't... Is this even possible, or am I doing something wrong? Is someone able to shed a light on this for me? Thank you!

• 

  cPanelMichael

  • August 08, 2017 15:13

  Hello, PowerDNS is not provided with MySQL support in cPanel. I encourage you to vote and add feedback to the existing feature request for this if it's something you'd like to see added to the product: MySQL Backend for PowerDNS Thank you.

  0
• 

  florius

  • August 09, 2017 18:03

  Hello, PowerDNS is not provided with MySQL support in cPanel. I encourage you to vote and add feedback to the existing feature request for this if it's something you'd like to see added to the product: MySQL Backend for PowerDNS Thank you.

  
  Hi Michael. Perfect. Do you have a manual of some sort on how to use BIND and synch it with PowerDNS by chance?

  0
• 

  cPanelMichael

  • August 10, 2017 16:16

  Hi Michael. Perfect. Do you have a manual of some sort on how to use BIND and synch it with PowerDNS by chance?

  
  Hello, I couldn't find any specific examples of this type of setup, however PowerDNS does offer documentation on "Master/Slave Setup Requirements" at: Native, Master and Slave Operation You may also want to reach out to a system administrator for help with this type of custom setup. We provide a list of companies offering system administration services on the following URL: System Administration Services | cPanel Forums Thank you.

  0
• 

  florius

  • August 19, 2017 18:45

  Thanks Michael. After careful reading the first article I was able to figure it out. I had to manually add a slave zone to my PowerDNS nameserver. After that I was able to synch. But as far as I'm aware, zone transferring should cut out all of the manual work. How can I let my cPanel server add the SOA record manually after which it's able to synch? I tried running it manually: # rndc refresh example.com in external WARNING: key file (/etc/rndc.key) exists, but using default configuration file (/etc/rndc.conf) rndc: 'refresh' failed: failure not a slave or stub zone Setting the zone to slave doesn't work, as Named refuses to start even then: /etc/named.conf:100: zone 'example.com': missing 'masters' entry. Any way you could help me out? Thanks a lot!

  0
• 

  cPanelMichael

  • August 22, 2017 16:05

  Hello, This is an unsupported configuration so it falls outside our scope of support. You may want to reach out to a system administrator for assistance if you do not receive additional user-feedback on this topic. We provide a list of companies offering system administration services on the following URL: System Administration Services | cPanel Forums Thank you.

  0

Please sign in to leave a comment.