RE: Monthly 'rollover'
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 the user disconnected and reconnected, keeping all data records for that month, within that month. Don't do that. Im curious as to why not? Because it doesn't make sense to break accounting records that are correct. Fix what's wrong instead. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Monthly 'rollover'
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 Systems Support Specialist ResNet | Wireless VPN Team Information Services University of Bristol On 11/03/2009 09:45 PM, Jeremy Brooking wrote: 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 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 the user disconnected and reconnected, keeping all data records for that month, within that month. I've tried googling for the answers, but can only assume my search strings are wrong. Could someone here help me with this, or point me in the direction I need to be looking. regards, Jeremy - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Monthly 'rollover'
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 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 the user disconnected and reconnected, keeping all data records for that month, within that month. I've tried googling for the answers, but can only assume my search strings are wrong. Could someone here help me with this, or point me in the direction I need to be looking. regards, Jeremy - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Monthly 'rollover'
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 AcctInputOctets, AcctOutputOctets for all records that occur during that month. 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 the user disconnected and reconnected, keeping all data records for that month, within that month. Don't do that. Im curious as to why not? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Monthly 'rollover'
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 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 the user disconnected and reconnected, keeping all data records for that month, within that month. Don't do that. I've tried googling for the answers, but can only assume my search strings are wrong. Could someone here help me with this, or point me in the direction I need to be looking. Have a look at default queries in counter.conf. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html