On Sun, 19 Oct 2003, apellido jr., wilfredo p wrote:
> Have a nice day Mr. Kalevras, I just question
> regarding counter attribute, is this possible to add
> this attribute in rlm_sqlcounter? or it is just for
> rlm_counter? Both rlm_counter and rlm_sqlcounter
> support user define reset, i tried to change the
> default reset of sql_monthlycounter and counter
> Monthly
> to 3 months and here's the LOG
>
> daywalker# radiusd -xx
> Starting - reading configuration files ...
> reread_config: reading radiusd.conf
> Config: including file: /etc/raddb/proxy.conf
> Config: including file: /etc/raddb/clients.conf
[...]
> Module: Loaded Counter
> counter: filename = "/etc/raddb/db.monthly"
> counter: key = "User-name"
> counter: reset = "3m"
> counter: count-attribute = "Acct-Session-Time"
> counter: counter-name = "Monthly-Session-Time"
> counter: check-name = "Max-Monthly-Session"
> counter: allowed-servicetype = "Framed-User"
> counter: cache-size = 5000
> rlm_counter: Counter attribute Monthly-Session-Time is
> number 1081
> rlm_counter: num=3, last=m
> rlm_counter: Current Time: 1066614025, Next reset
> 1072886400
You could try using the cvs version of rlm_counter, it will print the current
time and next reset time in human readable form. In any case for rlm_counter the
next is after 72 days which is probably at the first day of the third month
ahead.
[...]
> Module: Loaded SQL Counter
> 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 = "3m"
> rlm_sqlcounter: Counter attribute Monthly-Session-Time
> is number 1081
> rlm_sqlcounter: Check attribute Max-Monthly-Session is
> number 1082
> rlm_sqlcounter: num=1, last=m
> rlm_sqlcounter: Current Time: 1066614026 [2003-10-20
> 09:40:26], Next reset 1067616000 [2003-11-01 00:00:00]
> rlm_sqlcounter: num=3, last=m
> rlm_sqlcounter: Current Time: 1066614026 [2003-10-20
> 09:40:26], Prev reset 1059667200 [2003-08-01 00:00:00]
> Module: Instantiated sqlcounter (monthlycounter)
>
> why isnt it the next reset STILL first day of the
> month?
As for rlm_sqlcounter i don't know.
>
>
>
> =====
> [ 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
