On Fri, 17 Oct 2003, apellido jr., wilfredo p wrote:
> what wrong with this configuration?
>
>
> counter Monthly {
> filename = ${raddbdir}/db.monthly
> key = User-name
> count-attribute = Acct-Session-Time
> reset = 3m
> counter-name = Monthly-Session-Time
> check-name = Max-Monthly-Session
> allowed-servicetype = Framed-User
> cache-size = 5000
> }
>
> here's the part of the log :
>
> sqlcounter: counter-name = "Monthly-Session-Time"
> sqlcounter: check-name = "Max-Monthly-Session"
> sqlcounter: key = "User-Name"
> sqlcounter: sqlmod-inst = "sqlcca3"
> sqlcounter: query = "SELECT SUM(AcctSessionTime) FROM
> radacct WHERE UserName='%{%k}' AND AcctStartTime >
> FROM_UNIXTIME('%b')"
> sqlcounter: reset = "monthly"
> rlm_sqlcounter: Counter attribute Monthly-Session-Time
> is number 1081
> rlm_sqlcounter: Check attribute Max-Monthly-Session is
> number 1082
> rlm_sqlcounter: Current Time: 1066458752 [2003-10-18
> 14:32:32], Next reset 1067616000 [2003-11-01 00:00:00]
> rlm_sqlcounter: Current Time: 1066458752 [2003-10-18
> 14:32:32], Prev reset 1064937600 [2003-10-01 00:00:00]
> Module: Instantiated sqlcounter (monthlycounter)
What does sqlcounter have to do with rlm_counter?
>
>
> why isnt it the next reset still first day of the
> month eventhough it is set for 3 month?
>
>
>
>
>
> =====
> [ apellido jr., wilfredo p. ]
> +63 034 4880-449
>
> If you can't hear me, it's because i'm in parentheses.
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
>
> -
> 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
