<div dir="ltr"><div style>Hi All </div><div style><br></div><div>I am create stored persedure in postgresql database named "findout_cuncurrent_session_for_a_user_result" that return "Deny" or "Permit" .</div>
<div><br></div><div>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 :</div><div><br></div><div>session {</div><div><br>
</div><div><span class="" style="white-space:pre"> </span>if ("{%sql:select findout_cuncurrent_session_for_a_user_result ('%{User-Name}','%{NAS-IP-Address}','%{Called-Station-Id}','%{Calling-Station-Id}')}" == "Deny") {</div>
<div><br></div><div><span class="" style="white-space:pre"> </span>update control {</div><div><span class="" style="white-space:pre"> </span>Pool-Name := "Exceeded-Concurrent-Session"<span class="" style="white-space:pre"> </span></div>
<div><span class="" style="white-space:pre"> </span>}</div><div><span class="" style="white-space:pre"> </span>}<span class="" style="white-space:pre"> </span></div><div>}</div><div><br></div><div><br></div><div><br></div>
<div style>What is the problem? Do i write sql query write ? (this query is work fine in sql.conf )</div><div style><br></div><div style><br></div></div>