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