(RADIATOR) Reply Attributes and SQL

[Hugh Irvine]

Hello Levi -

Something like this:

	<AuthBy SQL>
		.....
		AuthSelect select PASSWORD, CHECKATTR, REPLYATTR \
			from SUBSCRIBERS where USERNAME = %0
		AuthColumnDef 0, Password, check
		AuthColumnDef 1, GENERIC, check
		AuthColumnDef 2, GENERIC, reply
		.....
		AddToReplyIfNotExist ......
	</AuthBy>

See section 6.28 in the Radiator 3.9 reference manual ("doc/ref.html").

regards

Hugh



On 16 Sep 2004, at 03:44, Levi Senft wrote:

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

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

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