You need sqlcounter (counter.conf) for that.
Found. but no UPDATE query in it.
Oddly enough, counter doesn't update anything - it COUNTS. It counts how
much time has been used in current period (on previous logins) and deducts
that from the limit. You can choose the reset period (daily counter
09/18/2009 12:51 PM, Ivan Kalik::
You need sqlcounter (counter.conf) for that.
Found. but no UPDATE query in it.
Oddly enough, counter doesn't update anything - it COUNTS.
OK,
Attached is my 'default' file, and the 'freeradius -X' output.
the counter (in counter.conf) is:
sqlcounter
sqlcounter dailycounter
{
counter-name = Daily-Session-Time
check-name = Max-Daily-Session
reply-name = Session-Timeout
sqlmod-inst = sql
key = User-Name
reset = daily
query = SELECT SUM(AcctSessionTime - \
GREATER((%b -
09/18/2009 05:41 PM, Ivan Kalik::
sqlcounter dailycounter
{
counter-name = Daily-Session-Time
check-name = Max-Daily-Session
reply-name = Session-Timeout
sqlmod-inst = sql
key = User-Name
reset = daily
query = SELECT SUM(AcctSessionTime - \
09/18/2009 05:41 PM, Ivan Kalik::
sqlcounter dailycounter
{
counter-name = Daily-Session-Time
check-name = Max-Daily-Session
reply-name = Session-Timeout
sqlmod-inst = sql
key = User-Name
reset = daily
query = SELECT SUM(AcctSessionTime - \
5 matches
Mail list logo