Hi to all!
I need to configure my freeradius-0.7 in that manner:
1. I need a Max-Daily-Session (720000 senconds) for a group by mean of
sqlcounter.
2. I want to force a Session-Timeout (7200 seconds) for the users of that
group.
My sqlcounter configuration is that:
sqlcounter dailycounter {
counter-name = Daily-Session-Time
check-name = Max-Daily-Session
sqlmod-inst = sql
key = User-Name
reset = never
query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='%{%k}' AND AcctStartTime > TO_DATE(to_char(SYSDATE,'DD/MM/YY
YY'),'DD/MM/YYYY')"
In radgroupcheck table I've insert a line:
GroupName = Name of the group
Attribute = Max-Daily-session
Value = 720000
OP = :=
In authorized section (radiusd.conf) I've used in order:
{
files
sql
dailycounter
}
My users file configuration is:
DEFAULT Service-Type == Framed-User, Framed-Protocol == PPP,
Simultaneous-Use := 1
Session-Timeout = 7200,
Service-Type = Framed-User,
Framed-Protocol = PPP,
Fall-Through = Yes
It don't work. In debug mode it tell me:
"modcall[authorize]: module "files" returns notfound"
Then it set Session-Timeout to the value returned by "SELECT
SUM(AcctSessionTime) FROM radacct WHERE UserName='%{%k}' AND AcctStartTime >
TO_DATE(to_char(SYSDATE,'DD/MM/YY
YY'),'DD/MM/YYYY')"
Thanks in advanced.
---------------------------------------------
Ing. Alessandro Maioli
Intelcom San Marino S.p.A.
Strada degli Angariari, 3
47891 - Rovereta - Rep. di San Marino
email: [EMAIL PROTECTED]
Tel. +378 0549 886111 or +378 886111
Fax +378 0549 908654 or +378 908654
---------------------------------------------
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
