many thanks ... :) On 3/26/13, Iliya Peregoudov <iperegudov@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