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 )
Hi,
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 )
what does the output in debug mode show? what got used/sent/queried? alan
i dont have any information in session section in radius.log just one line: # Executing section session from file /usr/local/etc/raddb/sites-enabled/default # Executing section post-auth from file /usr/local/etc/raddb/sites-enabled/default On Tue, Mar 26, 2013 at 3:47 AM, <A.L.M.Buxey@lboro.ac.uk> wrote:
Hi,
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 )
what does the output in debug mode show? what got used/sent/queried?
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
i dont have any information in session section in radius.log just one line: # Executing section session from file /usr/local/etc/raddb/sites-enabled/default # Executing section post-auth from file /usr/local/etc/raddb/sites-enabled/default
debug log. radiusd -X alan
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
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
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Iliya Peregoudov -
Mehdi Ravanbakhsh