Table of Contents

PowerDNS : Installasi dengan posgresSQL Backend (Debian 12/13)

Install Paket

Update repository:

apt update

Install PowerDNS Authoritative + PostgreSQL:

apt install pdns-server pdns-backend-pgsql postgresql

Pastikan service PostgreSQL berjalan:

systemctl status postgresql

Buat Database & User PostgreSQL

Buat database dan user:

sudo -u postgres psql <<EOF
CREATE DATABASE powerdns;
CREATE USER pdns WITH PASSWORD 'passwordku';
ALTER DATABASE powerdns OWNER TO pdns;
GRANT ALL PRIVILEGES ON DATABASE powerdns TO pdns;
EOF

Import schema bawaan PowerDNS:

sudo -u postgres psql powerdns < /usr/share/pdns-backend-pgsql/schema/schema.pgsql.sql

Grant Permission to user pdns:

sudo -u postgres psql powerdns <<EOF
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO pdns;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO pdns;
GRANT ALL PRIVILEGES ON SCHEMA public TO pdns;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON TABLES TO pdns;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON SEQUENCES TO pdns;
EOF

Cek tabel sudah dibuat:

sudo -u postgres psql powerdns -c "\dt"

Konfigurasi PowerDNS conflict port dengan ''systemd-resolved''

Sometimes server linux terutama cloud images, menggunakan systemd-resolved yang menggunakan port 53 secara default. Kita ingin mendisable hal berikut untuk dapat digunakan PowerDNS Nanti.

Disable systemd-resolved

sudo systemctl disable systemd-resolved --now

hapus stub resolv.conf: 

sudo rm /etc/resolv.conf

buat manual resolv.conf: 

sudo nano /etc/resolv.conf

Sesuaikan dengan dns server kalian: Contoh: 

nameserver 8.8.8.8
nameserver 1.1.1.1

Konfigurasi PowerDNS Database Conection

Hapus bind.conf dikarenakan kita menggunakan psql sebagai our backend

rm /etc/powerdns/pdns.d/bind.conf

Buat konfigurasi powerdns database connetion sesuai dengan database kita

nano /etc/powerdns/pdns.d/gpgsql.conf
launch=gpgsql
gpgsql-host=127.0.0.1
gpgsql-port=5432
gpgsql-dbname=powerdns
gpgsql-user=pdns
gpgsql-password=passwordku

Restart Service

systemctl restart pdns
systemctl enable pdns
systemctl status pdns

PowerDNS : Installasi dengan posgresSQL Backend (Debian 12/13)

Install Paket

Update repository:

apt update

Install PowerDNS Authoritative + PostgreSQL:

apt install pdns-server pdns-backend-pgsql postgresql

Pastikan service PostgreSQL berjalan:

systemctl status postgresql

Buat Database & User PostgreSQL

Buat database dan user:

sudo -u postgres psql <<EOF
CREATE DATABASE powerdns;
CREATE USER pdns WITH PASSWORD 'passwordku';
ALTER DATABASE powerdns OWNER TO pdns;
GRANT ALL PRIVILEGES ON DATABASE powerdns TO pdns;
EOF

Import schema bawaan PowerDNS:

sudo -u postgres psql powerdns < /usr/share/pdns-backend-pgsql/schema/schema.pgsql.sql

Grant Permission to user pdns:

sudo -u postgres psql powerdns <<EOF
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO pdns;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO pdns;
GRANT ALL PRIVILEGES ON SCHEMA public TO pdns;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON TABLES TO pdns;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON SEQUENCES TO pdns;
EOF

Cek tabel sudah dibuat:

sudo -u postgres psql powerdns -c "\dt"

Konfigurasi PowerDNS conflict port dengan ''systemd-resolved''

Sometimes server linux terutama cloud images, menggunakan systemd-resolved yang menggunakan port 53 secara default. Kita ingin mendisable hal berikut untuk dapat digunakan PowerDNS Nanti.

Disable systemd-resolved

sudo systemctl disable systemd-resolved --now

hapus stub resolv.conf: 

sudo rm /etc/resolv.conf

buat manual resolv.conf: 

sudo nano /etc/resolv.conf

Sesuaikan dengan dns server kalian: Contoh: 

nameserver 8.8.8.8
nameserver 1.1.1.1

Konfigurasi PowerDNS Database Conection

Hapus bind.conf dikarenakan kita menggunakan psql sebagai our backend

rm /etc/powerdns/pdns.d/bind.conf

Buat konfigurasi powerdns database connetion sesuai dengan database kita

nano /etc/powerdns/pdns.d/gpgsql.conf
launch=gpgsql
gpgsql-host=127.0.0.1
gpgsql-port=5432
gpgsql-dbname=powerdns
gpgsql-user=pdns
gpgsql-password=passwordku

Restart Service

systemctl restart pdns
systemctl enable pdns
systemctl status pdns

Testing dengan pembuatan domain

Install tools

apt install pdns-tools dnsutils -y

Buat Zones dengan pdnsutil

sudo pdnsutil create-zone test.local

Tambahkan Recods

# Add SOA record
sudo pdnsutil add-record test.local @ SOA "ns1.test.local. admin.test.local. 1 3600 900 604800 300"
 
# Add NS record
sudo pdnsutil add-record test.local @ NS ns1.test.local
 
# Add A record for nameserver
sudo pdnsutil add-record test.local ns1 A 192.168.1.1
 
# Add A record for test host
sudo pdnsutil add-record test.local www A 192.168.1.10

Verify Zones

sudo pdnsutil list-zone test.local

Check Zones

sudo pdnsutil check-zone test.local

Test DNS Query

# Query your PowerDNS server directly
dig @127.0.0.1 www.test.local A
dig @127.0.0.1 test.local NS
dig @127.0.0.1 test.local SOA