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 _______________________________________________ bind-users mailing list bind-users@lists.isc.org https://lists.isc.org/mailman/listinfo/bind-users