sql counter clarification and issues

Ross Tsolakidis Ross.Tsolakidis at day3.com.au
Tue Jun 28 06:19:13 CEST 2005


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.




More information about the Freeradius-Users mailing list