Re: Wildcard Subdomain

The wildcard should not have to be last in the result set.

----- Original Message ----
> From: Felipe Neuwald <[email protected]>
> To: [email protected]
> Sent: Wednesday, July 2, 2008 1:03:44 PM
> Subject: Re: [Bind-dlz-testers] Wildcard Subdomain
> 
> Graham,
> 
> I don't know, you have to test.
> 
> Felipe.
> 
> 2008/7/1 Graham Weldon :
> > Great, thanks for that example.
> > Do you know if the wildcard subdomain has to be last in the returned
> > results?
> > For example, if the results of the sql query return:
> >
> > www      1.1.1.1
> > mail     1.1.1.2
> > *        1.1.1.3
> > special  1.1.1.4
> >
> > Will "special" match 1.1.1.3 or 1.1.1.4 in this example?
> > Will the wildcard match "special" to 1.1.1.3 before the "special" entry
> > matches?
> >
> > Cheers,
> > Graham Weldon
> >
> > Fluid Lino
> > (02) 4927 5337
> > (0407) 017 293
> > [email protected]
> > www.fluidlino.com.au
> >
> > -----Original Message-----
> > From: [email protected]
> > [mailto:[email protected]] On Behalf Of
> > Felipe Neuwald
> > Sent: Wednesday, 2 July 2008 9:03 AM
> > To: [email protected]
> > Subject: Re: [Bind-dlz-testers] Wildcard Subdomain
> >
> > Graham,
> >
> > bind9-dlz+mysql-9.3.2+0.7.0 running on FreeBSD 6.3-STABLE.
> >
> > Here is a part of my named.conf:
> > dlz "Mysql zone" {
> >   database "mysql
> >   {host=127.0.0.1 dbname=autovhost user=autovhost
> > pass=dvmrMJaKWzxZyKsx}
> >   {SELECT zone FROM dns_records WHERE zone = '%zone%'}
> >   {SELECT ttl, type, mx_priority, IF(type = 'TXT',
> > CONCAT('\"',data,'\"'), data) AS data
> >    FROM dns_records
> >    WHERE zone = '%zone%' AND host = '%record%' AND type <> 'SOA' AND
> > type <> 'NS'}
> >   {SELECT ttl, type, data, primary_ns, resp_contact, serial, refresh,
> > retry, expire, minimum
> >    FROM dns_records
> >    WHERE zone = '%zone%' AND (type = 'SOA' OR type='NS')}
> >   {SELECT ttl, type, host, mx_priority, IF(type = 'TXT',
> > CONCAT('\"',data,'\"'), data) AS data, resp_contact, serial, refresh,
> > retry, expire, minimum
> >    FROM dns_records
> >    WHERE zone = '%zone%' AND type <> 'SOA' AND type <> 'NS'}
> >   {SELECT zone FROM xfr where zone='%zone%' AND client = '%client%'}";
> > };
> >
> > And here, SQL:
> >
> >  SELECT *
> > FROM `dns_records`
> > WHERE `zone` LIKE CONVERT( _utf8 'mydomain.com'
> > USING latin1 )
> > COLLATE latin1_swedish_ci
> > LIMIT 0 , 30
> >
> > +-----+---------+--------------+-------+------+------+-------------+----
> > --------------------+---------------+--------------------------+--------
> > +---------+-------+--------+---------+
> > | id  | info_id | zone         | ttl   | type | host | mx_priority |
> > data                   | primary_ns    | resp_contact             |
> > serial | refresh | retry | expire | minimum |
> > +-----+---------+--------------+-------+------+------+-------------+----
> > --------------------+---------------+--------------------------+--------
> > +---------+-------+--------+---------+
> > | 406 |      68 | mydomain.com | 86400 | SOA  | @    |        NULL |
> >                     | mydomain.com. | sysadm.xxxxxx. |      1 |
> > 10800 |  7200 | 604800 |   86400 |
> > | 407 |      68 | mydomain.com | 86400 | NS   | @    |        NULL |
> > ns1.xxxxxxx.com.br.  |               |                          |
> > NULL |    NULL |  NULL |   NULL |    NULL |
> > | 408 |      68 | mydomain.com | 86400 | NS   | @    |        NULL |
> > ns2.xxxxxxx.com.br.  |               |                          |
> > NULL |    NULL |  NULL |   NULL |    NULL |
> > | 409 |      68 | mydomain.com | 86400 | MX   | @    |           1 |
> > mail.xxxxxxx.com.br. |               |                          |
> > NULL |    NULL |  NULL |   NULL |    NULL |
> > | 410 |      68 | mydomain.com | 86400 | A    | www  |        NULL |
> > 200.200.200.32         |               |                          |
> > NULL |    NULL |  NULL |   NULL |    NULL |
> > | 411 |      68 | mydomain.com | 86400 | A    | mail |        NULL |
> > 200.200.200.32         |               |                          |
> > NULL |    NULL |  NULL |   NULL |    NULL |
> > | 412 |      68 | mydomain.com | 86400 | A    | *    |        NULL |
> > 200.200.200.200        |               |                          |
> > NULL |    NULL |  NULL |   NULL |    NULL |
> > +-----+---------+--------------+-------+------+------+-------------+----
> > --------------------+---------------+--------------------------+--------
> > +---------+-------+--------+---------+
> > 7 rows in set (0.00 sec)
> >
> > mysql> describe dns_records;
> > +--------------+--------------+------+-----+---------+----------------+
> > | Field        | Type         | Null | Key | Default | Extra          |
> > +--------------+--------------+------+-----+---------+----------------+
> > | id           | int(10)      | NO   | PRI | NULL    | auto_increment |
> > | info_id      | int(10)      | NO   | PRI | NULL    |                |
> > | zone         | varchar(255) | YES  |     | NULL    |                |
> > | ttl          | int(11)      | YES  |     | NULL    |                |
> > | type         | varchar(255) | YES  |     | NULL    |                |
> > | host         | varchar(255) | YES  |     | NULL    |                |
> > | mx_priority  | int(11)      | YES  |     | NULL    |                |
> > | data         | text         | NO   |     | NULL    |                |
> > | primary_ns   | varchar(255) | NO   |     | NULL    |                |
> > | resp_contact | varchar(255) | NO   |     | NULL    |                |
> > | serial       | bigint(20)   | YES  |     | NULL    |                |
> > | refresh      | int(11)      | YES  |     | NULL    |                |
> > | retry        | int(11)      | YES  |     | NULL    |                |
> > | expire       | int(11)      | YES  |     | NULL    |                |
> > | minimum      | int(11)      | YES  |     | NULL    |                |
> > +--------------+--------------+------+-----+---------+----------------+
> > 15 rows in set (0.00 sec)
> >
> > mysql> describe xfr;
> > +--------+--------------+------+-----+---------+----------------+
> > | Field  | Type         | Null | Key | Default | Extra          |
> > +--------+--------------+------+-----+---------+----------------+
> > | id     | int(10)      | NO   | PRI | NULL    | auto_increment |
> > | zone   | varchar(255) | YES  |     | NULL    |                |
> > | client | varchar(255) | YES  |     | NULL    |                |
> > +--------+--------------+------+-----+---------+----------------+
> > 3 rows in set (0.00 sec)
> >
> > mysql> select * from xfr;
> > +----+-------------------+-----------+
> > | id | zone              | client    |
> > +----+-------------------+-----------+
> > |  1 | myhost.com.br | 127.0.0.1 |
> > +----+-------------------+-----------+
> > 1 row in set (0.00 sec)
> >
> > The result:
> >
> > [root@myhost /]# ping thisisasimpletest.mydomain.com PING
> > thisisasimpletest.mydomain.com (200.200.200.200): 56 data bytes
> >
> > Felipe Neuwald.
> >
> > 2008/7/1 Graham Weldon :
> >> Can you post up an example of what you are using, including the
> >> queries being used in your conf?
> >> Also, what version of DLZ are you using?
> >> Thanks Felipe!
> >>
> >> Cheers,
> >> Graham Weldon
> >>
> >> Fluid Lino
> >> (02) 4927 5337
> >> (0407) 017 293
> >> [email protected]
> >> www.fluidlino.com.au
> >>
> >> -----Original Message-----
> >> From: [email protected]
> >> [mailto:[email protected]] On Behalf Of
> >> Felipe Neuwald
> >> Sent: Wednesday, 2 July 2008 8:47 AM
> >> To: [email protected]
> >> Subject: Re: [Bind-dlz-testers] Wildcard Subdomain
> >>
> >> Graham,
> >>
> >> It works ok for me. * and @.
> >>
> >> Felipe Neuwald.
> >>
> >> 2008/7/1 Graham Weldon :
> >>>
> >>> Hi all,
> >>> I've tried adding a wildcard subdomain to one of my zones with a
> >>> simple asterisk entry as an A record.
> >>> This doesn't seem to resolve correctly once entered.
> >>>
> >>> Can Bind-DLZ handle wildcard subdomains?
> >>> If so, what is the method required to achieve this?
> >>> Thanks!
> >>>
> >>>
> >>> Cheers,
> >>> Graham Weldon
> >>>
> >>> Fluid Lino
> >>> (02) 4927 5337
> >>> (0407) 017 293
> >>> [email protected]
> >>> www.fluidlino.com.au
> >>>
> >>> ---------------------------------------------------------------------
> >>> -
> >>> --- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> >>> Studies have shown that voting for your favorite open source project,
> >
> >>> along with a healthy diet, reduces your potential for chronic
> >>> lameness
> >>
> >>> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> >>> _______________________________________________
> >>> Bind-dlz-testers mailing list
> >>> [email protected]
> >>> https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
> >>>
> >>
> >> ----------------------------------------------------------------------
> >> --
> >> -
> >> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> >> Studies have shown that voting for your favorite open source project,
> >> along with a healthy diet, reduces your potential for chronic lameness
> >
> >> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> >> _______________________________________________
> >> Bind-dlz-testers mailing list
> >> [email protected]
> >> https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
> >>
> >> ----------------------------------------------------------------------
> >> --- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> >> Studies have shown that voting for your favorite open source project,
> >> along with a healthy diet, reduces your potential for chronic lameness
> >
> >> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> >> _______________________________________________
> >> Bind-dlz-testers mailing list
> >> [email protected]
> >> https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
> >>
> >
> > ------------------------------------------------------------------------
> > -
> > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> > Studies have shown that voting for your favorite open source project,
> > along with a healthy diet, reduces your potential for chronic lameness
> > and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> > _______________________________________________
> > Bind-dlz-testers mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
> >
> > -------------------------------------------------------------------------
> > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> > Studies have shown that voting for your favorite open source project,
> > along with a healthy diet, reduces your potential for chronic lameness
> > and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> > _______________________________________________
> > Bind-dlz-testers mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
> >
> 
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> _______________________________________________
> Bind-dlz-testers mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers



      

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08