Differences

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

--- deployment:network:powerdns:install-postgres [2026/02/26 15:08] – ilyasa
+++ deployment:network:powerdns:install-postgres [2026/02/27 20:04] (current) – [Konfigurasi PowerDNS Database Conection] ilyasa
@@ Line 21: / Line 21: @@
 ==== Buat Database & User PostgreSQL ====
-=== Masuk sebagai user postgres: ===
+=== Buat database dan user: ===
+<code sql>
+sudo -u postgres psql -c "CREATE USER pdns WITH PASSWORD 'PasswordYangKuat';"
+sudo -u postgres psql -c "CREATE DATABASE powerdns OWNER pdns;"
+</code>
+=== Import schema bawaan PowerDNS: ===
 <code bash>
-sudo -u postgres psql
+sudo -u postgres psql -d powerdns -c "SET ROLE pdns;" -f /usr/share/pdns-backend-pgsql/schema/schema.pgsql.sql
 </code>
-=== Buat database dan user: ===
+=== Grant Permission to user pdns: ===
 <code sql>
-CREATE DATABASE powerdns;
+sudo -u postgres psql -d powerdns -c "ALTER SCHEMA public OWNER TO pdns;"
-CREATE USER pdns WITH PASSWORD 'passwordku';
+sudo -u postgres psql -d powerdns -c "GRANT CREATE ON SCHEMA public TO pdns;"
-ALTER DATABASE powerdns OWNER TO pdns;
-GRANT ALL PRIVILEGES ON DATABASE powerdns TO pdns;
-\q
 </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=PasswordYangKuat
+</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>