Re: dns_sdlz_putrr error

Could it be that the type column in your DB is all lower case and it needs to be upper case?

----- Original Message ----
From: Erol <[email protected]>
To: [email protected]
Sent: Thursday, March 27, 2008 12:35:16 PM
Subject: Re: [Bind-dlz-testers] dns_sdlz_putrr error

Im using the default queries and data that come along with
bind-dlz.

dlz "Mysql zone" {
    database "mysql
    {host=localhost dbname=dns_records user=binddlz pass=******  ssl=false}

    {select zone from records where zone = '%zone%'}

    {select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"') else data end from 
        records where zone = '%zone%' and host = '%record%' and not (type = 'SOA' or type = 'NS')}

    {select ttl, type, mx_priority, data , resp_person, serial refresh, retry, expire, minimum  from records 
        where zone = '%zone%' and (type = 'SOA' or type='NS')}

    {select ttl, type, host, mx_priority, data, resp_person, serial, refresh, retry, expire,  minimum from records
        where zone = '%zone%' and not (type = 'SOA' or type ='NS')}  
   
    {select zone from xfr_table where zone = '%zone%' and client = '%client%'}

    {update data_count set count = count + 1 where zone ='%zone%'}";
};

Data sample:

zone, host, ttl, type, mx_priority, data, adminEmail, serial,
refresh, retry, expire, minimum
"grandchild0ren.net","@","10","ns","","ns1.grandchild0ren.net.","","","","","",""
"grandchild0ren.net","@","10","ns","","ns2.grandchild0ren.net.","","","","","",""
"grandchild0ren.net","@","10","mx","10","grandchild0ren.net.","","","","","",""
"grandchild0ren.net","@","10","a","","127.0.0.1","","","","","",""
"grandchild0ren.net","@","10","soa","","ns1.grandchild0ren.net.","root.grandchild0ren.net.","2","28000","2800","64800","10"
"grandchild0ren.net","necta0ry","10","a","","127.0.0.1","","","","","",""
"grandchild0ren.net","necta0ry","10","mx","10","grandchild0ren.net.","","","","","",""
"grandchild0ren.net","artfuln0ess","10","a","","127.0.0.1","","","","","",""
"grandchild0ren.net","artfuln0ess","10","mx","10","grandchild0ren.net.","","","","","",""

The data I took from the bind-dlz download page (the dns_data csv file).

Ive got this setup according to the docs as I just want to get it
running to perform some tests before I point it at our own data.

Thanks,
/erol



On Thu, Mar 27, 2008 at 08:37:21AM -0700, Rob Butler wrote:
> Either your queries or the data in your DB are incorrect.  Send the DLZ segment of your named.conf (be sure to change/remove DB pw first) and a sample of your data.
> 
> Rob
> 
> ----- Original Message ----
> From: Erol <[email protected]>
> To: [email protected]
> Sent: Thursday, March 27, 2008 10:54:54 AM
> Subject: [Bind-dlz-testers] dns_sdlz_putrr error
> 
> Hello,
> 
> I've been fiddling with bind-dlz for the past few days.
> Ive got bind 9.3.1 compiled with the dlz patch and things *seem*
> to be working - by this I mean bind starts up and does not
> complain about anything bind-dlz related.
> 
> Now when I start bind and run some queries against it (using the
> test data provided on the bind-dlz download site) I am getting the
> following error back from bind:
> 
> 27-Mar-2008 10:47:24.651 dns_sdlz_putrr returned error. Error code was: unknown class/type
> 27-Mar-2008 10:47:24.651 dns_sdlz_putrr returned error. Error code was: unknown class/type
> 
> This happens when I query any type of record for a zone in the
> database. To make matters more interesting, when I run the actual
> sql queries that are beind used (I pull them from the mysql.log)
> they are returning the proper info.
> 
> Anyone else hit this wall before?
> Ive sifted through the archives but was unable to find anything
> relating to this problem.
> 
> Thanks,
> /erol
> 
> -- 
> [email protected]
> easyDNS Technologies Inc.
> 
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> Bind-dlz-testers mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
> 
> 
> 
> 
> 
>       ____________________________________________________________________________________
> Looking for last minute shopping deals?  
> Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping
> 
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> Bind-dlz-testers mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
> 
-- 
[email protected]
easyDNS Technologies Inc.

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Bind-dlz-testers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers





      ____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace