实现WEB管理的PowerDNS

环境

在这个环境之上增加一台虚拟机用作powerdns

linux、apache、php-fpm	linux、mariadb	linux client	httpd、powerdns
192.168.43.17	192.168.43.7	192.168.43.6	192.168.43.27
apache_php-fpm	mariadb	client	httpd_powerdns

配置数据库

创建数据库用户，授权

[mariadb]#

mysql -e "create database powerdns;grant all on powerdns.* to powerdns@'192.168.43.%' identified by 'centos';"

创建powerdns数据库中的表，参看下面文档实现
参考文档
[mariadb]#

mysql
use powerdns;
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                    BIGINT 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