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