使用MySQL在CentOS上安装PowerDNS

使用MySQL On CentOS安装PowerDNS

什么是PowerDNS？

PowerDNS是一个基于MySQL的DNS服务器，用C ++编写，并根据GPL许可。 PowerDNS可以通过Web界面（PowerAdmin）进行管理。 本指南介绍如何在CentOS上安装它。

1.安装MySQL

[root@server ~]# yum -y install mysql mysql-server

2.创建MySQL的系统启动链接

[root@server ~]# chkconfig --levels 235 mysqld on

[root@server ~]# service mysqld start

3.检查MySQL是否正在运行

[root@server ~]# netstat -tap | grep mysql

tcp        0      0 *:mysql                 *:*     LISTEN   28179/mysqld 

4.设置用户root的密码

[root@server ~]# mysqladmin -u root password password123

5.安装PowerDNS

[root@server ~]# yum -y install pdns pdns-backend-mysql

6.设置数据库

[root@server ~]# mysql -u root -p

mysql> CREATE DATABASE powerdns;

mysql> user powerdns;

mysql> 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)
 -> );

mysql> CREATE UNIQUE INDEX name_index ON domains(name);

mysql> CREATE TABLE records (
 -> id INT auto_increment,
 -> domain_id INT DEFAULT NULL,
 -> name VARCHAR(255) DEFAULT NULL,
 -> type VARCHAR(6) DEFAULT NULL,
 -> content VARCHAR(255) DEFAULT NULL,
 -> ttl INT DEFAULT NULL,
 -> prio INT DEFAULT NULL,
 -> change_date INT DEFAULT NULL,
 -> primary key(id)
 -> );

mysql> CREATE INDEX rec_name_index ON records(name);

mysql> CREATE INDEX nametype_index ON records(name,type);

mysql> CREATE INDEX domain_id ON records(domain_id);

mysql> CREATE TABLE supermasters (
 -> ip VARCHAR(25) NOT NULL,
 -> nameserver VARCHAR(255) NOT NULL,
 -> account VARCHAR(40) DEFAULT NULL
 -> );

mysql> quit;

[root@server ~]# nano /etc/pdns/pdns.conf

#################################
# launch Which backends to launch and order to query them in
#
# launch=

launch=gmysql

gmysql-host=192.200.200.1

gmysql-user=power_admin

gmysql-password=password123

gmysql-dbname=powerdns

#################################

7.为PowerDNS创建系统启动链接

[root@server ~]# chkconfig --levels 235 pdns on

[root@server ~]# service pdns start

8.准备PowerAdmin安装系统

[root@server ~]# yum -y 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

为apache创建系统启动链接并启动它

[root@server ~]# chkconfig --levels 235 httpd on

[root@server ~]# service httpd start

10.安装以下两个PEAR包

yum -y install php-pear-DB php-pear-MDB2-Driver-mysql

11.下载PowerAdmin

[root@server ~]# wget https://www.poweradmin.org/download/poweradmin-2.1.2.tgz

[root@server ~]# tar zxvf poweradmin-2.1.2.tgz -C /var/www/html/

[root@server ~]# mv poweradmin-2.1.2 poweradmin

[root@server ~]# mv /var/www/html/poweradmin/inc/config.inc.php

[root@server ~]# chown -R apache:apache /var/www/html/poweradmin/