Hi,everyone, I have some trouble when I build a DNS server.
I need use mysql stored procedure work with the bind dlz mysql driver, but failed.
Can anyone give me some advice? Thanks very much.

dlz "Mysql zone" {
database "mysql
{host=127.0.0.1 dbname=dnsdata ssl=false}
{select domain from domains where domain='$zone$' LIMIT 1}
{call getrr('$zone$','SOME_ISP','$record$')}";

CREATE PROCEDURE `getrrr`(
IN inzone VARCHAR(255), IN inview VARCHAR(255),IN inrecord VARCHAR(255)
)
BEGIN
DECLARE lcount INT DEFAULT 0;
DECLARE dcount INT DEFAULT 0;
SELECT COUNT(*) INTO lcount FROM rr WHERE domain=inzone and view=inview and host=inrecord and active='Y';
SELECT COUNT(*) INTO dcount FROM rr WHERE domain=inzone and view like '%UNICOM' and host=inrecord and active='Y';

IF lcount != 0 THEN
SELECT ttl,type,mx_priority,data FROM rr WHERE domain=inzone and view=inview and active='Y' and host=inrecord;
ELSEIF dcount != 0 THEN
SELECT ttl,type,mx_priority,data FROM rr WHERE domain=inzone and view like '%UNICOM' and active='Y' and host=inrecord;
ELSE
SELECT ttl,type,mx_priority,data FROM rr WHERE domain=inzone and active='Y' and host=inrecord;
END IF;

select ttl,type,mx_priority,IF(type='SOA',concat_ws(' ',data,mbox,serial,refresh,retry,expire,minimum),data) from soa where domain=inzone;
END//

Would you please elaborate on what you mean by failed? What error messages are you getting, what is working and what is not working, etc.

Does your zone information work and get loaded properly by Bind when you don't try to configure it through MySQL? Do other zones work?

Have a look at this page. There are some particular warnings about using the DLZ driver with MySQL.