On 05/02/13 10:44, Lakshmi Narayana Baliah wrote:

    Hi all,

   I want to configure the  free radius to return access-reject based on the 
value in stored procedure in oracle database( i have configured oracle database 
to free radius)


   How do i do that ??? please help....

There are many ways, it depends on exactly what you want to do. You are being too vague.

One option is to use an SQL xlat in unlang, like so:

authorize {
  ...
  update control {
    Tmp-String-0 := "%{sql: <sql to call proc goes here>}"
  }
  if (control:Tmp-String-0 == "reject") {
    reject
  }
  ...
}

The SQL inside the XLAT can reference packet values e.g.

 %{sql:select some_proc('%{User-Name}')}
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to