Re: Authority Issue with Primary DNS - URGENT

Ok.  I solved the problem by adding the SOA/NS lookup to my config.

view "external" {
match-clients { any; };

zone "." {
type hint;
file "root.hints";
};

dlz "Mysql zone" {
database "mysql
{host=localhost dbname=dns_external user=dns pass=password}
{select zone from 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 records
   where zone = '%zone%' and host = '%record%'}
{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, case when lower(type)='txt' then
   concat('\"', data, '\"') else data end, resp_person, serial, refresh,
retry, expire,
   minimum from records where zone = '%zone%'}
{select zone from xfr where zone = '%zone%' and client = '%client%'}";
};
};
Now I am seeing a different problem.  Whenever I query our domain (
boingo.com) I get my ns1.boingo.com nameserver listed twice.  I am assuming
this is because of the SOA record and the NS record that I have it entered
in, but its causing testing to fail on it with a warning.

Any ideas?

Thanks,

On Tue, Apr 22, 2008 at 11:59 AM, Todd Lyons <[email protected]> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Tue, Apr 22, 2008 at 11:34:06AM -0700, Michael J. Ayers wrote:
>
> >     [root@symbiotic ~]# dig @EXTERNAL IP [1]signup.example.com
>
> I verified that it works as expected on mine.
>
> >     mysql> select ttl, type, mx_priority, data, resp_person, serial,
> >     refresh, retry, expire, minimum from records where zone =
> >     '[8]example.com' and (type = 'SOA' or type='NS');
>
> You look like you're using the split query way of doing things because
> you have separate fields for resp_person, serial, refresh, etc.  Post
> your config here so others can look it over.
>
> >   It should be returning all four entries. I cannot figure out what the
> >   problem is. Any ideas?
>
> Your query looks right to me, but it's good to compare the prerequisite
> queries as well.
> - --
> Regards...              Todd
> Since the creation of the Internet, the Earth's rotation has been
> fueled, primarily, by the collective spinning of English teachers
> in their graves.                               --Random IRC Quote
> Linux kernel 2.6.22-14-generic  10 users,  load average: 0.00, 0.03, 0.01
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFIDjWMY2VBGxIDMLwRAtI8AJ9DpKFcLRTlL7WHpYyUVpfhj6ZehACeKEh4
> HVNoLl/nDXeiwgX16CUnKNc=
> =9V2z
> -----END PGP SIGNATURE-----
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save $100.
> Use priority code J8TL2D2.
>
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> Bind-dlz-testers mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
>



-- 
Michael J. Ayers
Senior Systems Engineer

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone

_______________________________________________
Bind-dlz-testers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers