how to call stored procedure in free-radius server

Phil Mayers p.mayers at imperial.ac.uk
Tue Jan 15 12:40:35 CET 2013


On 15/01/13 11:30, Lakshmi Narayana Baliah wrote:
> Hi Arran,
>
> Thanks for your reply.... have created stored procedure(myS1Request) in oracle database 11g as shown below, procedure takes input and output parameters.
> The below procedure should be called in the SQL module in Free-radius for Authentication and Authorization purpose.

>
> please help me how can proceed...........

Calling a stored procedure is the same as doing any other SQL query. You 
can either force the intput/output to match the radcheck/radreply schema 
using SQL, or use the SQL xlat syntax like so:

authorize {
   ...
   update request {
     Tmp-String-0 := "%{sql:select storedproc('%{Arg1}',...)}"
   }
   ...
}


More information about the Freeradius-Users mailing list