"PowerDNS"의 두 판 사이의 차이

오픈소스 비즈니스 컨설팅
둘러보기로 가기 검색하러 가기
잔글
잔글
12번째 줄: 12번째 줄:
  
  
[[CentOS#EPEL_.EC.84.A4.EC.B9.98|CensOS용 EPEL 설치]]
+
[[CentOS#EPEL .EC.84.A4.EC.B9.98|CensOS용 EPEL 설치]]를 합니다.
 +
 
 +
PowerDNS를 설치 합니다.
 +
 
 +
{| cellspacing="1" cellpadding="1" style="color: rgb(0, 0, 0); font-family: sans-serif; line-height: 19.0499992370605px; width: 853px;"
 +
|-
 +
| style="background-color: rgb(241, 241, 241);" | yum install pdns pdns-backend-mysql pdns-recursor<br/>
 +
|}
 +
 
 +
 
 +
 
 +
[[MariaDB|MariaDB]]에서 Database 등을&nbsp;생성 합니다.
 +
 
 +
vi pdns.sql
 +
 
 +
{| cellspacing="1" cellpadding="1" style="color: rgb(0, 0, 0); font-family: sans-serif; line-height: 19.0499992370605px; width: 853px;"
 +
|-
 +
| style="background-color: rgb(241, 241, 241);" |
 +
create table domains (<br/>&nbsp; &nbsp; id INT auto_increment,<br/>&nbsp; &nbsp; name VARCHAR(255) NOT NULL,<br/>&nbsp; &nbsp; master VARCHAR(128) DEFAULT NULL,<br/>&nbsp; &nbsp; last_check INT DEFAULT NULL,<br/>&nbsp; &nbsp; type VARCHAR(6) NOT NULL,<br/>&nbsp; &nbsp; notified_serial INT DEFAULT NULL,&nbsp;<br/>&nbsp; &nbsp; account VARCHAR(40) DEFAULT NULL,<br/>&nbsp; &nbsp; primary key (id)<br/>) Engine=InnoDB;<br/>CREATE UNIQUE INDEX name_index ON domains(name);
 +
 
 +
CREATE TABLE records (<br/>&nbsp; &nbsp; id INT auto_increment,<br/>&nbsp; &nbsp; domain_id INT DEFAULT NULL,<br/>&nbsp; &nbsp; name VARCHAR(255) DEFAULT NULL,<br/>&nbsp; &nbsp; type VARCHAR(10) DEFAULT NULL,<br/>&nbsp; &nbsp; content VARCHAR(64000) DEFAULT NULL,<br/>&nbsp; &nbsp; ttl INT DEFAULT NULL,<br/>&nbsp; &nbsp; prio INT DEFAULT NULL,<br/>&nbsp; &nbsp; change_date INT DEFAULT NULL,<br/>&nbsp; &nbsp; primary key(id)<br/>) Engine=InnoDB;<br/>CREATE INDEX rec_name_index ON records(name);<br/>CREATE INDEX nametype_index ON records(name,type);<br/>CREATE INDEX domain_id ON records(domain_id);
 +
 
 +
create table supermasters (<br/>&nbsp; &nbsp; ip VARCHAR(25) NOT NULL,&nbsp;<br/>&nbsp; &nbsp; nameserver VARCHAR(255) NOT NULL,&nbsp;<br/>&nbsp; &nbsp; account VARCHAR(40) DEFAULT NULL<br/>) Engine=InnoDB;
 +
 
 +
|}
 +
 
 +
 
 +
 
 +
mysql -uroot -p mysql
 +
 
 +
{| cellspacing="1" cellpadding="1" style="color: rgb(0, 0, 0); font-family: sans-serif; line-height: 19.0499992370605px; width: 853px;"
 +
|-
 +
| style="background-color: rgb(241, 241, 241);" |
 +
create database powerdns;<br/>grant all privileges on powerdns.* to powerdns@localhost identified by 'demo1234';<br/>flush privileges;
 +
 
 +
use powerdns;<br/>source pownerdns.sql<br/>commit;<br/>show tables;
 +
 
 +
quit;
 +
 
 +
|}
 +
 
 +
 
 +
 
 +
PowerDNS를 설치 합니다.
 +
 
 +
{| cellspacing="1" cellpadding="1" style="color: rgb(0, 0, 0); font-family: sans-serif; line-height: 19.0499992370605px; width: 853px;"
 +
|-
 +
| style="background-color: rgb(241, 241, 241);" | yum install pdns pdns-backend-mysql pdns-recursor<br/><br/>
 +
|}
 +
 
 +
ppp
  
 
= 참고 문헌 =
 
= 참고 문헌 =

2014년 9월 19일 (금) 09:43 판

DNS 솔루션인 PowerDNS를 정리 합니다.

PowerDNS 개요

CentOS 6.5에 설치

CensOS용 EPEL 설치를 합니다.

PowerDNS를 설치 합니다.

yum install pdns pdns-backend-mysql pdns-recursor


MariaDB에서 Database 등을 생성 합니다.

vi pdns.sql

create table domains (
    id INT auto_increment,
    name VARCHAR(255) NOT NULL,
    master VARCHAR(128) DEFAULT NULL,
    last_check INT DEFAULT NULL,
    type VARCHAR(6) NOT NULL,
    notified_serial INT DEFAULT NULL, 
    account VARCHAR(40) DEFAULT NULL,
    primary key (id)
) Engine=InnoDB;
CREATE UNIQUE INDEX name_index ON domains(name);

CREATE TABLE records (
    id INT auto_increment,
    domain_id INT DEFAULT NULL,
    name VARCHAR(255) DEFAULT NULL,
    type VARCHAR(10) DEFAULT NULL,
    content VARCHAR(64000) DEFAULT NULL,
    ttl INT DEFAULT NULL,
    prio INT DEFAULT NULL,
    change_date INT DEFAULT NULL,
    primary key(id)
) Engine=InnoDB;
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 table supermasters (
    ip VARCHAR(25) NOT NULL, 
    nameserver VARCHAR(255) NOT NULL, 
    account VARCHAR(40) DEFAULT NULL
) Engine=InnoDB;


mysql -uroot -p mysql

create database powerdns;
grant all privileges on powerdns.* to powerdns@localhost identified by 'demo1234';
flush privileges;

use powerdns;
source pownerdns.sql
commit;
show tables;

quit;


PowerDNS를 설치 합니다.

yum install pdns pdns-backend-mysql pdns-recursor

ppp

참고 문헌