bind9 dlz mysql_bind-9.4.2+mysql dlz安装

ttl 86400

@　　 IN　　 SOA　 localhost. root.localhost. (

1997022700 ; Serial

28800　　 ; Refresh

14400　　 ; Retry

3600000　 ; Expire

86400 )　 ; Minimum

IN　　 NS　　 localhost.

1　　 IN　　 PTR　 localhost.

dig >named.root

再named.conf加入以下内容：

[root@localhost etc]# cat named.conf

options {

version "akindns-ICP";

recursion no;

};

key "rndc-key" {

algorithm hmac-md5;

secret "cEPUadafJTtnG0Moxdhz+w==";

};

controls {

inet 127.0.0.1 port 953

allow { 127.0.0.1; } keys { "rndc-key"; };

};

dlz "Mysql zone" {

database "mysql

{host=127.0.0.1 dbname=nn_dns_data ssl=false port=3306 user=root pass=root }

{select zone from dns_records where zone = '%zone%' limit 1}

{select  ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"') when lower(type) = 'soa' then  concat_ws(' ', data, resp_person, serial, refresh, retry, expire, minimum) else data end as mydata from dns_records where zone = '%zone%' and host = '%record%'}

{}

{select  ttl, type, host, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"') else data end as mydata, resp_person, serial, refresh, retry, expire, minimum from dns_records where zone = '%zone%'}

{select zone from xfr_table where zone = '%zone%' and client = '%client%' limit 1}

{update data_count set count = count + 1 where zone ='%zone%'}";

};

#include "/usr/local/bind-dlz/etc/rndc.key";

[root@localhost etc]#

再建一个数据库nn_dns_data，建一个表dns_records

CREATE DATABASE nn_dns_data;

use nn_dns_data;

CREATE TABLE dns_records (

zone varchar (255),

host varchar (255),

type varchar (255),

data varchar (255),

ttl int(11),

mx_priority varchar (255),

refresh int(11),

retry int(11),

expire int(11),

minimum int(11),

serial bigint(20),

resp_person varchar (255),

primary_ns varchar (255)

);

加入一条记录

INSERT INTO `dns_records` ( `zone` , `host` , `type` , `data` , `ttl` , `mx_priority`

, `refresh` , `retry` , `expire` , `minimum` , `serial` , `resp_person` , `primary_ns` ) VALUES ( 'hibelle.cn', '*', 'A', '192.168.1.1', '800', NULL , NULL , '10', NULL ,

NULL , NULL , NULL , NULL );

./named -u root -g -d 1

结果少了，libmysqlclient.so.15，，查找到在MYSQL的目录，将它复制到/USR/LIB就OK了

cp /usr/local/mysql/lib/mysql/libmysqlclient.so.15 /usr/lib/

这样就OK了，再运行

/usr/local/bind-dlz/sbin/named -u root -g -d 1

完成，再试一下，再运NSLOOKUP

[root@localhost ~]# nslookup

> server 127.0.0.1

Default server: 127.0.0.1

Address: 127.0.0.1#53

>

Server:         127.0.0.1

Address:        127.0.0.1#53

Name:

Address: 192.168.1.1

> alsdkfj.hibelle.cn

Server:         127.0.0.1

Address:        127.0.0.1#53

Name:   alsdkfj.hibelle.cn

Address: 192.168.1.1

> sasdfasfasf.hibelle.cn

Server:         127.0.0.1

Address:        127.0.0.1#53

Name:   sasdfasfasf.hibelle.cn

Address: 192.168.1.1

>

完成，，后两个我随便写的，都能解释到192.168.1.1，因为那个加入的数据，是泛解释的，所以。。。。。

搞定!

接下来。再摘定VIEW，，！