Mehdi Ravanbakhsh babakco at gmail.com
Tue Mar 26 21:58:58 CET 2013


many thanks ...  :)



On 3/26/13, Iliya Peregoudov <iperegudov at cboss.ru> wrote:
> Correct syntax is "%{sql:...}", not "{%sql:...}".
>
> On 26.03.2013 2:20, Mehdi Ravanbakhsh wrote:
>> Hi All
>>
>> I am create stored persedure in postgresql database named
>> "findout_cuncurrent_session_for_a_user_result" that return "Deny" or
>> "Permit" .
>>
>> I need to call this persidure in session section but it not working i
>> check all policy that be explaned in unlang  man page but this cod is
>> not working :
>>
>> session {
>>
>> if ("{%sql:select findout_cuncurrent_session_for_a_user_result
>> ('%{User-Name}','%{NAS-IP-Address}','%{Called-Station-Id}','%{Calling-Station-Id}')}"
>> == "Deny") {
>>
>> update control {
>> Pool-Name := "Exceeded-Concurrent-Session"
>> }
>> }
>> }
>>
>>
>>
>> What is the problem? Do i write sql query  write ? (this query is work
>> fine in sql.conf )
>>
>>
>>
>>
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>


More information about the Freeradius-Users mailing list