[Iliya Peregoudov]

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
>