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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html