COUPEL Cyril | 24 Jun 2010 02:58
Picon
Favicon

[SPAM]

www.lsk8.bestdrugstore-c.com

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
COUPEL Cyril | 25 Jun 2010 01:11
Picon
Favicon

[SPAM]

www.tmu7.bestdrugstore-c.com

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
Михаил Продан | 1 Jul 2010 22:37
Picon

Error in mysql_dlz

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)


Gmane