(RADIATOR) Authby SQL checking multi-value attributes

[Hugh Irvine]

Hello Julio -

You should use regular expressions to check multiple values:

	NASPORTYPE = "NAS-Port-type = '/Sync|Async/'"

regards

Hugh


On Thu, 7 Mar 2002 22:27, julio.prada at bt.es wrote:
> hi all,
>
> I'm using Radiator 2.18.1 with AuthbySQL over MySQL.
>
> I've defined several fields in SUBSCRIBERS table to check them.
>
> I'm interested in checking NAS-Port-Type in a multi-value way, so for
> example,
>
> 	user1 at domain
>
> will be accepted if its NAS-Port-Type matches 'Sync' or 'Async' values, so
> in case this user sends 'ISDN-Sync' nasport-type, he will be rejected.
>
> As a workaround I try to define a column NASPORTTYPE char(200) in
> SUBSCRIBERS table in that way:
>
> 	NASPORTYPE = "NAS-Port-type = 'Sync',NAS-Port-type = 'Async'"
>
> and in Authby SQL
>
> 	AuthColumnDef N GENERIC, check
>
> but this idea does not work because it only checks first item.
>
> Any workaround about checking multivalue attributes with AuthSQL?
>
> thanks,
> jules
>
>
> Si quiere más información de BT puede solicitarla en nuestra revista online
> http://www.ignite.com/realise
>
> **********************************************
> Noticia legal
> Este mensaje electrónico contiene información de BT Ignite España S.A.U.
> que es privada y confidencial, siendo para el uso exclusivo de la persona
> (s) o entidades arriba mencionadas. Si usted no es el destinatario
> señalado, le informamos que cualquier divulgación, copia, distribución o
> uso de los contenidos está prohibida. Si usted ha recibido este mensaje por
> error, por favor borre su contenido lo antes posible.
> Gracias.
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.