Bind9 backend MySQL reverse lookup problem

[Alexandre Vilarinho]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/bind-users/attachments/20150918/6462c121/attachment-0001.html>