Hey All,
Is anyone out there running PPPoE and Radius found a way to get data counters for the 24 hour period without disconnecting PPPoE sessions at midnight? We need to be able to monitor for daily traffic but dont really want to drop PPPoE every day
Cheers
http://wiki.mikrotik.com/wiki/Manual:PPP_AAA#Remote_AAA
Use RADIUS AAA interim accounting. Set a timeframe in seconds, the RADIUS client will update the RADIUS server with values on the set interval.
Yep but that just updates the record, for a session up for 7 days the start time will be 7 days ago and data counters will be from 7 days to last update, Would be nice to be able to do one record for each day
That depends on what the RADIUS server does with the interim acct packet. In FreeRADIUS tied to some dialect of SQL (for example) you can define what query it triggers. It could easily do what you want it to by writing a query that inserts new records with a timestamp instead of updating previous accounting records and then doing selects as you need them.