PowerDNS: Instalasi di Ubuntu - Revision history

Onnowpurbo: /* Create PowerDNS Database dan User di MySQL */

2015-06-01T02:13:36Z

Create PowerDNS Database dan User di MySQL

Onnowpurbo: /* Create PowerDNS Database dan User di MySQL */

2015-06-01T02:10:35Z

Create PowerDNS Database dan User di MySQL

Onnowpurbo: /* Create PowerDNS Database dan User di MySQL */

2015-06-01T02:08:38Z

Create PowerDNS Database dan User di MySQL

Onnowpurbo: /* Test PowerDNS */

2015-06-01T02:02:35Z

Test PowerDNS

Onnowpurbo: /* Test PowerDNS */

2015-06-01T02:00:04Z

Test PowerDNS

Onnowpurbo: /* Test PowerDNS */

2015-06-01T01:57:48Z

Test PowerDNS

Onnowpurbo: /* Konfigurasi PowerDNS */

2015-06-01T01:56:40Z

Konfigurasi PowerDNS

Onnowpurbo: /* Konfigurasi PowerDNS */

2015-06-01T01:53:46Z

Konfigurasi PowerDNS

Onnowpurbo: /* Create PowerDNS Database dan User di MySQL */

2015-06-01T01:52:18Z

Create PowerDNS Database dan User di MySQL

Onnowpurbo: /* Create PowerDNS Database dan User di MySQL */

2015-06-01T01:43:49Z

Create PowerDNS Database dan User di MySQL

@@ Line 64: / Line 64: @@
   CREATE DATABASE powerdns;
-  GRANT ALL ON powerdns.* TO 'poweruser '@'localhost' IDENTIFIED BY 'ubuntu';
+  GRANT ALL ON powerdns.* TO 'poweruser'@'localhost' IDENTIFIED BY 'ubuntu';
 Disini,

@@ Line 111: / Line 111: @@
     auth                  TINYINT(1) DEFAULT 1,
     PRIMARY KEY (id)
-  ) Engine=InnoDB;
+  );
   CREATE INDEX nametype_index ON records(name,type);
@@ Line 123: / Line 123: @@
     account               VARCHAR(40) NOT NULL,
     PRIMARY KEY (ip, nameserver)
-  ) Engine=InnoDB;
+  );
@@ Line 135: / Line 135: @@
     comment               VARCHAR(64000) NOT NULL,
     PRIMARY KEY (id)
-  ) Engine=InnoDB;
+  );
   CREATE INDEX comments_domain_id_idx ON comments (domain_id);
@@ Line 148: / Line 148: @@
     content               TEXT,
     PRIMARY KEY (id)
-  ) Engine=InnoDB;
+  );
   CREATE INDEX domainmetadata_idx ON domainmetadata (domain_id, kind);
@@ Line 160: / Line 160: @@
     content               TEXT,
     PRIMARY KEY(id)
-  ) Engine=InnoDB;
+  );
   CREATE INDEX domainidindex ON cryptokeys(domain_id);
@@ Line 171: / Line 171: @@
     secret                VARCHAR(255),
     PRIMARY KEY (id)
-  ) Engine=InnoDB;
+  );
   CREATE UNIQUE INDEX namealgoindex ON tsigkeys(name, algorithm);

@@ Line 82: / Line 82: @@
   USE powerdns;
-Buat tabel dan record.
+Buat tabel dan record yang dibutuhkan:
   CREATE TABLE domains (
- id INT auto_increment,
+   id                    INT AUTO_INCREMENT,
- name VARCHAR(255) NOT NULL,
+   name                  VARCHAR(255) NOT NULL,
- master VARCHAR(128) DEFAULT NULL,
+   master                VARCHAR(128) DEFAULT NULL,
- last_check INT DEFAULT NULL,
+   last_check            INT DEFAULT NULL,
- type VARCHAR(6) NOT NULL,
+   type                  VARCHAR(6) NOT NULL,
- notified_serial INT DEFAULT NULL,
+   notified_serial       INT DEFAULT NULL,
- account VARCHAR(40) DEFAULT NULL,
+   account               VARCHAR(40) DEFAULT NULL,
- primary key (id)
+   PRIMARY KEY (id)
-  );
+  ) Engine=InnoDB;
   CREATE UNIQUE INDEX name_index ON domains(name);
-−
-Buat tabel records:
   CREATE TABLE records (
- id INT auto_increment,
+   id                    INT AUTO_INCREMENT,
- domain_id INT DEFAULT NULL,
+   domain_id             INT DEFAULT NULL,
- name VARCHAR(255) DEFAULT NULL,
+   name                  VARCHAR(255) DEFAULT NULL,
- type VARCHAR(6) DEFAULT NULL,
+   type                  VARCHAR(10) DEFAULT NULL,
- content VARCHAR(255) DEFAULT NULL,
+   content               VARCHAR(64000) DEFAULT NULL,
- ttl INT DEFAULT NULL,
+   ttl                   INT DEFAULT NULL,
- prio INT DEFAULT NULL,
+   prio                  INT DEFAULT NULL,
- change_date INT DEFAULT NULL,
+   change_date           INT DEFAULT NULL,
- primary key(id)
+   disabled              TINYINT(1) DEFAULT 0,
-  );
+   ordername             VARCHAR(255) BINARY DEFAULT NULL,
+   auth                  TINYINT(1) DEFAULT 1,
-  CREATE INDEX rec_name_index ON records(name);
+   PRIMARY KEY (id)
   CREATE INDEX nametype_index ON records(name,type);
   CREATE INDEX domain_id ON records(domain_id);
+ CREATE INDEX recordorder ON records (domain_id, ordername);
-Buat tabel supermasters:
   CREATE TABLE supermasters (
- ip VARCHAR(25) NOT NULL,
+   ip                    VARCHAR(64) NOT NULL,
- nameserver VARCHAR(255) NOT NULL,
+   nameserver            VARCHAR(255) NOT NULL,
-  account VARCHAR(40) DEFAULT NULL
+   account               VARCHAR(40) NOT NULL,
-  );
+   PRIMARY KEY (ip, nameserver)
 Keluar dari MySQL menggunakan perintah:

@@ Line 210: / Line 210: @@
   ;; global options: +cmd
   ;; Got answer:
-  ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 65075
+  ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 16025
   ;; flags: qr rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 1
   ;; WARNING: recursion requested but not available
   ;; OPT PSEUDOSECTION:
   ; EDNS: version: 0, flags:; udp: 2800
   ;; QUESTION SECTION:
-  ;.                IN    NS
+  ;.				IN	NS
   ;; Query time: 4 msec
   ;; SERVER: 127.0.0.1#53(127.0.0.1)
-  ;; WHEN: Mon Mar 30 14:38:58 IST 2015
+  ;; WHEN: Mon Jun 01 09:00:26 WIB 2015
   ;; MSG SIZE  rcvd: 29
 Or,
-  sudo dig @192.168.1.250
+  sudo dig @192.168.0.100
-Where, 192.168.1.250 is my PowerDNS server’s IP address.
+Dimana, 192.168.0.100 adalah IP address dari PowerDNS server
-Sample output:
+Contoh output:
-  ; <<>> DiG 9.9.5-3-Ubuntu <<>> @192.168.1.250
+  ; <<>> DiG 9.9.5-3-Ubuntu <<>> @192.168.0.100
   ; (1 server found)
   ;; global options: +cmd
   ;; Got answer:
-  ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 39576
+  ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 7241
   ;; flags: qr rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 1
   ;; WARNING: recursion requested but not available
@@ Line 243: / Line 243: @@
   ; EDNS: version: 0, flags:; udp: 2800
   ;; QUESTION SECTION:
-  ;.                IN    NS
+  ;.				IN	NS
-  ;; Query time: 0 msec
+  ;; Query time: 4 msec
-  ;; SERVER: 192.168.1.250#53(192.168.1.250)
+  ;; SERVER: 192.168.0.100#53(192.168.0.100)
-  ;; WHEN: Mon Mar 30 14:39:49 IST 2015
+  ;; WHEN: Mon Jun 01 09:01:43 WIB 2015
   ;; MSG SIZE  rcvd: 29
-That’s it. PowerDNS is ready to use.
+Selesai sudah. PowerDNS siap digunakan.
 ==Referensi==
 * http://www.unixmen.com/how-to-install-powerdns-on-ubuntu-14-04/

@@ Line 185: / Line 185: @@
   dns-search home
-We completed all installation and configuration parts. Now, we will check whether PowerDNS is really working or not.
+Kita selesai dengan semua bagian instalasi dan konfigurasi.
-First check if PowerDNS is listening:
+Pertama-tama, cek apakah PowerDNS mendengarkan:
   sudo netstat -tap | grep pdns
-Sample output:
+contoh output:
-  tcp        0      0 *:domain                *:*                     LISTEN      1549/pdns_server-in
+  tcp        0      0 *:domain                *:*                     LISTEN      4845/pdns_server-in
-Now, enter the following command to check PowerDNS is working:
+Sekarang, masukan perintah berikut, untuk mencek apakah PowerDNS berjalan dengan baik:
   sudo dig @127.0.0.1
-Or,
+atau,
   sudo dig @localhost
-Sample output:
+Contoh output:
   ; <<>> DiG 9.9.5-3-Ubuntu <<>> @127.0.0.1

← Older revision		Revision as of 01:57, 1 June 2015
Line 162:		Line 162:

	sudo vi /etc/resolv.conf		sudo vi /etc/resolv.conf
		+
		+	isi
		+
		+	nameserver 192.168.0.100
		+
		+	sesuai dengan IP address server

	Set the name server IP address:		Set the name server IP address:

@@ Line 140: / Line 140: @@
   sudo vi /etc/powerdns/pdns.d/pdns.local.gmysql.conf
-Add the following lines. Set the correct database name and database user which we created earlier.
+Tambahkan kalimat berikut, yang sesuai dengan konfigurasi yang kita lakukan sebelumnya:
   # MySQL Configuration
@@ Line 153: / Line 153: @@
   gmysql-password=ubuntu
-Finally restart powerdns service.
+Restart powerdns service.
   sudo service pdns restart
-Test PowerDNS
+==Test PowerDNS==
-First, edit /ect/resolv.conf file,
+Edit file /ect/resolv.conf ,
   sudo vi /etc/resolv.conf
@@ Line 171: / Line 171: @@
   auto eth0
   iface eth0 inet static
-  address 192.168.1.250
+  address 192.168.0.100
   netmask 255.255.255.0
-  network 192.168.1.0
+  network 192.168.0.0
-  broadcast 192.168.1.255
+  broadcast 192.168.0.255
-  gateway 192.168.1.1
+  gateway 192.168.0.223
-  dns-nameservers 192.168.1.250
+  dns-nameservers 192.168.0.223
   dns-search home

@@ Line 130: / Line 130: @@
 ==Konfigurasi PowerDNS==
-Now, we should configure PowerDNS to use MySQL as backend to store Zone files and records.
+Konfigurasi PowerDNS untuk menggunakan MySQL sebagai backend untuk menyimpan file Zone dan records.
-Remove the existing PowerDNS configuration files.
+Buang file konfigurasi PowerDNS yang ada.
   sudo rm /etc/powerdns/pdns.d/*.*
-Then, create file /etc/powerdns/pdns.d/pdns.local.gmysql.conf file;
+Buat file /etc/powerdns/pdns.d/pdns.local.gmysql.conf ;
   sudo vi /etc/powerdns/pdns.d/pdns.local.gmysql.conf

@@ Line 74: / Line 74: @@
 Sebaiknya menggunakan password yang lebih baik agar security lebih aman.
-Enter the following command to update the user settings.
+Tulis perintah berikut untuk update user settings.
   FLUSH PRIVILEGES;
-Now, use the powerdns database with command:
+Gunakan powerdns database, menggunakan perintah:
   USE powerdns;
-Create the necessary tables and records.
+Buat tabel dan record.
-First, let us create domains table:
+Buat tabel domains:
   CREATE TABLE domains (
@@ Line 96: / Line 96: @@
   primary key (id)
   );
   CREATE UNIQUE INDEX name_index ON domains(name);
@@ Line 112: / Line 111: @@
   primary key(id)
   );
   CREATE INDEX rec_name_index ON records(name);
   CREATE INDEX nametype_index ON records(name,type);
   CREATE INDEX domain_id ON records(domain_id);
- Create the supermasters table:
   CREATE TABLE supermasters (
@@ Line 126: / Line 124: @@
   );
-Finally, exit from MySQL prompt using command:
+Keluar dari MySQL menggunakan perintah:
   quit;
-Configure PowerDNS
+==Konfigurasi PowerDNS==
 Now, we should configure PowerDNS to use MySQL as backend to store Zone files and records.

@@ Line 71: / Line 71: @@
 * poweruser – adalah database user,
 * ubuntu – adalah password for the ‘poweruser’ user.
-* I recommend you to use any strong password to tighten the security.
 Enter the following command to update the user settings.
@@ Line 96: / Line 97: @@
   );
   Create Unique Index for domains table:
   CREATE UNIQUE INDEX name_index ON domains(name);
-Create records table:
+Buat tabel records:
   CREATE TABLE records (