daily usage report

[Alan DeKok]

> On Aug 19, 2018, at 5:43 AM, Nathan Ward <lists+freeradius at daork.net> wrote:
> 
> You might want to subscribe to the list non-digest :-)

  And edit messages before replying...

>> On 19/08/2018, at 9:38 PM, Imdad Hasan <imdadalikadiwala0 at gmail.com> wrote:
>> 
>> Actually i want to make daily usage report, but if that session is older
>> than one or two days than i dont get proper daily data usage report. For
>> now, i was make script that disconnect all users with pod at midnight 12.

  Why not just create a daily usage report?

  Make another table, with columns "username", "date", and "usage".  Then, once a day at midnight, loop over the "radacct" table for all open sessions.  Take the usage from radacct, and insert it into the new table.

>> Any other way to achieve this idea without disconnecting users.
> 
> Sure there are plenty of ways. What is the problem re. the sessions being older than one or two days? Please be explicit about your problem and what you’re trying to achieve, and include as much detail as possible. I can guess, but, I am not exactly sure so I won’t. “Proper” is not an objective term - can you expand on that?

  My $0.02 is that when people want to do something new, they should do something *new*.

  Mangling existing tables && procedures is almost always the wrong idea.

  Alan DeKok.