Hello,
I'd like to use rlm_sqlcounter with freeradius 0.7 (using oracle backend),
but it does not work. I have the following config:
sqlcounter totalcounter {
counter-name = Total-Session-Time
check-name = Total-Time-Limit
sqlmod-inst = sql
key = User-Name
reset = never
query = "SELECT SUM(AcctSessionTime) a FROM acct_internet
WHERE UserName='%{%k}'"
}
When i try to authenticate the user with Total-Time-Limit check attribute:
rlm_sqlcounter: Entering module authorize code
sqlcounter_expand: 'SELECT SUM(AcctSessionTime) a FROM acct_internet WHERE
UserName='%{User-Name}''
radius_xlat: 'SELECT SUM(AcctSessionTime) a FROM acct_internet WHERE
UserName='[EMAIL PROTECTED]''
sqlcounter_expand: '%{sql:SELECT SUM(AcctSessionTime) a FROM acct_internet
WHERE UserName='[EMAIL PROTECTED]'}'
radius_xlat: Runing registered xlat function of module sql for string
'SELECT SUM(AcctSessionTime) a FROM acct_internet WHERE
UserName='[EMAIL PROTECTED]''
rlm_sql: - sql_xlat
radius_xlat: 'SELECT SUM(AcctSessionTime) a FROM acct_internet WHERE
UserName='[EMAIL PROTECTED]''
rlm_sql: Reserving sql socket id: 4
rlm_sql: - sql_xlat finished
rlm_sql: Released sql socket id: 4
radius_xlat:
'h???���*p???p???���*���*���*���*���*���*���*���*���*���*���*���*'
rlm_sqlcounter: (Check item - counter) is greater than zero
rlm_sqlcounter: Authorized user [EMAIL PROTECTED], check_item=216000,
counter=0
rlm_sqlcounter: Sent Reply-Item for user [EMAIL PROTECTED],
Type=Session-Timeout, value=216000
modcall[authorize]: module "totalcounter" returns ok
I think variable "counter" should be equal to the result of sql query. But
counter = 0, and FreeRADIUS does not apply the correct Session-Timeout to
the user.
SQL> SELECT SUM(AcctSessionTime) a FROM acct_internet WHERE
UserName='[EMAIL PROTECTED]';
A
----------
44318
Thank You,
Felician Hoppal
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
