{"id":413,"date":"2007-12-19T21:23:22","date_gmt":"2007-12-19T13:23:22","guid":{"rendered":"http:\/\/blog.smallken.ink\/2007\/12\/19\/linux\/413.html"},"modified":"2007-12-19T21:25:59","modified_gmt":"2007-12-19T13:25:59","slug":"%e6%9e%b6%e8%a8%ad-dns-%e4%bd%bf%e7%94%a8-mysql-%e8%b3%87%e6%96%99%e5%ba%ab%e7%ae%a1%e7%90%86-for-centos-51-mydns","status":"publish","type":"post","link":"https:\/\/blog.smallken.site\/?p=413","title":{"rendered":"\u67b6\u8a2d DNS \u4f7f\u7528 MySQL \u8cc7\u6599\u5eab\u7ba1\u7406 for CentOS 5.1 – MyDNS"},"content":{"rendered":"

\u5176\u5be6\u6211\u89ba\u5f97 DNS \u4e0d\u592a\u597d\u67b6\uff0c\u4e0d\u592a\u597d\u67b6\u7684\u539f\u56e0\u5c31\u662f\u8aaa\u5b83\u9700\u8981\u6709\u77e5\u9053\u5f88\u591aDomain Know How \u518d\u4f86\u67b6 DNS \u624d\u6703\u89ba\u5f97\u5bb9\u6613\uff0c\u518d\u4f86\u5c31\u662f\u4fee\u6539\u90a3\u4e9bZone\u7684\u6587\u4ef6\uff0c\u5f88\u591a\u6771\u897f\u53ef\u80fd\u90fd\u4e0d\u78ba\u5b9a\u53ef\u4e0d\u53ef\u4ee5\u6539\uff0c\u6216\u4e0d\u78ba\u5b9a\u6539\u4e86\u6703\u6709\u4ec0\u9ebc\u5f71\u97ff\uff0c\u6240\u4ee5\u8981\u5b8c\u5168\u4e86\u89e3\u6574\u4efdZone\u7684\u6587\u4ef6\u9700\u8981\u82b1\u5f88\u9577\u7684\u6642\u9593\u4f86\u6162\u6162\u7406\u89e3\uff0c\u4e5f\u8981\u6709\u78b0\u904e\u76f8\u95dc\u554f\u984c\u4e4b\u5f8c\u624d\u6703\u6162\u6162\u4e86\u89e3DNS\u7576\u4e2d\u7684\u904b\u4f5c\u6a21\u5f0f\uff0c\u6240\u4ee5\u6211\u6642\u5e38\u5728\u60f3\uff0c\u65e2\u7136 DNS \u8981\u8a2d\u5b9a\u7684\u5730\u65b9\u53c8\u4e0d\u591a\uff0c\u5132\u5b58\u9700\u6c42\u4e0d\u9ad8\uff0c\u90a3 DNS \u5728\u6a5f\u623f\u4f86\u8aaa\u7a69\u5b9a\u6027\u53c8\u662f\u90a3\u9ebc\u5730\u91cd\u8981\uff0c\u70ba\u4ec0\u9ebc\u6c92\u6709\u4eba\u628a\u5b83\u5beb\u6210\u50cf\u9632\u706b\u7246\u3001\u8ca0\u8f09\u5e73\u8861\u5668…\u985e\u4f3c\u9019\u4e9b\u7a0b\u5f0f\u8ddf\u8a2d\u5b9a\u90fd\u5957\u597d\u7684\u6a5f\u5668\uff0c\u53ea\u8981\u7528\u7db2\u9801\u7684\u7ba1\u7406\u4ecb\u9762\u9032\u53bb\u8a2d\u5b9aDNS\u8cc7\u8a0a\u5c31\u597d\u4e86\uff0c\u7a69\u5b9a\u6027\u6bd4\u8f03\u9ad8\uff0c\u7a81\u7136\u9593\u7684\u65b7\u96fb\u4e5f\u4e0d\u6015\u8aaaDNS\u4f3a\u670d\u5668\u7684\u786c\u789f\u639b\u6389\u5566\uff0c\u958b\u4e0d\u4e86\u6a5f\u5566\uff0c\u9019\u7a2e\u9ce5\u554f\u984c\u51fa\u73fe\uff0c\u5e0c\u671b\u6709\u5ee0\u5546\u6703\u770b\u5230\u6211\u7684\u5efa\u8a00\uff0c\u958b\u767c\u9019\u7a2e\u6771\u897f\u61c9\u8a72\u6703\u8cfa\u5427?<\/h4>\n

\u4ee5\u4e0b\u6211\u5be6\u4f5c\u7684\u6771\u897f\uff0c\u662f\u628a\u539f\u4f86DNS\u7528\u6a94\u6848\u5132\u5b58\u7ba1\u7406DNS\u8cc7\u8a0a\u6539\u6210\u7528MySQL\u4f86\u5132\u5b58\u7ba1\u7406DNS\u8cc7\u8a0a\uff0c\u800c\u4e14\u53ea\u8981\u6539\u4e86SQL\u7684\u8cc7\u8a0a\u5c31\u6703\u99ac\u4e0a\u751f\u6548\uff0c\u4e0d\u9700\u8981\u91cd\u65b0\u555f\u52d5\u670d\u52d9\u5594\u3002<\/p>\n

\u7ffb\u8b6f\u81ea: http:\/\/www.howtoforge.com\/installing-mydns-mydnsconfig-centos-5.1<\/a><\/p>\n

\u5b89\u88dd rpmforge.repo
\n# rpm -Uhv http:\/\/apt.sw.be\/packages\/rpmforge-release\/rpmforge-release-0.3.6-1.el5.rf.i386.rpm<\/a><\/p>\n

\u9019\u5957 MyDNS \u662f\u7d50\u5408 http+MySQL+phpmyadmin+DNS
\n# yum install httpd mysql-server php php-mysql php-mbstring phpmyadmin<\/p>\n

\u555f\u52d5 mysqld
\n# chkconfig mysqld on
\n# service mysqld start<\/p>\n

\u8a2d\u5b9a mysql \u7684 root \u5bc6\u78bc
\n# mysqladmin -u root password ‘password<\/font>‘
\n# mysqladmin -h localhost -u root password ‘password<\/font>‘<\/p>\n

\u8a2d\u5b9a phpmyadmin\uff0c\u589e\u52a0 #<\/font>\uff0c\u628a\u4e0d\u5fc5\u8981\u7684\u8a3b\u89e3\u6389
\n<\/font># vi \/etc\/httpd\/conf.d\/phpmyadmin.conf<\/p>\n

#<\/font><Directory “\/usr\/share\/phpmyadmin”>
\n#<\/font>\u00a0 Order Deny,Allow
\n#<\/font>\u00a0 Deny from all
\n#<\/font>\u00a0 Allow from 127.0.0.1
\n#<\/font><\/Directory><\/p>\n

Alias \/phpmyadmin \/usr\/share\/phpmyadmin
\nAlias \/phpMyAdmin \/usr\/share\/phpmyadmin
\nAlias \/mysqladmin \/usr\/share\/phpmyadmin<\/p>\n

\u7531 cookie \u6539\u6210 http
\n# vi \/usr\/share\/phpmyadmin\/config.inc.php
\n$cfg[‘Servers’][$i][‘auth_type’] = ‘http<\/font>‘; <\/p>\n

\u555f\u52d5 httpd
\n# chkconfig httpd on
\n# service httpd start<\/p>\n

\u767b\u5165 mysql \u5efa\u7acb database\uff0c\u65b0\u589e\u7ba1\u7406\u4f7f\u7528\u8005\uff0c\u8a18\u5f97 mysql \u7684 root \u5bc6\u78bc\u662f\u525b\u624d\u8a2d\u5b9a\u7684 password<\/font>\uff0c\u53ef\u81ea\u8a02\uff0c\u4f46\u662f\u65b0\u5efa\u7acb\u7684 mydns table \u88e1\u9762\u589e\u52a0\u7684\u4e00\u7d44\u5e33\u865f\/\u5bc6\u78bc\u662f mydns\/mydnspassword<\/font>\uff0c\u53ef\u81ea\u8a02\uff0c\u4f46\u8ddf mysql \u7684 root \u7684\u5bc6\u78bc\u7121\u95dc\uff0c\u662f\u53e6\u5916\u4e00\u7d44\u5e33\u865f\/\u5bc6\u78bc\u3002
\n# mysql -u root -p
\nEnter password: \u2190 \u8f38\u5165 password<\/font><\/p>\n

mysql> CREATE DATABASE mydns;
\nmysql> GRANT SELECT, INSERT, UPDATE, DELETE ON mydns.* TO ‘mydns<\/font>‘@’localhost’ IDENTIFIED BY ‘mydnspassword<\/font>‘;
\nmysql> GRANT SELECT, INSERT, UPDATE, DELETE ON mydns.* TO ‘mydns<\/font>‘@’localhost.localdomain’ IDENTIFIED BY ‘mydnspassword<\/font>‘;
\nmysql> FLUSH PRIVILEGES;
\nmysql> quit;<\/p>\n

# cd \/tmp
\n# wget http:\/\/mesh.dl.sourceforge.net\/sourceforge\/mydnsconfig\/MyDNSConfig-1.1.0.tar.gz
\n# tar xvfz MyDNSConfig-1.1.0.tar.gz
\n# cd MyDNSConfig-1.1.0<\/p>\n

\u5efa\u7acbmydns\u7db2\u9801\u76ee\u9304
\n# mkdir \/usr\/share\/mydnsconfig
\n\u628amydns\u7684\u7db2\u9801\u7a0b\u5f0f\u5167\u5bb9\u642c\u5230 \/usr\/share\/mydnsconfig \u88e1
\n# cp -rf interface\/* \/usr\/share\/mydnsconfig\/
\n\u5efa\u7acb\u9023\u7d50\u5230 \/var\/www\/html\/mydnsconfig\uff0c\u9019\u6a23\u7db2\u9801\u5c31\u80fd\u76f4\u63a5\u986f\u793a
\n# ln -s \/usr\/share\/mydnsconfig\/web\/ \/var\/www\/html\/mydnsconfig<\/p>\n

\u628a table \u8cc7\u6599\u704c\u5230 mydns database \u88e1
\n# mysql -u root -p mydns < install\/mydnsconfig.sql
\nEnter password: \u2190 \u8f38\u5165 password<\/font><\/p>\n

\u8a2d\u5b9a mydns \u8a2d\u5b9a\u6a94\uff0c\u8981\u6ce8\u610f\u5c0d\u61c9\u7684 database \u540d\u7a31\uff0c\u4f7f\u7528\u8005\u5e33\u865f\/\u5bc6\u78bc\u6709\u7121\u8ddf\u525b\u624d\u5efa\u7acb\u7684\u4e00\u81f4\u3002
\n# vi \/usr\/share\/mydnsconfig\/lib\/config.inc.php<\/p>\n

$conf[“db_type”]\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = ‘mysql’;<\/font>
\n$conf[“db_host”]\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = ‘localhost’;
\n$conf[“db_database”]\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = ‘mydns<\/font>‘;
\n$conf[“db_user”]\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = ‘mydns<\/font>‘;
\n$conf[“db_password”]\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = ‘mydnspassword<\/font>‘<\/p>\n

\u6e05\u6389 \/tmp\u88e1\u7684\u5b89\u88dd\u6a94
\ncd \/tmp
\nrm -rf MyDNSConfig-1.1.0\/
\nrm -f MyDNSConfig-1.1.0.tar.gz<\/p>\n

\u5b89\u88dd mydns-mysql\uff0cmydns \u8207 mysql \u6e9d\u901a\u7684\u4ecb\u9762
\n# wget http:\/\/mydns.bboy.net\/download\/mydns-mysql-1.1.0-1.i386.rpm
\n# rpm -ivh mydns-mysql-1.1.0-1.i386.rpm<\/p>\n

\u4e00\u6a23\u6ce8\u610fuser,password,database\u7b49\u8cc7\u8a0a\uff0c168.95.1.1 \u662f\u4e2d\u83ef\u96fb\u4fe1\u7684DNS\uff0c\u8a2d\u8d77\u4f86\u4e4b\u5f8c\u53ef\u4ee5 recursive \u5e6b\u4f7f\u7528\u8005\u81ea\u5df1\u672c\u8eab\u4ee5\u5916\u7684 domainname
\n# vi \/etc\/mydns.conf<\/p>\n

db-host = localhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # SQL server hostname
\ndb-user = mydns <\/font>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # SQL server username
\ndb-password = mydnspassword<\/font>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # SQL server password
\ndatabase = mydns<\/font>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # MyDNS database name<\/p>\n

recursive = 168.95.1.1<\/font>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # Location of recursive resolver
\nallow-axfr = yes <\/font>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # Should AXFR be enabled?
\nallow-tcp = yes\u00a0 <\/font>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # Should TCP be enabled?<\/p>\n

\u555f\u52d5 mydns
\n# chkconfig mydns on
\n# \/etc\/init.d\/mydns start<\/p>\n

\u8a2d\u5b9a\u597d\u4e00\u958b\u6a5f\u5c31\u80fd\u555f\u52d5 mydns
\n# cd \/etc\/rc.d\/rc3.d
\n# mv S52mydns S99mydns
\n# cd \/etc\/rc.d\/rc4.d
\n# mv S52mydns S99mydns
\n# cd \/etc\/rc.d\/rc5.d
\n# mv S52mydns S99mydns<\/p>\n

\u7ba1\u7406\u8005\u4ecb\u9762\u5c31\u662f\u900f\u904e\u7db2\u9801 http:\/\/<your_ip_address>\/mydnsconfig\/<\/a><\/p>\n

ex.http:\/\/192.168.1.102\/mydnsconfig\/index.php<\/a>\uff0c\u5efa\u8b70\u7528 IE<\/p>\n

\u5e33\u865f\/\u5bc6\u78bc\u9810\u8a2d\u5982\u4e0b
\nUsername: admin
\nPassword: admin<\/p>\n

\"4\"<\/a>\u00a0<\/p>\n

System \u2192 admin \u53ef\u4ee5\u8b8a\u66f4\u5bc6\u78bc<\/p>\n

\"5\"<\/a><\/p>\n

\"6\"<\/a><\/p>\n

DNS \u2192 Add New Zone \u65b0\u589e\u4e00\u7d44 Zone \u8cc7\u6599<\/p>\n

\"7\"<\/a><\/p>\n

\u00a0\"8\"<\/a><\/p>\n

Records \u2192 Add New Record \u65b0\u589e\u4e00\u7b46DNS\u7d00\u9304<\/p>\n

\"9\"<\/a><\/p>\n

\u00a0\"10\"<\/a><\/p>\n

\u5de6\u908a SOA \uff0c\u4f60\u6703\u767c\u73fe\u5b83\u5e6b\u4f60\u8a2d\u597d\u53cd\u89e3\u4e86! \"11\"<\/a><\/p>\n

\u9019\u6a23DNS\u5c31\u8dd1\u8d77\u4e86\u55ce?<\/p>\n

\u6c92\u932f DNS \u73fe\u5728\u5df2\u7d93\u8dd1\u8d77\u4f86\u56c9!<\/p>\n

\u7528\u672c\u6a5fDNS\u67e5\u770b\u770b
\n# dig @localhost test.vblog.tw<\/p>\n

; <<>> DiG 9.3.3rc2 <<>> @localhost test.vblog.tw
\n; (1 server found)
\n;; global options:\u00a0 printcmd
\n;; Got answer:
\n;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 40934
\n;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 0<\/p>\n

;; QUESTION SECTION:
\n;test.vblog.tw.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IN\u00a0\u00a0\u00a0\u00a0\u00a0 A<\/p>\n

;; ANSWER SECTION:
\ntest.vblog.tw.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 86400\u00a0\u00a0 IN\u00a0\u00a0\u00a0\u00a0\u00a0 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 192.168.1.100 <\/font><\/p>\n

;; Query time: 16 msec
\n;; SERVER: 127.0.0.1#53(127.0.0.1)
\n;; WHEN: Wed Dec 19 20:22:20 2007
\n;; MSG SIZE\u00a0 rcvd: 47<\/p>\n

\u672c\u5916\u9762\u5462?
\n# dig @localhost www.ccu.edu.tw<\/p>\n

;; ANSWER SECTION:
\nwww.ccu.edu.tw.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3600\u00a0\u00a0\u00a0 IN\u00a0\u00a0\u00a0\u00a0\u00a0 CNAME\u00a0\u00a0 hero1.ccu.edu.tw.
\nhero1.ccu.edu.tw.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3600\u00a0\u00a0\u00a0 IN\u00a0\u00a0\u00a0\u00a0\u00a0 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 140.123.5.5<\/font><\/p>\n

\u4e5f\u4e00\u6a23OK ^^<\/p>\n

\u67e5\u5916\u9762\uff0c\u56e0\u70ba\u6211\u5011\u525b\u525b\u6709\u8a2d\u4e86\u4e2d\u83ef\u96fb\u4fe1\u7684DNS 168.95.1.1\uff0c\u5982\u679c\u672c\u6a5f\u627e\u4e0d\u5230\u8cc7\u8a0a\u6703\u81ea\u52d5\u5e6b\u4f60\u5230\u5916\u9762\u627e\u7d66\u4f60\uff0cDNS \u4e2d\u7684 recursive \u7684\u610f\u601d\u5c31\u662f\u9019\u7a2e\u72c0\u6cc1\u3002\u3000<\/p>\n","protected":false},"excerpt":{"rendered":"

\u5176\u5be6\u6211\u89ba\u5f97 DNS \u4e0d\u592a\u597d\u67b6\uff0c\u4e0d\u592a\u597d\u67b6\u7684\u539f\u56e0\u5c31\u662f\u8aaa\u5b83\u9700\u8981\u6709\u77e5\u9053\u5f88\u591aDomain Know How \u518d\u4f86\u67b6 DN…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-413","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/posts\/413","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=413"}],"version-history":[{"count":1,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/posts\/413\/revisions"}],"predecessor-version":[{"id":5061,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/posts\/413\/revisions\/5061"}],"wp:attachment":[{"href":"https:\/\/blog.smallken.site\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}