Undeliverable: Re: CallsOnline

System Administrator ( postmaster@orca.net )
Wed, 21 Oct 1998 17:30:58 -0500

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_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">
Undeliverable: Re: CallsOnline

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 2

        UPDATE =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



--
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.79B74FB0--

------_=_NextPart_000_01BDFD42.79B74FB0--