Install PowerDNS and PowerAdmin on Centos 7

This guide intends to teach you to Install PowerDNS and PowerAdmin on Centos 7. PowerDNS also known as pdns is a secure, scalable, and reliable software for DNS server solutions. Also, you can use PowerAdmin to manage your DNS servers from a graphical user interface.

This guide gives you the complete installation and configuration of PowerDNS and PowerAdmin using Apache, MariaDB, and PHP.

How To Install PowerDNS and PowerAdmin on Centos 7?

To complete PowerDNS installation and configuration, you need some requirements.

Requirements

First, you must have access to your server as a non-root user with sudo privileges. To do this, you can follow our guide on Initial Server Setup with Centos 7.

Then, you need to set up a basic firewall. For this purpose, you can follow this guide on Set Up a Firewall with FirewallD on CentOS 7.

Also, it would be best if you disabled SELinux on your Centos server. To do this, you can check this guide on How To Disable SELinux on Centos.

Now follow the steps below to complete your PowerDNS and PowerAdmin setup.

Step 1 – Install Epel and PHP Remi for PowerDNS

First, you must run the system update with the following command:

sudo yum update -y

Then, you must add the Epel repository and Remi repository on your server by using the commands below:

# sudo yum install epel-release -y
# sudo yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm -y

Also, use the following command to install the yum-utils on Centos 7:

sudo yum install yum-utils -y

Next, use the following PHP Remi command to enable PHP on your server:

sudo yum-config-manager --enable remi-php72

Step 2 – Install and Configure MariaDB for PowerDNS

At this point, you will need to install MariaDB as your database server. To do this, run the following command:

sudo yum install mariadb mariadb-server -y

When your installation is completed, start and enable the MariaDB service to start on boot:

# sudo systemctl start mariadb 
# sudo systemctl enable mariadb

Now run the MySQL security script to set a password for your MariaDB service:

sudo mysql_secure_installation

Answer the questions by default and set a password for your MySQL root user.

Note: The default version of MariaDB on Centos 7 is MariaDB 5, and it is an old version. To upgrade your MariaDB version, you can follow this guide on How To Upgrade MariaDB on Centos 7.

Create a PowerDNS Database and Database User

At this point, you need to log in to your MariaDB shell and create a database for PowerDNS installation and add a user to manage the database on Centos 7.

Log in to your MariaDB shell by using the command below:

sudo mysql -u root -p

From your MariaDB shell, create a database for PowerDNS, here we named it powerdb, you can choose your desired name:

MariaDB [(none)]> CREATE DATABASE powerdb;

Then, create a user to manage your PowerDNS DB and set a strong password for it, here we named it poweruser:

MariaDB [(none)]> CREATE USER 'poweruser' identified by 'strongpassword';

At this point, you need to grant all the permissions to your PowerDNS user and database on Centos 7:

MariaDB [(none)]> GRANT ALL PRIVILEGES ON powerdb.* to 'poweruser'@'localhost' identified by 'strongpassword';

Next, flush the privileges by using the following command:

MariaDB [(none)]> FLUSH PRIVILEGES; 

Create table structures for PowerDNS Database

At this point, you need to create table structures for your created DB. To do this, change your database to the PowerDNS DB with the command below:

MariaDB [(none)]> USE powerdb;

Then, run the following MySQL commands to create the table structures:

MariaDB [(none)]> CREATE TABLE domains (
   id                    INT AUTO_INCREMENT,
   name                  VARCHAR(255) NOT NULL,
   master                VARCHAR(128) DEFAULT NULL,
   last_check            INT DEFAULT NULL,
   type                  VARCHAR(6) NOT NULL,
   notified_serial       INT DEFAULT NULL,
   account               VARCHAR(40) DEFAULT NULL,
   PRIMARY KEY (id)
 ) Engine=InnoDB;
 
 CREATE UNIQUE INDEX name_index ON domains(name);
 
 
 CREATE TABLE records (
   id                    BIGINT AUTO_INCREMENT,
   domain_id             INT DEFAULT NULL,
   name                  VARCHAR(255) DEFAULT NULL,
   type                  VARCHAR(10) DEFAULT NULL,
   content               VARCHAR(64000) DEFAULT NULL,
  ttl                   INT DEFAULT NULL,
   prio                  INT DEFAULT NULL,
   change_date           INT DEFAULT NULL,
   disabled              TINYINT(1) DEFAULT 0,
   ordername             VARCHAR(255) BINARY DEFAULT NULL,
   auth                  TINYINT(1) DEFAULT 1,
   PRIMARY KEY (id)
 ) Engine=InnoDB;
 
 CREATE INDEX nametype_index ON records(name,type);
 CREATE INDEX domain_id ON records(domain_id);
 CREATE INDEX recordorder ON records (domain_id, ordername);
 
 
 CREATE TABLE supermasters (
   ip                    VARCHAR(64) NOT NULL,
   nameserver            VARCHAR(255) NOT NULL,
   account               VARCHAR(40) NOT NULL,
   PRIMARY KEY (ip, nameserver)
 ) Engine=InnoDB;
 
 
 CREATE TABLE comments (
   id                    INT AUTO_INCREMENT,
   domain_id             INT NOT NULL,
   name                  VARCHAR(255) NOT NULL,
   type                  VARCHAR(10) NOT NULL,
   modified_at           INT NOT NULL,
   account               VARCHAR(40) NOT NULL,
   comment               VARCHAR(64000) NOT NULL,
   PRIMARY KEY (id)
 ) Engine=InnoDB;
CREATE INDEX comments_domain_id_idx ON comments (domain_id);
 CREATE INDEX comments_name_type_idx ON comments (name, type);
 CREATE INDEX comments_order_idx ON comments (domain_id, modified_at);
 
 
 CREATE TABLE domainmetadata (
   id                    INT AUTO_INCREMENT,
   domain_id             INT NOT NULL,
   kind                  VARCHAR(32),
   content               TEXT,
   PRIMARY KEY (id)
 ) Engine=InnoDB;
 
 CREATE INDEX domainmetadata_idx ON domainmetadata (domain_id, kind);
 
 
 CREATE TABLE cryptokeys (
 id                    INT AUTO_INCREMENT,
   domain_id             INT NOT NULL,
   flags                 INT NOT NULL,
   active                BOOL,
   content               TEXT,
   PRIMARY KEY(id)
 ) Engine=InnoDB;
 
 CREATE INDEX domainidindex ON cryptokeys(domain_id);
 
 
 CREATE TABLE tsigkeys (
   id                    INT AUTO_INCREMENT,
   name                  VARCHAR(255),
   algorithm             VARCHAR(50),
   secret                VARCHAR(255),
   PRIMARY KEY (id)
 ) Engine=InnoDB;
 
 CREATE UNIQUE INDEX namealgoindex ON tsigkeys(name, algorithm);

When you are done, you can confirm your tables with the command below:

MariaDB [(none)]> SHOW TABLES;
Output
+-------------------+
| Tables_in_powerdb |
+-------------------+
| comments          |
| cryptokeys        |
| domainmetadata    |
| domains           |
| records           |
| supermasters      |
| tsigkeys          |
+-------------------+
7 rows in set (0.001 sec)

Finally, exit from your MariaDB shell:

MariaDB [(none)]> quit;

Step 3 – How To Install PowerDNS on Centos 7?

At this point, you can start to install PowerDNS and all the required packages on your server. To do this, run the following command:

sudo yum install pdns pdns-backend-mysql bind-utils -y

Now switch to your PowerDNS directory with the command below:

cd /etc/pdns/

Next, you need to edit your PowerDNS config file by using your desired text editor, here we use the vi editor:

sudo vi pdns.conf

By default, PowerDNS is using ‘bind‘ as the backend. So, you must comment ‘#’ in the front of the ‘launch=bind‘ configuration and paste your MySQL backend configuration as shown below:

#launch=bind

launch=gmysql
gmysql-host=localhost
gmysql-user=poweruser
gmysql-password=strongpassword
gmysql-dbname=powerdb

Note: Remember to change your database value.

When you are done, save and close the file.

Step 4 – How To Start PowerDNS Service on Centos 7?

Here you can start and enable your PowerDNS service by using the following commands:

# sudo systemctl start pdns 
# sudo systemctl enable pdns

Verify your PowerDNS service is active and running on Centos 7:

sudo systemctl status pdns
Output
● pdns.service - PowerDNS Authoritative Server
   Loaded: loaded (/usr/lib/systemd/system/pdns.service; enabled; vendor preset: disabled)
   Active: active (running) since Tue 2023-05-30 06:34:41 EDT; 11s ago
     Docs: man:pdns_server(1)
           man:pdns_control(1)
           https://doc.powerdns.com
 Main PID: 8982 (pdns_server)
   CGroup: /system.slice/pdns.service
           └─8982 /usr/sbin/pdns_server --guardian=no --daemon=no --disable-s...
...

Step 5 – Configure Firewall for PowerDNS

We assumed that you have enabled firewalld, now you need to allow the DNS service through the firewall by using the command below:

sudo firewall-cmd --add-service=dns --permanent

Reload the firewall to apply the new rules:

sudo firewall-cmd --reload

At this point, your PowerDNS installation and configuration are completed, you can proceed to the next step to set up your PowerDNS Admin dashboard.

For more information, you can visit the PowerDNS Documentation page.

Step 5 – How To Install PowerAdmin on Centos 7?

PowerAdmin is a web-based application for managing PowerDNS and it is based on PHP. So you need to install PHP, Apache, and PHP extensions with the command below:

sudo yum install httpd php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-mhash gettext -y

Then, install PHP pear DB by using the command below on Centos 7:

sudo pear install db
Output
downloading DB-1.11.0.tgz ...
Starting to download DB-1.11.0.tgz (132,549 bytes)
.............................done: 132,549 bytes
install ok: channel://pear.php.net/DB-1.11.0

Start and enable your httpd service:

# sudo systemctl start httpd 
# sudo systemctl enable httpd

Verify your httpd service is active and running on your Centos 7:

sudo systemctl status httpd
Output
● httpd.service - The Apache HTTP Server
   Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled; vendor preset: disabled)
   Active: active (running) since Tue 2023-05-30 06:40:52 EDT; 14s ago
     Docs: man:httpd(8)
           man:apachectl(8)
 Main PID: 9634 (httpd)
   Status: "Total requests: 0; Current requests/sec: 0; Current traffic:   0 B/sec"
   CGroup: /system.slice/httpd.service
...

Download PowerAdmin Source Code

At this point, you need to use the following command to download the PowerDNS Admin on Centos 7. First, switch to your HTML directory:

cd /var/www/html/

Then, use the following command to download the PowerAdmin:

sudo wget https://sourceforge.net/projects/poweradmin/files/poweradmin-2.2.1.tar.gz

Extract your downloaded file with the following command:

sudo tar xvf poweradmin-2.2.1.tar.gz

Then, move your extracted file to the following directory:

sudo mv poweradmin-2.2.1 /var/www/html/poweradmin/

Finally, you need to allow the HTTP and HTTPS protocols through the firewall:

# sudo firewall-cmd --add-service={http,https} --permanent
# sudo firewall-cmd --reload

Step 6 – How To Access PowerAdmin Dashboard on Centos 7?

At this point, you can continue your PowerDNS Admin installation on Centos 7 through the web interface. To do this, type your server’s IP address in your web browser followed by /poweradmin/install:

http://your-server-ip/poweradmin/install

You will see the step 1 installation of PowerAdmin, choose your desired language and click Go to step 2:

install powerdns admin

In Step 2 read the content and click Go to Step 3.

PowerDNS step 2

Next, you must enter your PowerDNS database credentials on Centos 7 and set a PowerAdmin administrator password and click Go to step 4:

powerdns admin step 3

Then, you need to enter a new user for PowerAdmin and set a password for it. Also, you need to set your hostmaster and nameservers and click Go to step 5.

powerdns admin step 4 on Rocky Linux 8

At this point, the installer will tell you that log in to your MariaDB shell and perform the task given to you. To do this, you can use the command below:

 sudo mysql -u root -p

Then, add the commands that you have seen from your installation step 5. When you are done, click Go to step 6.

poweradmin step 5

Here you need to make some changes to config-me.inc.php. Switch to the following directory:

cd /var/www/html/poweradmin

Now open the following file with your favorite text editor, here we use vi:

 vi inc/config.inc.php

From there you need to add the lines that you have got from the installer into the file. When you are done, save and close the file. And Click Go to step 7.

poweradmin step 6

Finish PowerAdmin Configuration

Next, If you want support for the URLs used by other dynamic DNS providers, run “cp install/htaccess.dist .htaccess” and enable mod_rewrite in Apache. You must remove the directory “install/” from the Poweradmin root directory. To do this, you can switch to the following directory:

cd /var/www/html/poweradmin

And copy the htaccess.dist to a new file in poweradmin directory:

 cp install/htaccess.dist .htaccess

Then, remove the install directory with the command below:

rm -rf /var/www/html/poweradmin/install

When you are done, click on Poweradmin:

poweradmin step 7

Here you will see the PoweAdmin login page, you need to enter admin as the username and enter the PowerAdmin password you have created in the step 4 installation, and click Go:

powerdns admin login page centos 7

Finally, you will see your PowerAdmin Administrator page.

poweradmin Centos 7

That’s it you are done. From here you can manage your DNS Zones from the web interface.

Conclusion

At this point, you have learned to Install and Configure PowerDNS and PowerAdmin on Centos 7. Also, you have learned to set up PowerAdmin on your server to manage your DNS servers from a graphical user interface.

Hope you enjoy it. Please subscribe to us on Facebook and Twitter.

LEAVE A REPLY

Please enter your comment!
Please enter your name here
Captcha verification failed!
CAPTCHA user score failed. Please contact us!
Latest Articles

POPULAR TAGS

Most Popular