[RadiusNT Digest]

radiusnt-digest-request@iea-software.com
Mon, 25 May 1998 00:00:47 -0700

Message 1: Re: online-usage cgi
from "Danny Sinang" <danny@uplink.com.ph>

Message 2: Re: online-usage cgi
from "Danny Sinang" <danny@uplink.com.ph>

Message 3: Re: online-usage cgi
from "Dale E. Reed Jr." <daler@iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: online-usage cgi
From: "Danny Sinang" <danny@uplink.com.ph>
Date: Sun, 24 May 1998 17:56:50 +0800

Can MRTG show the number of ports in use by RRAS ?

I know MRTG uses SNMP but I am not sure if RRAS has an SNMP agent. Would
anyone out there know for sure ?

- Danny Sinang

-----Original Message-----
From: Carlo Gibertini <carlo@nw.com.br>
To: RadiusNT@iea-software.com <RadiusNT@iea-software.com>
Date: Thursday, May 14, 1998 4:25 AM
Subject: Re: online-usage cgi

>I use MRTG to show the number of ports in use in my Portmasters
>
>You can see at http://www2.nw.com.br/modems/pm.3.html
>
>If this can solve your problem, let me know to help you.
>
>Abraços,
>
>Carlo
>
>
>
>----------
>> De: Brian Lube <brian@mpinet.net>
>> Para: RadiusNT mailing list <radiusnt@emerald.iea.com>
>> Assunto: online-usage cgi
>> Data: Quarta-feira, 13 de Maio de 1998 12:40
>>
>>
>> I was wondering if anyone out there had come up with a CGI that will
>check
>> the number of users that are online (from the callsonline table) and
>create
>> a web interface with history so that people can track the maximum number
>of
>> modems used over a period of time. What I want to do is tell usage
>> information for my different POP's without having to watch it every
>night.
>>
>> Any ideas?
>>
>>
>> Brian Lube
>> senior technician
>> MPInet
>>
>> http://www.mpinet.net
>>
>> ----------------------------------------------------------
>> RadiusNT Mailing List lists@iea-software.com
>>
>
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: online-usage cgi
From: "Danny Sinang" <danny@uplink.com.ph>
Date: Sun, 24 May 1998 18:06:32 +0800

Dale,

I would like to make an online usage graph like the MRTG one at
http://www2.nw.com.br/modems/pm.3.html but I don't know if MRTG could access
RRAS's info.

So, I would want to base the graph on the Calls table populated by RadiusNT.
I've been pushing my brain to the limit on how to do it, but I just can't
think of a neat, clean-cut SQL-based way of doing it.

All I've figured out so far is to programmatically create a "Stack" table
and "Push" values ( Calldate, NasPort, Username ) in for each login, along
with an incrementing counter value ( to indicate increase in number of ports
being used ). For each logout, I would "Push" a row also, but this time
with decrementing ctr value ( to indicate a decrease in ports in use ).

Then after this "Stack" table is populated, I would simply use Crystal
Reports Web Report to graph the increasing / decreasing Counter value
against their associated Calldate's.

Can you show me a better way of doing this ?

- Danny Sinang

-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: RadiusNT@iea-software.com <RadiusNT@iea-software.com>
Date: Thursday, May 14, 1998 3:38 PM
Subject: Re: online-usage cgi

>Danny Sinang wrote:
>>
>> Is there an online version of this graph that we can view ?
>
>Not publically. :( I did a lot of Cold Fusion scripts and such for
>an earlier version of Emerald that is still used in several intranet
>installations of Emerald (including adding, updating, tsgraph, etc).
>A lot of the work will be available in Emerald 3.0 based on our
>own engine rather than CF.
>
>The particular TS Graph I referenced uses the old Graphlets that
>I don't think Allaire supports anymore (although you can get them
>from their ftp site). They are really cool for graphing things and
>I used them in several places.
>
>
>--
>Dale E. Reed Jr. (daler@iea-software.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: online-usage cgi
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Sun, 24 May 1998 11:27:42 -0700

Danny Sinang wrote:
>
> I would like to make an online usage graph like the MRTG one at
> http://www2.nw.com.br/modems/pm.3.html but I don't know if MRTG could access
> RRAS's info.
>
> So, I would want to base the graph on the Calls table populated by RadiusNT.
> I've been pushing my brain to the limit on how to do it, but I just can't
> think of a neat, clean-cut SQL-based way of doing it.
>
> All I've figured out so far is to programmatically create a "Stack" table
> and "Push" values ( Calldate, NasPort, Username ) in for each login, along
> with an incrementing counter value ( to indicate increase in number of ports
> being used ). For each logout, I would "Push" a row also, but this time
> with decrementing ctr value ( to indicate a decrease in ports in use ).
>
> Then after this "Stack" table is populated, I would simply use Crystal
> Reports Web Report to graph the increasing / decreasing Counter value
> against their associated Calldate's.
>
> Can you show me a better way of doing this ?

We do this, but its SQL Server based.

First, Go into your Servers table and make sure your Location fields are
setup so that they match (typically your regions or pops).

Then create a table like this:

CREATE TABLE dbo.OnlineCount (
Date smalldatetime NOT NULL ,
Location varchar (15) NOT NULL ,
UserCount int NOT NULL
)

Lastly, using SQL Executing to execute a command like this on what ever
interval you want your granularity:

Insert Into OnlineCount
Select GetDate(), Location, Count(Username)