accounting question

Hi,

I have a question about radius,
Is there anyone on this list that can help?
I'm sure this is a very common request.

I have a situation where radius accounting is logged to a mysql database.
I'd like to find a way to show the accurate number of users that are currently
online.

Up till now this has been done by querying the database to find entries in the
radacct table that have value 0 for AccountStopTime.
However there are quite a number of entries in this 'radacct' table that have
the 0 as AccountStopTime but are not active sessions.

What would be a way to get just the sessions that are active?


kind regards,
Luke
--
.............._
:| .| |.|/.|_
:|__.|_|.|\.|_
:0421 276 282.

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html