sql counter clarification and issues
Ross Tsolakidis
Ross.Tsolakidis at day3.com.au
Wed Jun 29 05:29:30 CEST 2005
Thanks for responding.
Can you give me an example of how to set the counter to reset in SQL ?
This is my config for the counter.
counter daily {
filename = ${raddbdir}/db.daily
key = User-Name
count-attribute = Acct-Session-Time
reset = daily
counter-name = Daily-Session-Time
check-name = Max-Daily-Session
allowed-servicetype = Framed-User
cache-size = 5000
}
Thanks again.
Regards,
--
Ross
-----Original Message-----
From: freeradius-users-bounces at lists.freeradius.org
[mailto:freeradius-users-bounces at lists.freeradius.org] On Behalf Of Alan
DeKok
Sent: Wednesday, 29 June 2005 12:58 AM
To: FreeRadius users mailing list
Subject: Re: sql counter clarification and issues
"Ross Tsolakidis" <Ross.Tsolakidis at day3.com.au> wrote:
> Looking at that debug, where exactly is it resetting the counter ?
The "counter" module is resetting the counter.
> In the db.daily ? Because it's not resetting in SQL.
Yes, the counter module doesn't say it's using SQL.
> Also what is the db.daily ? How do you read that file ?
You don't. Its used by the counter module to keep it's count.
> What I'm trying to achieve here is to get mysql to reset the counters
> its doing, and then start a new row if possible.
> Within the table radacct. AcctInputOctets AcctOutputOctets.
> Is it possible to do this ?
> Does the counter actually do that ?
You want sqlcounter.
Alan DeKok.
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
More information about the Freeradius-Users
mailing list