Prepare MySQL or MariaDB Database for PowerDNS Admin

Kaelnor edited this page Oct 11, 2018 · 3 revisions

This guide will show you how to prepare a MySQL or MariaDB database for PowerDNS-Admin.

Step-by-step instructions

  1. ivan@ubuntu:~$ mysql -u root -p (then enter your MySQL/MariaDB root users password)
  2. mysql> CREATE DATABASE powerdnsadmin CHARACTER SET utf8 COLLATE utf8_general_ci;
  3. mysql> GRANT ALL PRIVILEGES ON powerdnsadmin.* TO 'pdnsadminuser'@'%' IDENTIFIED BY 'p4ssw0rd';
  4. mysql> FLUSH PRIVILEGES;
  5. mysql> quit

NOTE:

If you plan to manage large zones, you may encounter some issues while applying changes. This is due to PowerDNS-Admin trying to insert the entire modified zone into the column history.detail.

Using MySQL/MariaDB, this column is created by default as TEXT and thus limited to 65,535 characters.

Solution:

Convert the column to MEDIUMTEXT:

  • USE powerdnsadmin;
  • ALTER TABLE history MODIFY detail MEDIUMTEXT;
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.