Monthly 'rollover'

[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 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?