Caller-Id = "295575635"
NAS-Port-DNIS = "99490916"
Modulation_Type = 20
Simplified_MNP_Levels = 4
Simplified_V42bis_Usage = 1
Connect-Speed = 23
Listed above is a cut of the -x15 debug, Connect-Speed = 23 is this what
should be displayed in the connect info.
David Moore
Moored@romtech.com.au
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of Dale E. Reed Jr.
Sent: Monday, 12 April 1999 06:38
To: emerald@iea-software.com
Subject: Re: [Emerald] ConnectInfo not showing
David Moore wrote:
>
> Equipment TC Hyperarc
> Radius NT v2.5.162
> Emerald v2.5.267
> SQL 6.5
>
> CallerID shows ok
> ConnectInfo NOT SHOWING
USR doesn't support the ConnectInfo attribute. I heard their response
was that it wasn't part of the RADIUS draft (which is true), but it s
part of the RADIUS Extensions draft. I believe they do have a VSA
that reports the connect rates that you might be able to use, though.
> CallsOnline View
>
> if exists (select * from sysobjects where id =
object_id('dbo.CallsOnline')
> and sysstat & 0xf = 2)
> drop view dbo.CallsOnline
> GO
>
> CREATE VIEW CallsOnline(NASIdentifier, NASPort, Username,AcctStatusType,
> CallDate, FramedAddress, ConnectInfo, CallerID) AS
> Select s.IPAddress, Port, Username, AcctStatusType,
CallDate,FramedAddress,
> ConnectInfo, CallerID
> >From ServerPorts sp, Servers s
>
> Where s.ServerID=sp.ServerID
>
> GO
>
> FIELD IS IN CALLS TABLE
> ConnectInfo varchar 32
>
> FIELD IS IN ServerPorts TABLE
> ConnectInfo varchar 32
>
> How do I get ConnectInfo to work what am I missing?
Is its storing in the Calls table and not the ServrsPorts, or not
in eiter?
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com