(RADIATOR) Reply Attributes and SQL

[Sergio Gonzalez]

Hi.

Well.. As far as I know, radiator "knows" what column needs to be checked 
and what column need to be returned. If you use the default behavior, for 
example you can use

               AuthSelect select PASSWORD,CHECKATTR,REPLYATTR \
                     from SUBSCRIBERS where USERNAME = '%n'

Radiator check PASSWORD and CHECKATTR column, and if the checking goes 
positive, it will reply with the content of the REPLYATTR column. Also, if 
you need to change the default behavior of radiator, you can do something like:

         AuthSelect select PASSWORD, TIMELEFT, CHECKATTR from TABLENAME \
         where ( USERNAME = '%n' and PASSWORD = '%P' and TIMELEFT > 0)
         AuthColumnDef   0,User-Password,check
         AuthColumnDef   0,Class,reply
         AuthColumnDef   1,Session-Timeout,reply
         AuthColumnDef   2,GENERIC,check


so you can tell radiator what to check and what to return.


Maybe someone in the list can give you better examples.


hth


>Okay, let me rephrase.
>
>How do I tell radiator to respond to the radius client with said column?
>
>And after I get radiator responding with reply attributes stored in the
>database, is there a method I could use to have radiator check the column
>and reply with the column contents, if the column is not null, and if the
>column is null have radiator use default reply attributes?
>
>Levi Senft
>Utahweb
>(801) 486-6111
>
>-----Original Message-----
>From: Sergio Gonzalez [mailto:sagonzal at sky.net.co]
>Sent: Wednesday, September 15, 2004 11:27 AM
>To: Levi Senft; Radiator List
>Subject: Re: (RADIATOR) Reply Attributes and SQL
>
>
>Hi.
>
>
>I'm not sure what you mean with "add to the config file". What you need to
>do is to store whatever reply attributes you want to apply for each user,
>and then tell radiator to respond to the radius client with such column.
>
>
>Regards.
>
>
> >I'm using MySQL and the default tables.  I'd like to store reply attributes
> >in the REPLYATTR field of the SUBSCRIBERS table, but how do I add that to
> >the config file?
> >
> >Levi Senft
> >Utahweb
> >(801) 486-6111
> >
> >---
> >[This E-mail scanned for viruses by Utahweb]
> >
> >--
> >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.
>
>Sergio Alejandro Gonzalez
>Director Operativo
>Network and Services Field Manager
>SkyNet de Colombia.
>Calle 100 No. 8A-55 Of. 711
>Bogota, Cundinamarca
>Colombia, South America.
>Tel: 57 (+1) 6 422 020
>Cel: 57 (+3)/(03315) 3551034
>Pager: 5405555, 3469999 Cod 2010
>
>---
>[This E-mail scanned for viruses by Utahweb]
>
>
>---
>[This E-mail scanned for viruses by Utahweb]
>
>--
>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.

Sergio Alejandro Gonzalez
Director Operativo
Network and Services Field Manager
SkyNet de Colombia.
Calle 100 No. 8A-55 Of. 711
Bogota, Cundinamarca
Colombia, South America.
Tel: 57 (+1) 6 422 020
Cel: 57 (+3)/(03315) 3551034
Pager: 5405555, 3469999 Cod 2010

--
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.