Re: Help, I can´t make a dele gation :(

Thanks Todd, for giving me encouragement.

Yess Todd, all queries are over tip-server, and sorry, was "soa" and no "so" the type.

Making the changes that you suggested, I can't get an answer for "dig ns us.example.com @127.0.0.1"

I was reading the named's outputs (named -f -g) and when I ask for "dig ns us.example.com @127.0.0.1", it's look correct and return what I expected, take a look:

06-Jun-2009 13:14:44.734 279 query is 'select dns_zone from dns_records where dns_zone= 'us.example.com' limit 1'
06-Jun-2009 13:14:44.734 279 executing query for 0 time
06-Jun-2009 13:14:44.736 279 rs ok
06-Jun-2009 13:14:44.736 279 cleaning up
06-Jun-2009 13:14:44.736 279 unlocking mutex
06-Jun-2009 13:14:44.736 279 returning
06-Jun-2009 13:14:44.737 139 Getting DBI
06-Jun-2009 13:14:44.737 139 Got DBI - checking query
06-Jun-2009 13:14:44.737 139 checked query
06-Jun-2009 13:14:44.737 139 did zone
06-Jun-2009 13:14:44.737 139 did record
06-Jun-2009 13:14:44.737 139 did client
06-Jun-2009 13:14:44.737 139 built query
06-Jun-2009 13:14:44.737 139 query is '
SELECT ttl, dns_type, mx_priority, data
FROM dns_records WHERE dns_zone='us.example.com' AND host='@';
'
06-Jun-2009 13:14:44.737 139 executing query for 0 time
06-Jun-2009 13:14:44.737 139 rs ok
06-Jun-2009 13:14:44.737 139 cleaning up
06-Jun-2009 13:14:44.737 139 unlocking mutex
06-Jun-2009 13:14:44.737 139 returning
06-Jun-2009 13:14:44.738 545 Getting DBI
06-Jun-2009 13:14:44.738 545 Got DBI - checking query
06-Jun-2009 13:14:44.738 545 cleaning up
06-Jun-2009 13:14:44.738 545 unlocking mutex
06-Jun-2009 13:14:44.738 545 returning

I do not understand why when I ask for test.us.example.com, the us.example.com can't be reached, take a look now and pay attention about the last query:

06-Jun-2009 13:15:14.012 674 query is 'select dns_zone from dns_records where dns_zone= 'test.us.example.com' limit 1'
06-Jun-2009 13:15:14.012 674 executing query for 0 time
06-Jun-2009 13:15:14.014 674 rs ok
06-Jun-2009 13:15:14.014 674 cleaning up
06-Jun-2009 13:15:14.014 674 unlocking mutex
06-Jun-2009 13:15:14.014 674 returning
06-Jun-2009 13:15:14.014 120 Getting DBI
06-Jun-2009 13:15:14.014 120 Got DBI - checking query
06-Jun-2009 13:15:14.014 120 checked query
06-Jun-2009 13:15:14.015 120 did zone
06-Jun-2009 13:15:14.015 120 did record
06-Jun-2009 13:15:14.015 120 did client
06-Jun-2009 13:15:14.015 120 built query
06-Jun-2009 13:15:14.015 120 query is 'select dns_zone from dns_records where dns_zone= 'us.example.com' limit 1'
06-Jun-2009 13:15:14.015 120 executing query for 0 time
06-Jun-2009 13:15:14.015 120 rs ok
06-Jun-2009 13:15:14.015 120 cleaning up
06-Jun-2009 13:15:14.015 120 unlocking mutex
06-Jun-2009 13:15:14.015 120 returning
06-Jun-2009 13:15:14.015 822 Getting DBI
06-Jun-2009 13:15:14.015 822 Got DBI - checking query
06-Jun-2009 13:15:14.015 822 checked query
06-Jun-2009 13:15:14.015 822 did zone
06-Jun-2009 13:15:14.015 822 did record
06-Jun-2009 13:15:14.015 822 did client
06-Jun-2009 13:15:14.016 822 built query
06-Jun-2009 13:15:14.016 822 query is '
SELECT ttl, dns_type, mx_priority, data
FROM dns_records WHERE dns_zone='us.example.com' AND host='test';
'
06-Jun-2009 13:15:14.016 822 executing query for 0 time
06-Jun-2009 13:15:14.016 822 rs ok
06-Jun-2009 13:15:14.016 822 cleaning up
06-Jun-2009 13:15:14.016 822 unlocking mutex
06-Jun-2009 13:15:14.016 822 returning
06-Jun-2009 13:15:14.016 291 Getting DBI
06-Jun-2009 13:15:14.016 291 Got DBI - checking query
06-Jun-2009 13:15:14.016 291 checked query
06-Jun-2009 13:15:14.016 291 did zone
06-Jun-2009 13:15:14.016 291 did record
06-Jun-2009 13:15:14.016 291 did client
06-Jun-2009 13:15:14.016 291 built query
06-Jun-2009 13:15:14.016 291 query is '
SELECT ttl, dns_type, mx_priority, data
FROM dns_records WHERE dns_zone='us.example.com' AND host='*';
'
06-Jun-2009 13:15:14.016 291 executing query for 0 time
06-Jun-2009 13:15:14.017 291 rs ok
06-Jun-2009 13:15:14.017 291 cleaning up
06-Jun-2009 13:15:14.017 291 unlocking mutex
06-Jun-2009 13:15:14.017 291 returning
06-Jun-2009 13:15:14.017 56 Getting DBI
06-Jun-2009 13:15:14.017 56 Got DBI - checking query
06-Jun-2009 13:15:14.017 56 checked query
06-Jun-2009 13:15:14.017 56 did zone
06-Jun-2009 13:15:14.017 56 did record
06-Jun-2009 13:15:14.017 56 did client
06-Jun-2009 13:15:14.017 56 built query
06-Jun-2009 13:15:14.017 56 query is '
SELECT ttl, dns_type, mx_priority, data
FROM dns_records WHERE dns_zone='us.example.com' AND host='@';
'
06-Jun-2009 13:15:14.017 56 executing query for 0 time
06-Jun-2009 13:15:14.018 56 rs ok
06-Jun-2009 13:15:14.018 56 cleaning up
06-Jun-2009 13:15:14.018 56 unlocking mutex
06-Jun-2009 13:15:14.018 56 returning
06-Jun-2009 13:15:14.018 225 Getting DBI
06-Jun-2009 13:15:14.018 225 Got DBI - checking query
06-Jun-2009 13:15:14.018 225 cleaning up
06-Jun-2009 13:15:14.018 225 unlocking mutex
06-Jun-2009 13:15:14.018 225 returning

The last query was perfectly returned when I ask for "dig ns us.example.com @127.0.0.1" previously, so, why now this information is not providing to reach the us.example.com server ? The query is indeed the same for both case: 

SELECT ttl, dns_type, mx_priority, data
FROM dns_records WHERE dns_zone='us.example.com' AND host='@';

Thanks a lot Todd and I don't know what did you think about, but, seems strange to me that only you respond and stay active in this thread.

I'm feeling a little embarrassed if the others systems administrators don't answer just because they think my trouble is trivial.

------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises 
looking to deploy the next generation of Solaris that includes the latest 
innovations from Sun and the OpenSource community. Download a copy and 
enjoy capabilities such as Networking, Storage and Virtualization. 
Go to: http://p.sf.net/sfu/opensolaris-get