Hi all, I was hoping someone could shed some light on this problem I'm having. FreeRadius 1.04 Compiled using: ./configure --with-experimental-modules make make install Radius is connecting to a mysql backend. The NAS units are logging to Radius and into SQL. Running in debug mode I see this: Module: Loaded Counter counter: filename = "/usr/local/etc/raddb/db.daily" counter: key = "User-Name" counter: reset = "daily" counter: count-attribute = "Acct-Session-Time" counter: counter-name = "Daily-Session-Time" counter: check-name = "Max-Daily-Session" counter: allowed-servicetype = "Framed-User" counter: cache-size = 5000 rlm_counter: Counter attribute Daily-Session-Time is number 1671 rlm_counter: Current Time: 1119932000 [2005-06-28 14:13:20], Next reset 1119967200 [2005-06-29 00:00:00] Module: Instantiated counter (daily) So the Counter loads just fine and Radius works fine. Looking at that debug, where exactly is it resetting the counter ? In the db.daily ? Because it's not resetting in SQL. Also what is the db.daily ? How do you read that file ? 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 ? Thanks in advance. Ross.
"Ross Tsolakidis" <Ross.Tsolakidis@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.
participants (2)
-
Alan DeKok -
Ross Tsolakidis