Re: [Bind-dlz-testers] Installing DLZ
Brought to you by:
crodster
|
From: Rob B. <rob...@ve...> - 2004-06-23 00:44:20
|
It's probably a problem with your data in the database and not the queries
you are runnig. The uncommented DLZ config is good if you are serving txt
records and they do not have the double quotes in the record itself. If you
are not going to have txt records in your DB, or if you are storing the txt
records properly (the data in the DB for the txt record includes the double
quotes) then you should use the version of your config that is commented.
It's a simpler query and thus should run faster.
When DLZ spits the "near eof: unexpected end of input" it means it did not
get all the data it needed to construct the DNS data record in Bind. I know
these error messages are a little cryptic, but the functions that parse the
DNS data at runtime for DLZ are the same ones that would parse the zone
files at startup time.. The error messages in those functions were written
with files in mind, not DLZ type functionality.
As I said in another message, A and NS records need a ttl, type and data to
be returned and ONLY those pieces of data. MX records need all of that plus
the mx_priority. SOA should have a ttl, type, data, responsible_person,
refresh, retry, expire, minimum. If all those fields are not supplied you
will have the "near eof:..." message.
Hope this helps. If you need more help try sending a SMALL sample of your
data to the list so we can see what's not right.
Later
Rob
----- Original Message -----
From: "Mailer ADCD3" <ma...@sc...>
To: <bin...@li...>
Sent: Tuesday, June 22, 2004 8:07 PM
Subject: Re: [Bind-dlz-testers] Installing DLZ
> Hi to all ,
>
> Im having all kinds of problems in the test im running , at the beggining
a
> domain was showing A records OK but didnt returne SOA values
> I played with the table(work with 1 table now) chenged from varchar back
to
> text fields , and checked with double quatas also ,
> None worked ok , then i swiched back to varchars insted of text fields
type
> :
>
> Jun 22 18:33:18.655 running
> Jun 22 18:33:26.564 dns_rdata_fromtext: buffer-0xbfffe390:1: near eof:
> unexpected end of input
> Jun 22 18:33:26.564 dns_sdlz_putrr returned error. Error code was:
> unexpected end of input
> Jun 22 18:33:26.567 dns_rdata_fromtext: buffer-0xbfffe0d0:1: near eof:
> unexpected end of input
> Jun 22 18:33:26.568 dns_sdlz_putrr returned error. Error code was:
> unexpected end of input
> Jun 22 18:33:26.569 query.c:1746: fatal error:
> Jun 22 18:33:26.569 RUNTIME_CHECK(result == 0) failed
> Jun 22 18:33:26.570 exiting (due to fatal error in library) swichwed back
to
> varchar insted of text fileds , now im getting this :
>
> after querieng the test domain .
>
> It simply very hard to test when you realy dont know exactly how the right
> SQL should be , syntax etc , for e.g
> I saw in few posts that people uses " in the SQL queries rather then ' , "
> gived error after starting the server with ' it works
> so im getting realy confused with the 2 syntaxes .
>
> It would be great and time saver if someone can post a working sample that
> returened A and SOA records with real values
> to see how its should be . My confugurations are as follow :
>
> On named.conf :
>
> dlz "Mysql zone" {
>
> database "mysql
>
> {host=69.93.197.20 dbname=test user=test pass=test ssl=false}
>
> {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%'}";
>
> };
>
> #dlz "mysql zone" {
>
> # database "mysql
>
> # {host=69.93.197.20 dbname=test user=test pass=test ssl=false}
>
> # {select zone from dns_records where zone = '%zone%'}
>
> # {select ttl, type, mx_priority, data, resp_person, serial, refresh,
>
> #retry, expire, minimum from dns_records where zone ='%zone%' and host =
> '%record%'}";
>
> #};
>
> Im testing the 2 confurations , and play with the options there .
>
> The DB schema(mysql) is the same as in the examples exepts the fields type
> wich i changed from TEXT to varchar and added a preamble field named id .
>
>
>
> Thanks for any help ,
>
> Regards ,
>
>
>
>
>
>
>
>
>
>
>
> Email scaned by ClamAV antivirus engine
> -------------------------------------------------------------------
> ----- Original Message -----
> From: "Mailer ADCD3" <ma...@sc...>
> To: <bin...@li...>
> Sent: Tuesday, June 22, 2004 7:05 PM
> Subject: Re: [Bind-dlz-testers] Installing DLZ
>
>
> > Hi ,
> >
> > I just updated the root registration of a name server to a test server
im
> > gonna test for a while . Till it will update just a questune
> > Is it possible to change the TEXT fileds type to varchar's ? if yes what
> > basilcy will be faster and less load for the server in general .
> >
> > Other thing regarding the tables , iv notices that few workes with 2
> tables
> > 1 holding just the root zones and another table just for records ,
> > Is this a better thing to do regarding performance in mind .
> >
> > Thanks ,
> >
> >
> >
> >
> >
> > Email scaned by ClamAV antivirus engine
> > -------------------------------------------------------------------
> > ----- Original Message -----
> > From: "Rob Butler" <rob...@ve...>
> > To: <bin...@li...>
> > Sent: Tuesday, June 22, 2004 8:53 AM
> > Subject: Re: [Bind-dlz-testers] Installing DLZ
> >
> >
> > > You probably need GNU patch. The patch program supplied by solaris
> > probably
> > > won't work right for the patch file that is supplied by DLZ. You can
> > google
> > > for "gnu patch solaris" and find a bunch of places to get the patch
> > program
> > > in source or binary form.
> > >
> > > Later
> > > Rob
> > > ----- Original Message -----
> > > From: "Bryan Koches" <dns...@co...>
> > > To: <bin...@li...>
> > > Sent: Monday, June 21, 2004 3:28 PM
> > > Subject: RE: [Bind-dlz-testers] Installing DLZ
> > >
> > >
> > > > Bah. I found out part of my problem. I actually had 9.2.3. I've
> > > > downloaded 9.2.2 but now I get the following:
> > > >
> > > > 67 out of 68 hunks failed: saving rejects to
> > > bind-9.2.2/bin/Makefile.in.rej
> > > >
> > > > Is this a permissions problem? What is causing the hunks to fail?
> > > >
> > > > Bryan
> > > >
> > > > -----Original Message-----
> > > > From: bin...@li...
> > > > [mailto:bin...@li...] On Behalf Of
> Bryan
> > > > Koches
> > > > Sent: Monday, June 21, 2004 2:23 PM
> > > > To: bin...@li...
> > > > Subject: [Bind-dlz-testers] Installing DLZ
> > > >
> > > > I am trying to get the dlz to patch but I get the following:
> > > >
> > > > patch -p0 < dlz.patch
> > > > Looks like a unified context diff.
> > > > File to patch:
> > > >
> > > > What am I doing wrong?
> > > >
> > > > I am running on the following platform:
> > > > Solaris 9
> > > > BIND 9.2.2
> > > > DLZ 0.7.0
> > > >
> > > > Bryan
> > > >
> > > >
> > > >
> > > > -------------------------------------------------------
> > > > This SF.Net email sponsored by Black Hat Briefings & Training.
> > > > Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
> > > > digital self defense, top technical experts, no vendor pitches,
> > > > unmatched networking opportunities. Visit www.blackhat.com
> > > > _______________________________________________
> > > > Bind-dlz-testers mailing list
> > > > Bin...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
> > > >
> > > >
> > > >
> > > > -------------------------------------------------------
> > > > This SF.Net email sponsored by Black Hat Briefings & Training.
> > > > Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
> > > > digital self defense, top technical experts, no vendor pitches,
> > > > unmatched networking opportunities. Visit www.blackhat.com
> > > > _______________________________________________
> > > > Bind-dlz-testers mailing list
> > > > Bin...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
> > > >
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.Net email sponsored by Black Hat Briefings & Training.
> > > Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
> > > digital self defense, top technical experts, no vendor pitches,
> > > unmatched networking opportunities. Visit www.blackhat.com
> > > _______________________________________________
> > > Bind-dlz-testers mailing list
> > > Bin...@li...
> > > https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
> > >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email sponsored by Black Hat Briefings & Training.
> > Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
> > digital self defense, top technical experts, no vendor pitches,
> > unmatched networking opportunities. Visit www.blackhat.com
> > _______________________________________________
> > Bind-dlz-testers mailing list
> > Bin...@li...
> > https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
> >
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by Black Hat Briefings & Training.
> Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
> digital self defense, top technical experts, no vendor pitches,
> unmatched networking opportunities. Visit www.blackhat.com
> _______________________________________________
> Bind-dlz-testers mailing list
> Bin...@li...
> https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
>
|