sql counter clarification and issues

[Ross Tsolakidis]

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