Error in mysql_dlz
Михаил Продан <1099511627776 <at> mail.ru>
2010-07-01 20:37:55 GMT
Hello,
I have such a problem:
bind 9.7.1 with dlz mysql enabled
named.conf:
dlz "mysql zone" {
database "mysql {host=192.168.170.220 port=3306 dbname=dyn_dns user=dynuser pass=dynpdw ssl=false}
{select zone from dns_records where zone = '%zone%'}
{select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"') else data end
from dns_records where zone = '%zone%
' and host = '%record%' and not (type = 'SOA' or type = 'NS')}
{select ttl, type, mx_priority, data, resp_person, serial, refresh, retry, expire, minimum from
dns_records where zone = '%zone%' and (type =
'SOA' or type='NS')}
{select ttl, type, host, mx_priority, data, resp_person, serial, refresh, retry, expire, minimum from
dns_records where zone = '%zone%' and n
ot (type = 'SOA' or type = 'NS')}
{select zone from xfr_table where zone = '%zone%' and client = '%client%'}
{update data_count set count = count + 1 where zone ='%zone%'}";
};
But when i start bind an error occurs. The log as follows:
vpn# named -g
01-Jul-2010 23:35:10.819 starting BIND 9.7.1 -g
01-Jul-2010 23:35:10.819 built with '--localstatedir=/var' '--disable-linux-caps'
'--disable-symtable' '--with-randomdev=/dev/random' '--with-openssl=/usr'
'--with-libxml2=/usr/local' '--without-idn' '--with-dlz-mysql=yes' '--disable-threads'
'--sysconfdir=/etc/namedb' '--prefix=/usr' '--mandir=/usr/share/man'
'--infodir=/usr/share/info/' '--build=i386-portbld-freebsd7.2'
'build_alias=i386-portbld-freebsd7.2' 'CC=cc' 'CFLAGS=-O2 -fno-strict-aliasing -pipe'
(Continue reading)