how to run dlz and non-dlz in one server?

[houguanghua]

Dear all,
 
Anyone know how to configure muliti-view and non-view in one bind server? Furthermore using mysql to support muliti-view and non-view simultanuasly.
 
I tried to configure it, but failed.
 
Following configuration is added into named.conf, but it doesn't work. Note that  view 'ALL' isn't under any view
dlz "Mysql zone" {
 database " mysql
  {host=127.0.0.1 dbname=cdn ssl=false port=3306 user=cdn pass=cdn }
  {select zone from dns_records where zone = '$zone$' and view='ALL' limit 1}
  {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 as mydata from dns_records where zone = '$zone$' and host = '$record$' and view='ALL'}
  {}
  {select ttl, type, host, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"') else data end as mydata, resp_person, serial, refresh, retry, expire, minimum from dns_records where zone = '$zone$' and view='ALL'}
  {select zone from xfr_table where zone = '$zone$' and client = '$client$' and view='ALL' limit 1}
  {update data_count set count = count + 1 where zone ='$zone$' and view='ALL'}";
}; 
 
Best regards, Guanghua 

 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/bind-users/attachments/20150423/9ef1eecc/attachment.html>