Re: dns_sdlz_putrr error

Erol <[email protected]> Thu, 27 Mar 2008 13:57:45 -0400
Newsgroups	gmane.network.dns.bind9.dlz
Message-ID	<[email protected]>
On Thu, Mar 27, 2008 at 10:21:50AM -0700, Rob Butler wrote:
> Could it be that the type column in your DB is all lower case and it needs to be upper case?

Ok, I found out what caused my issue. In a nutshell it was me. I
had messed up the data before inserting it into the DB (screwed up
the columns when I loaded the data file).

Ive got that fixed and Ive got the data back in the DB.
Now when I run a query I get an answer back, but only for
subdomains.

Example:

dig @127.0.0.1 artfuln0ess.grandchild0ren.net a

;; ANSWER SECTION:
artfuln0ess.grandchild0ren.net. 10 IN   A       127.0.0.1

dig @127.0.0.1 grandchild0ren.net a

And there is no answer section, though it should come back with
the same as above (as they both point to 127.0.0.1).

Im using the same sql as you see below.

I've also noticed that I'm getting the following error for every
query , regardless as to whether it is successful or not.


27-Mar-2008 13:54:43.109 client 127.0.0.1#32819: query: artfuln0ess.grandchild0ren.net IN A +
27-Mar-2008 13:54:43.110 dns_rdata_fromtext: buffer-0xbf916274:1: near '0': extra input text
27-Mar-2008 13:54:43.110 dns_sdlz_putrr returned error. Error code was: extra input text

This is really starting to hurt my head .... any help would be
most appreciated.

Thanks,
/erol

> ----- 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
> _______________________________________________
> 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