Difference between revisions of "PowerDNS: Memasukan Record SOA NS A MX ke Database"

From OnnoWiki
Jump to navigation Jump to search
(New page: Masuk ke MySQL mysql -u root -p123456 ==Domain / Zone== Membuat sebuah zone / domain INSERT INTO domains (name, type) values ('example.com', 'NATIVE'); ==SOA== INSERT INTO records...)
 
Line 38: Line 38:
  
 
==Contoh Sebuah Domain==
 
==Contoh Sebuah Domain==
 +
 +
mysql -u root -p123456
  
 
  INSERT INTO domains (name, type) values ('contoh.web.id', 'NATIVE');
 
  INSERT INTO domains (name, type) values ('contoh.web.id', 'NATIVE');
Line 56: Line 58:
 
  INSERT INTO records (domain_id, name, content, type,ttl,prio)
 
  INSERT INTO records (domain_id, name, content, type,ttl,prio)
 
  VALUES (1,'contoh.web.id','mail.contoh.web.id','MX',120,25);
 
  VALUES (1,'contoh.web.id','mail.contoh.web.id','MX',120,25);
 +
quit

Revision as of 09:41, 5 June 2015

Masuk ke MySQL

mysql -u root -p123456

Domain / Zone

Membuat sebuah zone / domain

INSERT INTO domains (name, type) values ('example.com', 'NATIVE');

SOA

INSERT INTO records (domain_id, name, content, type,ttl,prio) 
VALUES (1,'example.com','localhost ahu@ds9a.nl 1','SOA',86400,NULL);

NS

INSERT INTO records (domain_id, name, content, type,ttl,prio)
VALUES (1,'example.com','dns-us1.powerdns.net','NS',86400,NULL);
INSERT INTO records (domain_id, name, content, type,ttl,prio)
VALUES (1,'example.com','dns-eu1.powerdns.net','NS',86400,NULL);

A

INSERT INTO records (domain_id, name, content, type,ttl,prio)
VALUES (1,'www.example.com','192.0.2.10','A',120,NULL);
INSERT INTO records (domain_id, name, content, type,ttl,prio)
VALUES (1,'mail.example.com','192.0.2.12','A',120,NULL);
INSERT INTO records (domain_id, name, content, type,ttl,prio)
VALUES (1,'localhost.example.com','127.0.0.1','A',120,NULL);

MX

INSERT INTO records (domain_id, name, content, type,ttl,prio)
VALUES (1,'example.com','mail.example.com','MX',120,25);


Contoh Sebuah Domain

mysql -u root -p123456
INSERT INTO domains (name, type) values ('contoh.web.id', 'NATIVE');
INSERT INTO records (domain_id, name, content, type,ttl,prio) 
VALUES (1,'contoh.web.id','localhost ahu@ds9a.nl 1','SOA',86400,NULL);
INSERT INTO records (domain_id, name, content, type,ttl,prio)
VALUES (1,'contoh.web.id','ns1.contoh.web.id','NS',86400,NULL);
INSERT INTO records (domain_id, name, content, type,ttl,prio)
VALUES (1,'contoh.web.id','ns1.isp.net.id','NS',86400,NULL);
INSERT INTO records (domain_id, name, content, type,ttl,prio)
VALUES (1,'www.contoh.web.id','192.168.0.100','A',120,NULL);
INSERT INTO records (domain_id, name, content, type,ttl,prio)
VALUES (1,'ns1.contoh.web.id','192.168.0.100','A',120,NULL);
INSERT INTO records (domain_id, name, content, type,ttl,prio)
VALUES (1,'mail.contoh.web.id','192.168.0.100','A',120,NULL);
INSERT INTO records (domain_id, name, content, type,ttl,prio)
VALUES (1,'localhost.contoh.web.id','127.0.0.1','A',120,NULL);
INSERT INTO records (domain_id, name, content, type,ttl,prio)
VALUES (1,'contoh.web.id','mail.contoh.web.id','MX',120,25);
quit