[Linux] PDNS-³×ÀÓ¼­¹ö (PowerDNS) ¼³Ä¡ ¹× replication

   Á¶È¸ 7495   Ãßõ 0    

http://ehostidc.co.kr/center/EH050402.php?no=141488&page=8&choose=tit¡¦ (271)
https://blog.naver.com/goethe1/221642889788 (368)

OS : CentOS 7.4

1. pdns 설치(1차/2차 공통)

a. repo 설치

[root@ns1 ehost]# yum install epel-release -y


b. pdns 및 mariadb 설치

[root@ns1 ehost]# yum install mariadb-server mariadb


[root@ns1 ehost]# yum install pdns pdns-backend-mysql

c. DB 설정

[root@ns1 ehost]# systemctl start mariadb

[root@ns2 ehost]# mysql_secure_installation


d. pdns db 생성

[root@ns1 ehost]# mysql -u root -p

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or g.

Your MariaDB connection id is 9

Server version: 5.5.56-MariaDB MariaDB Server


Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.


Type "help;" or "h" for help. Type "c" to clear the current input statement.


MariaDB [(none)]> create database pdns;

Query OK, 1 row affected (0.00 sec)


MariaDB [(none)]> GRANT ALL ON pdns.* TO "pdns"@"localhost" IDENTIFIED BY "pdns패스워드";

Query OK, 0 rows affected (0.00 sec)


- SOA접근 USER 추가 )

MariaDB [(none)]> GRANT ALL ON pdns.* TO "pdns"@"testdns" IDENTIFIED BY "pdns패스워드";

Query OK, 0 rows affected (0.00 sec)


MariaDB [(none)]> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.00 sec)


e. pdns DB import

[root@ns1 ehost]# cd /usr/share/doc/pdns-backend-mysql-3.4.11/

[ehost@ns1 pdns-backend-mysql-3.4.11]# mysql -updns -pdlghtmxm1509 pdns < schema.mysql.sql

2. pdns 설정 (/etc/pdns/pdns.conf )

a. 1차 네임서버

allow-axfr-ips=2차네임서버IP/32

master=yes

launch=gmysql

gmysql-host=localhost

gmysql-user=pdns

gmysql-password=pdns패스워드

gmysql-dbname=pdns



b. 2차 네임서버

master=no

slave=yes

slave-cycle-interval=60

gmysql-host=localhost

gmysql-user=pdns

gmysql-password=pdns패스워드

gmysql-dbname=pdns

- 2차 서버 DB 설정

[root@ns2 ehost]# mysql -u pdns -p

mysql > use pdns;

mysql > insert into supermasters values ("1차네임서버IP", "ns2.ehostidc.co.kr", "admin");

                                                            2차 네임서버 도메인

3. 서비스 등록 및 시작(1/2차 네임서버 공통)

[root@ns1 ehost]# systemctl enable mariadb

[root@ns1 ehost]# systemctl enable pdns

[root@ns1 ehost]# systemctl start pdns


4.powerdns admin 셋팅(1/2차 네임서버 공통)

a. http/php 설치

[root@ns1 ehost]# yum install httpd php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-mhash gettext



[root@ns1 ehost]# yum install php-pear-DB php-pear-MDB2-Driver-mysql


b. 웹소스 다운로드

[root@localhost ~]# cd /var/www/html


[root@localhost ~]# wget http://downloads.sourceforge.net/project/poweradmi...

c. 해당 파일 압축해제 및 poweradmin 으로 폴더 이름 변경

d. http://61.97.255.11:8080/poweradmin/install/


- db 접속 정보 셋팅

 

아래 내용의 쿼리를 디비에서 실행



- cp inc/config-me.inc.php inc/config.inc.php

- inc/config.inc.php 파일 수정





- install 폴더 삭제 후 http://"서버IP"/poweradmin 로 접속



- 1차 서버에서는 Add master zone 에 도메인 셋팅


- 2차 서버에서는 Add slave zone 에 1차와 동일한 도메인 셋팅

- 1차 서버에서 도메인 zone 업데이트 시에 2차로 자동 전파

5. 문제점 및 해결책(?)

a. 도메인 설정을 1/2차에 모두 해야 하는 점.

b. 1/2차 모두 master 로 설정 후 DB를 mysql replication 셋팅하면, 2차 pdns 에 도메인 셋팅 이슈가 없으질듯.

cf. mysql replication 이용해서 설정했을때 오류 발생

May 24 12:23:55 ns2 pdns[2815]: Exiting because communicator thread died with error: GSQLBackend unable to refresh domain_id 2: Failed to execute mysql_query, perhaps connecti
on died? Err=1: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based l
ogging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
May 24 12:23:55 ns2 pdns[2815]: Done launching threads, ready to distribute questions
May 24 12:23:56 ns2 pdns_control: Fatal error: Unable to connect to remote "/var/run/pdns.controlsocket": Connection refused
May 24 12:23:56 ns2 systemd: pdns.service: control process exited, code=exited status=1
May 24 12:23:56 ns2 systemd: Unit pdns.service entered failed state.
May 24 12:23:56 ns2 systemd: pdns.service failed.

my.cnf 설정에서

binlog_format=ROW 또는

binlog_format=MiXED

처리 필요








https://www.aiocp.co.kr/ ( 딥러닝,머신러닝 서버 판매 ,컨설팅) https://bigbangcloud.co.kr/ ( GPU 클라우드 서비스) ::: AI 서버의 모든것 ::: 인공지능의 시작~ (주)이호스트ICT
ªÀº±Û Àϼö·Ï ½ÅÁßÇÏ°Ô.


PDS
Á¦¸ñPage 1/76
2014-05   4443464   Á¤ÀºÁØ1
2015-12   999420   ¹é¸Þ°¡
02-22   2067   È­Á¤Å¥»ï
02-15   2182   ¹Ì·¡1
02-14   2317   ¾î¸¥ÀÌ
02-03   3122   Å볪¹«
01-18   5588   ±è°¡ÇǽÃ
01-02   6708   Á¦°¥±âõ
2023-12   5823   ¹Ú¹®Çü
2023-12   5742   inquisitive
2023-12   5720   ¾ÈöÇö
2023-12   4466   ¸¶·Î´¸
2023-12   2400   µö·¯´×¼­¹ö
2023-11   2858   AKMU
2023-11   2428   TheSTREET
2023-11   2799   TheSTREET
2023-11   2551   TheSTREET
2023-11   2646   ½º½ºÄí
2023-11   2762   ±èȲÁß
2023-11   2250   ¾Æ½º¶õ
2023-10   20759   AKAÁö´Ï
2023-10   30796   Á¦¿ÂÇÁ·Î