Re: problem with zone delegation

You also need to update the lookup query and put @lab_Host <>'@'



This is what I've done


	SELECT TNZ.nb_SoaTtl  AS ttl,
           TNR.lab_Type   AS type,
           TNR.lab_Weight AS mx_priority,
           TNR.lab_Data   AS data
	FROM   T_NsZone TNZ
	INNER JOIN T_NsRecord TNR ON  TNR.id_NsZone = TNZ.id_NsZone
                              AND TNR.lab_Host = @lab_Host
				       AND (TNR.lab_Type <> 'NS' OR
@lab_Host <>'@')
	WHERE  TNZ.lab_ZoneName = @lab_ZoneName
	ORDER BY TNR.id_NsRecord

Ps: soa records are in T_NsZone for me.

I think its something like that in mysql

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


-----Message d'origine-----
De : [email protected]
[mailto:[email protected]] De la part de Todd
Lyons
Envoyé : vendredi 23 mai 2008 18:26
À : [email protected]
Objet : Re: [Bind-dlz-testers] problem with zone delegation

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, May 23, 2008 at 06:07:17AM -0700, Rob Butler wrote:

>Update your authority query to only return results where host = '@'.
>
>select ttl, type, data, resp_person, serial, refresh, retry, expire,
minimum
>         from dns_records where zone = '%zone%' and (type = 'SOA' or
type='NS') 
>        and host ='@'
>
>----- Original Message ----
>From: Igor Serebryany <[email protected]>
>To: [email protected]
>Sent: Thursday, May 22, 2008 6:28:02 PM
>Subject: [Bind-dlz-testers] problem with zone delegation
>
>
>hi,
>
>    i think i may have discovered a bug in bind-dlz.  I am attempting to
>    delegate a zone to outside nameservers.  my mysql database has data
>    that looks like this (irrelevant fields omited):
>host    type    data                zone
>@        ns        ns1.myserver.com.    example.com
>@        ns        ns2.myserver.com.    example.com
>sub        ns        ns1.external.com.    example.com
>sub        ns        ns2.external.com.    example.com

You're creating sub-zones for authoritative dns.  The @ and type ns
indicates that it's a nameserver entity.  Try changing the data for your
sub-zone to:
  @        ns        ns1.external.com.    sub.example.com
  @        ns        ns2.external.com.    sub.example.com

I think that's what Rob was referring to when he posted his example
above.
- -- 
Regards...		Todd
Chris: grep 500 sendmail.mc 
undefine(`FAIL_MAIL_OVER_500_MILES')dnl
Chris: just in case ...
Linux kernel 2.6.22-14-generic   3 users,  load average: 0.08, 0.03, 0.01
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFINvARY2VBGxIDMLwRAkjrAJwN+Q+4JJxvQKIbLE8cPAebzDMazACcDX6i
df4YiePy2ohnHR6aOqdUJAY=
=GVN4
-----END PGP SIGNATURE-----

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bind-dlz-testers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers




-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/