Re: dns_sdlz_putrr error
Erol <[email protected]>
| Newsgroups | gmane.network.dns.bind9.dlz |
|---|---|
| Message-ID | <[email protected]> |
Hold off on this, again I found the issue (with a little help from Google). Basically the query is returning more data than bind-dlz wants/needs for the query. Thanks, /erol On Thu, Mar 27, 2008 at 01:57:45PM -0400, Erol wrote: > 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 > _______________________________________________ > 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