sqlcounter problem

[Alessandro Maioli]

Title: ���.com club

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 ---------------------------------------------