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
_______________________________________________ Please visit https://lists.isc.org/mailman/listinfo/bind-users to unsubscribe from this list bind-users mailing list bind-users@lists.isc.org https://lists.isc.org/mailman/listinfo/bind-users