Online Status with FR & SQL

[Alan DeKok]

"Gunther" <freeradius at caribsms.com> wrote:
> how do I know that the AcctStopTime=0 is not a 'leftover' ...
> Would it make sense to add a TIMESTAMP to the radacct table to record the
> last update?

  Sure.  If the NAS is supposed to send accounting updates every 15
minutes, and it's been an hour since the last one, you can guess that
the user isn't logged in any more.

> And would the use of TIMESTAMP for the radacct table produce some form of
> performance degrade?

  I doubt it.

  Alan DeKok.