RE: Monthly 'rollover'

2009-11-04 Thread Ivan Kalik
What we would like to do, is at the end of each month (Just before date rolls into next month), the current accounting record to stop, a new record to start (As if a start record had been recieved) without disconnecting the user from the nas. Giving the appearance in the radacct table, the

Re: Monthly 'rollover'

2009-11-04 Thread Jonathan Gazeley
Hi Jeremy, I had exactly the same need as you, except I wanted my rollover to take place on an hourly basis for live accounting. I found this guide helpful: http://www.netexpertise.eu/en/freeradius/daily-accounting.html Regards, Jonathan Jonathan Gazeley

Monthly 'rollover'

2009-11-03 Thread Jeremy Brooking
Hi, We bill based on data from radius, using dpkg install of Freeradius2.0.4 with mysql, however, when a user maintains a connection for say longer than a month, it throws our accounting out. What we would like to do, is at the end of each month (Just before date rolls into next month), the

RE: Monthly 'rollover'

2009-11-03 Thread Jeremy Brooking
We bill based on data from radius, using dpkg install of Freeradius2.0.4 with mysql, however, when a user maintains a connection for say longer than a month, it throws our accounting out. That's because your billing program can't count. Youre right, it merely sums totals of

Re: Monthly 'rollover'

2009-11-03 Thread Ivan Kalik
Jeremy Brooking wrote: We bill based on data from radius, using dpkg install of Freeradius2.0.4 with mysql, however, when a user maintains a connection for say longer than a month, it throws our accounting out. That's because your billing program can't count. What we would like to do, is