------_=_NextPart_000_01BDFD42.79B74FB0
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01BDFD42.79B74FB0"
------_=_NextPart_001_01BDFD42.79B74FB0
Content-Type: text/plain
Your message
To: Ronnie D. Franklin
Cc: radiusnt@iea-software.com
Subject: Re: CallsOnline
Sent: Wed, 21 Oct 1998 17:22:37 -0500
did not reach the following recipient(s):
madams@orca.net on Wed, 21 Oct 1998 17:30:45 -0500
The recipient name is not recognized
MSEXCH:IMS:Orca Technologies Inc.:OTEXS1:OTBDC1 0 (000C05A6) Unknown
Recipient
------_=_NextPart_001_01BDFD42.79B74FB0
Content-Type: text/html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
Your message
To: Ronnie D. Franklin
Cc: radiusnt@iea-software.com
Subject: Re: CallsOnline
Sent: Wed, 21 Oct 1998 17:22:37 -0500
did not reach the following recipient(s):
madams@orca.net on Wed, 21 Oct 1998 17:30:45 -0500
The recipient name is not recognized
MSEXCH:IMS:Orca Technologies Inc.:OTEXS1:OTBDC1 0 (000C05A6) Unknown Recipient
------_=_NextPart_001_01BDFD42.79B74FB0--
------_=_NextPart_000_01BDFD42.79B74FB0
Content-Type: message/rfc822
Content-Location: ATT-0-6167D96F2069D211A43500805F8AF4A3
Message-ID: <362E5EAD.9F3594F@iea-software.com>
From: "Dale E. Reed Jr." <daler@iea-software.com>
To: "Ronnie D. Franklin" <ronnie@itexas.net>
Cc: radiusnt@iea-software.com
Subject: Re: CallsOnline
Date: Wed, 21 Oct 1998 17:22:37 -0500
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2232.9)
X-MS-Embedded-Report:
Content-Type: multipart/alternative;
boundary="----_=_NextPart_003_01BDFD42.79B74FB0"
------_=_NextPart_003_01BDFD42.79B74FB0
Content-Type: text/plain;
charset="windows-1252"
Ronnie D. Franklin wrote:
>
> I am trying to test beta code for Cisco.. and it has the update intermin
> packet available..
>
> Here is what is happening:
>
> Radius seems to be handling everything fine.. Start record, update
> intermin, and stop...
>
> However, Emerald 2.3xx gets the start record, displays the user in the
calls
> online, and then when it gets the:
>
> update intermin record ACCT-STATUS-TYPE = 3
>
> the call disappears out of the table.. I assume because the
ACCT-STATUS-TYPE
> equals 3 instead of 1...
>
> I am going to look at the stored procedures see if I can figure it out..
but
> I'm not all that good with SQL.. so if you can reply with a suggestion
> SOON.. I would appreciate it!!
This will only work with the trigger. Modify it like this:
CREATE TRIGGER calls_insert ON dbo.Calls
FOR INSERT
AS
UPDATE ServerPorts
Set sp.UserName = i.UserName,
sp.AcctStatusType = i.AcctStatusType,
sp.CallDate = DateAdd(Second, 0-i.AcctDelayTime,
i.CallDate),
sp.FramedAddress = i.FramedAddress
FROM Servers s, ServerPorts sp, inserted i
WHERE s.IPAddress = i.NASIdentifier AND
s.ServerID = sp.ServerID AND
sp.Port = i.NASPort AND
(DateAdd(Second, 0-i.AcctDelayTime, i.CallDate) >=
sp.CallDate OR
sp.CallDate IS NULL) AND
AcctStatusType <= 2
UPDATE SubAccounts
Set sa.TimeLeft = sa.TimeLeft - (i.AcctSessionTime/60 +
1)
FROM SubAccounts sa, inserted i
WHERE sa.login = i.UserName
and sa.TimeLeft <> NULL
and i.AcctStatusType = 2
GO
-- 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------_=_NextPart_003_01BDFD42.79B74FB0Content-Type: text/html; charset="windows-1252"Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
Re: CallsOnline Ronnie D. Franklin wrote:
>
> I am trying to test beta code for Cisco.. and =it has the update intermin
> packet available..
>
> Here is what is happening:
>
> Radius seems to be handling everything =fine.. Start record, update
> intermin, and stop...
>
> However, Emerald 2.3xx gets the start record, =displays the user in the calls
> online, and then when it gets the:
>
> update intermin record ACCT-STATUS-TYPE ==3D 3
>
> the call disappears out of the table.. I assume =because the ACCT-STATUS-TYPE
> equals 3 instead of 1...
>
> I am going to look at the stored procedures see =if I can figure it out.. but
> I'm not all that good with SQL.. so if you can =reply with a suggestion
> SOON.. I would appreciate it!!This will only work with the trigger. Modify it =like this:
CREATE TRIGGER calls_insert ON dbo.Calls
FOR INSERT
AS
UPDATE =ServerPorts
&nb=sp; Set sp.UserName =3D i.UserName,
&nb=sp; &nb=sp; sp.AcctStatusType =3D i.AcctStatusType,
= sp.CallDate =3D DateAdd(Second, 0-i.AcctDelayTime, =i.CallDate),= sp.FramedAddress =3D i.FramedAddress
&nb=sp; FROM Servers s, ServerPorts sp, inserted =i
&nb=sp; WHERE s.IPAddress =3D i.NASIdentifier =AND
= s.ServerID =3D sp.ServerID AND
&nb=sp; &nb=sp; sp.Port =3D i.NASPort AND
= (DateAdd(Second, 0-i.AcctDelayTime, i.CallDate) >=3D =sp.CallDate OR= sp.CallDate IS NULL) AND
= AcctStatusType <=3D 2UPDATE =SubAccounts
&nb=sp; Set sa.TimeLeft =3D sa.TimeLeft - =(i.AcctSessionTime/60 +
1)
&nb=sp; FROM SubAccounts sa, inserted i
&nb=sp; WHERE sa.login =3D i.UserName
= and =sa.TimeLeft <> NULL
= and =i.AcctStatusType =3D 2
GO--
------_=_NextPart_003_01BDFD42.79B74FB0--
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------_=_NextPart_000_01BDFD42.79B74FB0--