Monthly 'rollover'

[Jeremy Brooking-2]

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

[tnt-5]

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

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