On Thu, 14 Aug 2003, Christos Kalantzis wrote:
> Hello,
>
> I have the same problem,
>
> have you find any solution to this ?
>
> Thank you in advance,
> Christos Kalantzis
>
>
> I am trying to get the rlm_sqlcounter module working in freeradius-0.8.1
>
> and am have a bit of trouble. It appears that the module is not
> querying the sql database...
>
> When running radius -X, I get the following:
>
> rlm_sqlcounter: Entering module authorize code
> rlm_sqlcounter: Could not find Check item value pair
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
So provide it with the corresponding check item.
> modcall[authorize]: module "allcounter" returns noop
> rlm_sqlcounter: Entering module authorize code
> rlm_sqlcounter: Could not find Check item value pair
> modcall[authorize]: module "dailycounter" returns noop
> rlm_sqlcounter: Entering module authorize code
> rlm_sqlcounter: Could not find Check item value pair
> modcall[authorize]: module "monthlycounter" returns noop
>
> The configuration directive for the modules are as follows:
>
> sqlcounter allcounter {
> counter-name = Max-All-Session-Time
> check-name = Max-All-Session
> sqlmod-inst = sql
> key = User-Name
> reset = never
> query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE
> UserName='%{%k}'"
> }
>
> sqlcounter dailycounter {
> counter-name = Daily-Session-Time
> check-name = Max-Daily-Session
> sqlmod-inst = sql
> key = User-Name
> reset = daily
> query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
> UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
> AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
> }
>
> sqlcounter monthlycounter {
> counter-name = Monthly-Session-Time
> check-name = Max-Monthly-Session
> sqlmod-inst = sql
> key = User-Name
> reset = monthly
> query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
> UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
> AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
> }
>
>
> --Robert R. George
>
>
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED] National Technical University of Athens, Greece
Work Phone: +30 210 7721861
'Go back to the shadow' Gandalf
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
