diff --git a/README.md b/README.md index 824aadb..87b90da 100644 --- a/README.md +++ b/README.md @@ -255,6 +255,33 @@ MariaDB [testpdns]> CREATE UNIQUE INDEX namealgoindex ON tsigkeys(name, algorithm); ``` +Tambahkan perintah berikut untuk membuat kunci untuk setiap table diatas. + +> ``` +MariaDB [testpdns]> ALTER TABLE records ADD CONSTRAINT `records_domain_id_ibfk` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; +MariaDB [testpdns]> ALTER TABLE comments ADD CONSTRAINT `comments_domain_id_ibfk` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; +MariaDB [testpdns]> ALTER TABLE domainmetadata ADD CONSTRAINT `domainmetadata_domain_id_ibfk` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; +MariaDB [testpdns]> ALTER TABLE cryptokeys ADD CONSTRAINT `cryptokeys_domain_id_ibfk` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; +``` + +Lihat hasil dari penambahan table dengan perintah berikut: + +> ``` +MariaDB [testpdns]> show tables; ++--------------------+ +| Tables_in_testpdns | ++--------------------+ +| comments | +| cryptokeys | +| domainmetadata | +| domains | +| records | +| supermasters | +| tsigkeys | ++--------------------+ +7 rows in set (0.00 sec) +``` + #### Step 3: Instalasi dan konfigurasi PowerDNS Setelah membuat database dan table untuk service PowerDNS selanjutnya lakukan instalasi PowerDNS. @@ -353,3 +380,34 @@ Apabila service Pdns telah terhubung dengan database selanjutnya kita close dan jalankan service PowerDNS kembali. #### Step 4: Add Glue Record and Add Record + +Untuk menambahkan glue record pada domain.tld, silakan menghubungi pihak registrar domain tersebut dan dalam case ini kami menggunakan domain dari registrar Domain Cloud. + +Cara lihat registrar domain + +> ``` +$ whois domain.tld +Sponsoring Registrar PANDI ID:garuda +Sponsoring Registrar Organization:Domain Cloud +Sponsoring Registrar City:Jakarta Selatan +Sponsoring Registrar State/Province:Jakarta +Sponsoring Registrar Postal Code:12870 +Sponsoring Registrar Country:ID +Sponsoring Registrar Phone:02129682828 +Sponsoring Registrar Contact Email:registrar@isi.co.id +``` + +Masuk pada portal domain dan pilih bagian name server masukan nama name server dan Ip Address kemudian save changes. + + +Selanjutnya tambahkan record DNS untuk domain tersebut pada table records + +> ``` +MariaDB [testpdns]> INSERT INTO domains (name, type) values ('padiakse.my.id', 'NATIVE'); +MariaDB [testpdns]> INSERT INTO records (domain_id, name, content, type,ttl,prio) VALUES (1,'padiakse.my.id','padiakse.my.id root.padiakse.my.id 1 10380 3600 604800 3600','SOA',86400,NULL); +MariaDB [testpdns]> INSERT INTO records (domain_id, name, content, type,ttl,prio) VALUES (1,'padiakse.my.id','ns1.padiakse.my.id','NS',86400,NULL); +MariaDB [testpdns]> INSERT INTO records (domain_id, name, content, type,ttl,prio) VALUES (1,'padiakse.my.id','ns2.padiakse.my.id','NS',86400,NULL); +MariaDB [testpdns]> INSERT INTO records (domain_id, name, content, type,ttl,prio) VALUES (1,'ns1.padiakse.my.id','103.23.20.70','A',3600,NULL); +MariaDB [testpdns]> INSERT INTO records (domain_id, name, content, type,ttl,prio) VALUES (1,'ns2.padiakse.my.id','103.23.20.70','A',3600,NULL); +MariaDB [testpdns]> INSERT INTO records (domain_id, name, content, type,ttl,prio) VALUES (1,'padiakse.my.id','103.23.20.70','A',3600,NULL); +```