> this is an example of what can be done in postgresql:
>
> authorize_check_query = "SELECT * FROM
> radius_check('%{SQL-User-Name}', '%{Client-IP-Address}') HAVING id IS
> NOT NULL"
>
> the function returns the correct number of cols as needed.
>
> should be similiar for oracle.
Maybe a little late answer, but no.. You can not execute a stored
procedure the same way in Oracle as with postgres or MSSQL.
In Oracle the proc only returns a pointer that needs to be read after
execution, not supported in the current db.
However, I faced the same problem in aug/sep last year but finally managed
to solve it..
It basically depends on what you want to do, but in my case I run a
SQL-statement like this:
authorize_check_query = "select id,username,attribute,value,op FROM
radcheck WHERE username = '%{SQL-User-Nam e}' AND
check_service('%{SQL-User-Name}','%{Huntgroup-Name}','%{Called-Station-Id}')
= 1"
The check_service as you can see takes a couple of arguments. If executed
OK, it will return 1.. meaning I've got a match on the user with the
critera needed to accept the call.
This solution gave me the possibility to run different sql-queries
depending on the different input variables..
I've also modified the sql-code in pretty simple way so it's possible for
me to execute more than one authorize_reply_query .. I've added
authorize_reply_query2 and authorize_reply_query3 etc..
With this, my need for the possibility to run Oracle SP's went away, for
now anyways ;)
If you haven't solved your problem, hope this helped. Otherwise I hope
this will help other people searching the archives.. Because there is very
little written about this earlier :)
Sincerely,
Max!
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
