(RADIATOR) Complex AuthSelect Query

[Hugh Irvine]

Hello Cem SEN -

By far the best way of doing these sorts of things with Oracle is in  
a stored procedure in the database.

regards

Hugh


On 24 May 2005, at 20:29, Cem SEN wrote:

> Hello All,
>
> I need your ideas/helps for the following situation. I am using  
> radiator 3.11 with an oracle db.
> In the AuthSelect section of AuthBy Sql i have such a stirng that  
> works fine:
>
> AuthSelect SELECT RTRIM(PASSWORD),RTRIM(STATICIP),RTRIM(ROUTE),RTRIM 
> (MAXCONNECT) FROM USERS where etc,....
> The problem is, i need to make a more complex query using if/else/ 
> then statements.Such as;
>
> -- if one of the flags in the database related to that username is  
> equal to x then process following line
>
> AuthSelect SELECT RTRIM(PASSWORD),RTRIM(STATICIP),RTRIM(ROUTE),RTRIM 
> (MAXCONNECT) FROM USERS
>
> -- if one of the flags in the database related to that username is  
> equal to y then change flag to x then bla bla bla and then process  
> following line
>
> AuthSelect SELECT RTRIM(PASSWORD),RTRIM(STATICIP),RTRIM(ROUTE),RTRIM 
> (MAXCONNECT) FROM USERS
>
> Is it possible to make such configuration in the radius.cfg file or  
> is there a way for having it done by an external query string?
>
> Thanks In Advance
>
> Cem SEN
>
> --
> 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 read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
radiator)?
Have you had a quick look on Google (www.google.com)?
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.