[RADIATOR] Authentication without check attributes

[Jesús Rodríguez]

Hi Heikki and all,

Is possible to use a value returned in an <AuthBy SQL> AuthSelect query in a subsequent <AuthBy>?.

An example:

<Handler Client-Identifier=preauth,Calling-Station-Id="1234567">
	AuthByPolicy ContinueWhileAccept
	AddToRequest X-pre-auth-required-result = 1
	<AuthBy SQL>
		AuthSelect select validate_preauth('%{Calling-Station-Id}','',%0,'','','','','','','','','','',0,1,0,now())
		AuthColumnDef 0, X-pre-auth-required-result, check
	</AuthBy>

In this case, the AuthSelect would return two values. The first one is used as check value. I would like to get the second returned value and use it in a subsequent <AuthBy> within the same <Handler> clause. Is possible to save the second value in a variable or pseudo-attribute and use it later on?.

Thanks and regards.





El 27/06/2012, a las 13:21, Jesús Rodríguez <jesusr at voztele.com> escribió:

> ---------- Forwarded message ----------
> From: Heikki Vatiainen <hvn at open.com.au>
> Date: Sun, Jun 24, 2012 at 10:59 PM
> Subject: Re: [RADIATOR] Authentication without check attributes
> To: radiator at open.com.au
> 
> 
> On 06/23/2012 04:32 PM, Jesús Rodríguez wrote:
> 
>> To authenticate a dsl pre-authentication request, i have to use a mysql function query (using AuthBy mysql) that returns 1 (accept) or 0 (reject), with no check attributes or other values i can use as check parameters.
>> 
>> How can i send the Accept or Reject based on the returned 1 or 0 values?.
> 
> Try something like this:
> 
> <Handler ...>
>    AddToRequest  X-pre-auth-required-result = 1
>    <AuthBy SQL>
>        AuthSelect your-mysql-function
>        AuthColumnDef 0, X-pre-auth-required-result, check
>    ...
> ...
> 
> Here X-pre-auth-required-result is a local pseudo-attribute. You can
> name it as you want, but the main thing is it will never come from the
> NAS and has a fixed value you can compare against value returned from
> MySQL function.
> 
> Thanks,
> Heikki




------------------------------------
Jesus Rodriguez
VozTelecom Sistemas, S.L.
jesusr at voztele.com
http://www.voztele.com
Tel. 902360305
-------------------------------------