AW: AW: [Pdns-users] Wildcard Domains gmysql

[Günter Weber]

-----Ursprüngliche Nachricht-----
Von: Steven J. Sobol [mailto:sjsobol at JustThe.net] 
Gesendet: Mittwoch, 30. Juli 2003 21:26
An: Günter Weber
Cc: 'Christian Arnold'; pdns-users at mailman.powerdns.com
Betreff: Re: AW: [Pdns-users] Wildcard Domains gmysql


On Wed, 30 Jul 2003, Günter Weber wrote:

> If i do the same on *.xxx.de-record with bla it looks like this
> 
> 
> select content,ttl,prio,type,domain_id,name from records where
> name='bla.xxx.de'
> select content,ttl,prio,type,domain_id,name from records where
> name='*.xxx.de'

>I don't remember whether the asterisk works as a wildcard in MySQL,
>but the percent sign definitely does; try using %.xxx.de instead.
 
>But you'd also have to hack the gmysql backend to do name LIKE
'%.xxx.de'
>- which would work fine.

>name like 'abc.def.g' only matches 'abc.def.g' (case insensitive)
>name like '%.def.g' matches any subdomain of def.g.

The entry in the record table ist *.xxx.de because this is the
wildcardentry for a domain (rfc haumichblau) and has nothing to do with
the wildcard of mysql, which would heavily decrease the performance by
the way ;)


-- 
JustThe.net Internet & Multimedia Svcs. [The Fusion of Content &
Connectivity]
22674 Motnocab Road * Apple Valley, CA 92307-1950 
Steve Sobol, Proprietor 
888.480.4NET (4638) * 248.724.4NET * sjsobol at JustThe.net