{"id":173,"date":"2011-06-02T23:50:16","date_gmt":"2011-06-02T23:50:16","guid":{"rendered":"f7e6c85504ce6e82442c770f7c8606f0"},"modified":"2011-06-02T23:50:16","modified_gmt":"2011-06-02T23:50:16","slug":"","status":"publish","type":"post","link":"https:\/\/www.xiaobo.li\/notes\/archives\/173","title":{"rendered":"bind dlz \u5b89\u88c5\u914d\u7f6e"},"content":{"rendered":"

bind:<\/p>\n

bind+SDB+mysql
\nbind+DLZ+mysql
\nbind+nsupdate + IXFR<\/p>\n

______________________________________<\/p>\n

read:<\/p>\n

http:\/\/bind-dlz.sourceforge.net\/mysql_driver.html<\/p>\n

 <\/p>\n

-------------------------------<\/p>\n


\n<\/span><\/p>\n

cd \/usr\/local\/src<\/span><\/p>\n

wget ftp:\/\/ftp.bind.com\/pub\/bind9\/9.5.0\/bind-9.5.0.tar.gz<\/span>
\ntar zxvf bind-9.5.0.tar.gz<\/span>
\ncd bind-9.5.0<\/span>
\n.\/configure \u2013with-dlz-mysql \u2013enable-threads \u2013prefix=\/usr\/local\/bind<\/span>
\nmake<\/span>
\nmake install<\/span>
\ncd \/usr\/local\/bind\/etc\/<\/span>
\n..\/sbin\/rndc-confgen >rndc.conf<\/span>
\ntail -n10 rndc.conf | head -n9 | sed -e s\/#\\\/\/g >named.conf<\/span>
\nvi localhost.zone<\/span>
\nttl 86400<\/span>
\n@ IN SOA localhost. root.localhost. (<\/span>
\n1997022700 ; Serial<\/span>
\n28800 ; Refresh<\/span>
\n14400 ; Retry<\/span>
\n3600000 ; Expire<\/span>
\n86400 ) ; Minimum<\/span>
\nIN NS localhost.<\/span>
\n1 IN PTR localhost.<\/span>
\ndig > named.root<\/span>
\nvi named.conf<\/span>
\n\u5728\u6700\u540e\u52a0\u4e0a<\/span>
\ndlz \u201cMysql zone\u201d {<\/span>
\ndatabase \u201cmysql<\/span>
\n{host=127.0.0.1 dbname=dns ssl=false port=3306 user=root pass= }<\/span>
\n{select zone from dns_records where zone = \u2018%zone%\u2019 limit 1}<\/span>
\n{select ttl, type, mx_priority, case when lower(type)=\u2019txt\u2019 then concat(\u2019\\\u201d\u2018, data, \u2018\\\u201d\u2018) when lower(type) = \u2019soa\u2019 then concat_ws(\u2019 \u2018, data, resp_person, serial, refresh, retry, expire, minimum) else data end as mydata from dns_records where zone = \u2018%zone%\u2019 and host = \u2018%record%\u2019}<\/span>
\n{}<\/span>
\n{select ttl, type, host, mx_priority, case when lower(type)=\u2019txt\u2019 then concat(\u2019\\\u201d\u2018, data, \u2018\\\u201d\u2018) else data end as mydata, resp_person, serial, refresh, retry, expire, minimum from dns_records where zone = \u2018%zone%\u2019}<\/span>
\n{select zone from xfr_table where zone = \u2018%zone%\u2019 and client = \u2018%client%\u2019 limit 1}<\/span>
\n{update data_count set count = count + 1 where zone =\u2019%zone%\u2019}\u201d;<\/span>
\n};<\/span><\/p>\n

\u5b89\u88c5Mysql,\u5b89\u88c5\u5230\/usr\/local\/mysql\/,\u5b89\u88c5\u6b65\u9aa4\u7565\u2026<\/span>
\n\u5efa\u4e00\u4e2a\u6570\u636e\u5e93dns<\/span>
\nCREATE DATABASE dns;<\/span>
\n\u5efa\u4e00\u4e2a\u8868dns_records<\/span><\/p>\n

use dns;<\/span>
\nCREATE TABLE dns_records (<\/span>
\nzone varchar (255),<\/span>
\nhost varchar (255),<\/span>
\ntype varchar (255),<\/span>
\ndata varchar (255),<\/span>
\nttl int(11),<\/span>
\nmx_priority varchar (255),<\/span>
\nrefresh int(11),<\/span>
\nretry int(11),<\/span>
\nexpire int(11),<\/span>
\nminimum int(11),<\/span>
\nserial bigint(20),<\/span>
\nresp_person varchar (255),<\/span>
\nprimary_ns varchar (255)<\/span>
\n);<\/span>
\n\u52a0\u5165\u4e00\u6761\u8bb0\u5f55
\nINSERT INTO `dns_records` ( `zone` , `host` , `type` , `data` , `ttl` , `mx_priority`
\n, `refresh` , `retry` , `expire` , `minimum` , `serial` , `resp_person` , `primary_ns` ) VALUES ( \u2018yemaosheng.com\u2019, \u2018*\u2019, \u2018A\u2019, \u2018192.168.0.1\u2032, \u2018800\u2032, NULL , NULL , \u201810\u2032, NULL ,
\nNULL , NULL , NULL , NULL );<\/span><\/p>\n

cp \/usr\/local\/mysql\/lib\/mysql\/libmysqlclient.so.15 \/usr\/lib\/<\/span><\/p>\n

\u542f\u52a8Bind<\/span>
\n.\/named -u root -g -d 1<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

 <\/p>\n

read:<\/p>\n

http:\/\/bind-dlz.sourceforge.net\/mysql_driver.html<\/p>\n

 <\/p>\n

-------------------------------<\/p>\n


\n<\/span><\/p>\n

cd \/usr\/local\/src<\/span><\/p>\n

wget ftp:\/\/ftp.bind.com\/pub\/bind9\/9.5.0\/bind-9.5.0.tar.gz<\/span>
\ntar zxvf bind-9.5.0.tar.gz<\/span>
\ncd bind-9.5.0<\/span>
\n.\/configure \u2013with-dlz-mysql \u2013enable-threads \u2013prefix=\/usr\/local\/bind<\/span>
\nmake<\/span>
\nmake install<\/span>
\ncd \/usr...<\/span><\/p>\n

\u7ee7\u7eed\u9605\u8bfb →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[273],"tags":[5,6],"class_list":["post-173","post","type-post","status-publish","format-standard","hentry","category-article","tag-Bind","tag-dns"],"_links":{"self":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts\/173","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/comments?post=173"}],"version-history":[{"count":0,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts\/173\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/media?parent=173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/categories?post=173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/tags?post=173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}