Monthly 'rollover'

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