RE: [RadiusNT] Radius 3.0 Crashes

Nathan Haywood ( nhaywood@whro.org )
Fri, 5 May 2000 11:55:14 -0400

PS: There seems to be a typo in the CHANGES.TXT under 3.0.171. The updated
calls_insert trigger is either missing a '(' or has an extra ')' in the
filter for the UPDATE to ServerPorts. I'm assuming the trigger should be as
follows:

CREATE TRIGGER calls_insert ON dbo.Calls
FOR INSERT
AS
UPDATE sp
Set sp.Username = i.Username,
sp.AcctStatusType = i.AcctStatusType,
sp.CallDate = i.CallDate,
sp.FramedAddress = i.FramedAddress,
sp.CallerID = i.CallerID,
sp.ConnectInfo = i.ConnectInfo,
sp.AcctSessionID = i.AcctSessionID
FROM Servers s, ServerPorts sp, inserted i
WHERE s.IPAddress = i.NASIdentifier AND
s.ServerID = sp.ServerID AND
sp.Port = i.NASPort AND
(i.CallDate >= sp.CallDate OR
sp.CallDate IS NULL)

UPDATE sa
Set sa.TimeLeft = sa.TimeLeft - (i.AcctSessionTime/60 + 1),
sa.LastModifyDate = getdate()
FROM SubAccounts sa, inserted i
WHERE sa.Login = i.Username
AND sa.TimeLeft IS NOT NULL
AND i.AcctStatusType = 2

-----Original Message-----
From: Peter Deacon [mailto:peterd@iea-software.com]
Sent: Friday, May 05, 2000 10:38 AM
To: radiusnt@iea-software.com
Subject: Re: [RadiusNT] Radius 3.0 Crashes

On Fri, 5 May 2000, NCKCN wrote:

> Peter,
> Is the RadiusNT 3 updated from 3.0.163? There doesn't seem to be any
> descriptor on the FTP site. It just says RadiusNT30.exe.

Ya, the one on the ftp site is 3.0.172.

ciao,
Peter

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart