Hello all,
Recently I've installed bind9 (ubuntu version) wirh backend MySQL, but I'm
having some problems with the reverse lookup.
I've configured the named.conf.local file with the following string but bind is
not accepting it.
dlz "Mysql zone" {
database "mysql
{host=127.0.0.1 dbname=db_name user=db_user pass=db_pass}
{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$' and not (type = 'SOA'
or type = 'NS')}
{}
{select zone from reverse_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
reverse_records where zone = '$zone$' and host = '$record$' and not (type =
'SOA' or type = 'NS')}";
};
Since with the TXT named.conf.file, the reverse lookup is a different zone, I
presume I had to create a second database to store its records. Can anyone help
me solve this problem? I've search in many discussion lists and everyone
complain abou the difficulty to set up the reverse lookup with MySQL as backend.
Regards
Alex
_______________________________________________
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
