RE: accounting question

I think radwho can accomplish this request

-----Original Message-----
From: freeradius-users-admin@lists.freeradius.org
[mailto:freeradius-users-admin@lists.freeradius.org] On Behalf Of
luke@chipcity.com.au
Sent: Tuesday, May 03, 2005 9:38 AM
To: freeradius-users@lists.freeradius.org
Subject: 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
--=20
.............._
:| .| |.|/.|_
:|__.|_|.|\.|_
:0421 276 282.

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




************************************************** ***********************=
************
The contents of this email and any attachments are confidential. It is=20
intended for the named recipient(s) only. If you have received this email=
=20
in error please notify the system manager or the sender immediately and=20
do not disclose the contents to any one or make copies.
************************************************** ***********************=
************
PALTEL E-Safety System scanned this email and found NO viruses,=20
vandals or malicious content.
************************************************** ***********************=
************
Should you need any information or clarifications regarding this system,=20
please do not hesitate to contact our team at the IP Dep.=20
<esafety@paltel.net>.
************************************************** ***********************=
************

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