BIND 9.7.1 with dlz(mysql)
ShanyiWan
wsy at 114.com.cn
Wed Jun 30 02:20:01 UTC 2010
Cent OS 5.4(32bit) +mysql 5.1.48
# /usr/local/bind/sbin/named -c /usr/local/bind/etc/named.conf -u named -g -d 1
30-Jun-2010 10:16:39.071 starting BIND 9.7.1 -c /usr/local/bind/etc/named.conf -u named -g -d 1
30-Jun-2010 10:16:39.071 built with '--prefix=/usr/local/bind' '--with-dlz-mysql=/usr/local/mysql' '--enable-threads=no' '--enable-largefile'
30-Jun-2010 10:16:39.071 using up to 4096 sockets
30-Jun-2010 10:16:39.077 loading configuration from '/usr/local/bind/etc/named.conf'
30-Jun-2010 10:16:39.078 reading built-in trusted keys from file '/usr/local/bind/etc/bind.keys'
30-Jun-2010 10:16:39.079 using default UDP/IPv4 port range: [1024, 65535]
30-Jun-2010 10:16:39.080 using default UDP/IPv6 port range: [1024, 65535]
30-Jun-2010 10:16:39.081 listening on IPv4 interface lo, 127.0.0.1#53
30-Jun-2010 10:16:39.082 listening on IPv4 interface eth0, 192.168.146.155#53
30-Jun-2010 10:16:39.082 generating session key for dynamic DNS
30-Jun-2010 10:16:39.082 Loading 'Mysql zone' using driver mysql
30-Jun-2010 10:16:39.082 Required token $zone$ not found.
30-Jun-2010 10:16:39.082 Could not build find zone query list
30-Jun-2010 10:16:39.082 mysql driver could not create database instance object.
Segmentation fault
named.conf :
options {
directory "/usr/local/bind/";
allow-query { any; };
allow-query-cache { any; };
recursion no;
pid-file "var/run/named.pid";
};
logging
{
channel query_log
{
file "query.log" versions 3 size 20m;
severity info;
print-time yes;
print-category yes;
};
category queries
{
query_log;
};
};
controls {
inet 127.0.0.1 port 953
allow { 127.0.0.1; } keys { "rndc-key"; };
};
dlz "Mysql zone" {
database "mysql
{host=localhost dbname=mydns_data ssl=false ssl=false port=3306 user=root pass=password}
{select zone from dns_records where zone = '%zone%'}
{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 from dns_records where zone = '%zone%' and host = '%record%'}";
};
include "etc/rndc.key";
--------------
ShanyiWan
2010-06-30
More information about the bind-users
mailing list