deployment:network:powerdns:install-postgres

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
deployment:network:powerdns:install-postgres [2026/02/26 16:30] – [Buat Database & User PostgreSQL] ilyasadeployment:network:powerdns:install-postgres [2026/02/27 01:28] (current) – [Konfigurasi PowerDNS Database Conection] ilyasa
Line 21: Line 21:
 ==== Buat Database & User PostgreSQL ==== ==== Buat Database & User PostgreSQL ====
  
-=== Masuk sebagai user postgres: ===+=== Buat database dan user: === 
 +<code sql> 
 +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 
 +</code> 
 + 
 +=== Import schema bawaan PowerDNS: ===
 <code bash> <code bash>
-sudo -u postgres psql+sudo -u postgres psql powerdns < /usr/share/pdns-backend-pgsql/schema/schema.pgsql.sql
 </code> </code>
 +
 +
 +=== Grant Permission to user pdns: ===
 +<code sql>
 +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
 +</code>
 +
 +=== Cek tabel sudah dibuat: ===
 +<code bash>
 +sudo -u postgres psql powerdns -c "\dt"
 +</code>
 +
 +
 +==== 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 ===
 +<code>
 +sudo systemctl disable systemd-resolved --now
 +</code>
 +
 +hapus stub resolv.conf:
 +<code>
 +sudo rm /etc/resolv.conf
 +</code>
 +
 +buat manual resolv.conf:
 +<code>
 +sudo nano /etc/resolv.conf
 +</code>
 +Sesuaikan dengan dns server kalian:
 +Contoh:
 +<code bash>
 +nameserver 8.8.8.8
 +nameserver 1.1.1.1
 +</code>
 +==== Konfigurasi PowerDNS Database Conection ====
 +
 +
 +=== Hapus bind.conf dikarenakan kita menggunakan psql sebagai our backend ===
 +<code bash>
 +rm /etc/powerdns/pdns.d/bind.conf
 +</code>
 +
 +=== Buat konfigurasi powerdns database connetion sesuai dengan database kita ===
 +<code bash>
 +nano /etc/powerdns/pdns.d/gpgsql.conf
 +</code>
 +<code bash>
 +launch=gpgsql
 +gpgsql-host=127.0.0.1
 +gpgsql-port=5432
 +gpgsql-dbname=powerdns
 +gpgsql-user=pdns
 +gpgsql-password=passwordku
 +</code>
 +=== Restart Service ===
 +<code bash>
 +systemctl restart pdns
 +systemctl enable pdns
 +systemctl status pdns
 +</code>
 +
 +
 +{{indexmenu_n>001}}
 +====== PowerDNS : Installasi dengan posgresSQL Backend (Debian 12/13) ======
 +
 +==== Install Paket ====
 +
 +=== Update repository: ===
 +<code bash>
 +apt update
 +</code>
 +
 +=== Install PowerDNS Authoritative + PostgreSQL: ===
 +<code bash>
 +apt install pdns-server pdns-backend-pgsql postgresql
 +</code>
 +
 +=== Pastikan service PostgreSQL berjalan: ===
 +<code bash>
 +systemctl status postgresql
 +</code>
 +
 +==== Buat Database & User PostgreSQL ====
  
 === Buat database dan user: === === Buat database dan user: ===
 <code sql> <code sql>
 +sudo -u postgres psql <<EOF
 CREATE DATABASE powerdns; CREATE DATABASE powerdns;
 CREATE USER pdns WITH PASSWORD 'passwordku'; CREATE USER pdns WITH PASSWORD 'passwordku';
 ALTER DATABASE powerdns OWNER TO pdns; ALTER DATABASE powerdns OWNER TO pdns;
 GRANT ALL PRIVILEGES ON DATABASE powerdns TO pdns; GRANT ALL PRIVILEGES ON DATABASE powerdns TO pdns;
-\q+EOF
 </code> </code>
  
Line 38: Line 140:
 <code bash> <code bash>
 sudo -u postgres psql powerdns < /usr/share/pdns-backend-pgsql/schema/schema.pgsql.sql sudo -u postgres psql powerdns < /usr/share/pdns-backend-pgsql/schema/schema.pgsql.sql
 +</code>
 +
 +
 +=== Grant Permission to user pdns: ===
 +<code sql>
 +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
 </code> </code>
  
Line 45: Line 159:
 </code> </code>
  
 +
 +==== 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 ===
 +<code>
 +sudo systemctl disable systemd-resolved --now
 +</code>
 +
 +hapus stub resolv.conf:
 +<code>
 +sudo rm /etc/resolv.conf
 +</code>
 +
 +buat manual resolv.conf:
 +<code>
 +sudo nano /etc/resolv.conf
 +</code>
 +Sesuaikan dengan dns server kalian:
 +Contoh:
 +<code bash>
 +nameserver 8.8.8.8
 +nameserver 1.1.1.1
 +</code>
 ==== Konfigurasi PowerDNS Database Conection ==== ==== Konfigurasi PowerDNS Database Conection ====
  
Line 65: Line 203:
 gpgsql-password=passwordku gpgsql-password=passwordku
 </code> </code>
 +=== Restart Service ===
 +<code bash>
 +systemctl restart pdns
 +systemctl enable pdns
 +systemctl status pdns
 +</code>
 +
 +==== Testing dengan pembuatan domain ====
 +=== Install tools ===
 +
 +<code bash>
 +apt install pdns-tools dnsutils -y
 +</code>
 +
 +=== Buat Zones dengan pdnsutil ===
 +
 +<code bash>
 +sudo pdnsutil create-zone test.local
 +</code>
 +
 +=== Tambahkan Recods ===
 +
 +<code bash>
 +# 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
 +
 +</code>
 +=== Verify Zones ===
 +
 +<code bash>
 +sudo pdnsutil list-zone test.local
 +</code>
 +
 +=== Check Zones ===
 +
 +<code bash>
 +sudo pdnsutil check-zone test.local
 +</code>
 +
 +=== Test DNS Query ===
 +
 +<code bash>
 +# 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
 +</code>
 +
  
  
  • deployment/network/powerdns/install-postgres.1772098233.txt.gz
  • Last modified: 2026/02/26 16:30
  • by ilyasa