RE: [RadiusNT] Modifying RadCheckPort

Graeme Slogrove ( )
Thu, 9 Mar 2000 22:00:09 +0200

There's no reason why you cannnot do what you describe below.


---Graeme Slogrove, BSc (Eng) Elec (Wits)Director, Systems Development & Value Added ServicesNetActive InternetTel: 011-719-0333    Fax: 011-719-0444Support: 011-719-0300

-----Original Message-----From: Mike@NetDotCom []Sent: 09 March 2000 06:30To: RadiusNTSubject: [RadiusNT] Modifying RadCheckPort

Would it be possible to put a wildcard for the 'nasid' in the RadCheckPortjust like for the port. We are currently using a wildcard for the port.

Reason: We are using a port provider and the requests come from multipleNAS's and I don't want to list every single (300+) NAS's

Something like below '' being the wildcard address.

CREATE PROCEDURE RadCheckPort @nasid varchar(16), @nasport integer, @atvarchar(15) ASSelect MaxSessionLength, StartTime, StopTime, CurrTime = (DatePart(Hour,GetDate()) * 60) + DatePart(Minute, GetDate())>From Servers s, ServerAccess saWhere s.ServerID = sa.ServerIDAND (s.IPAddress = @nasid or s.IPAddress = (sa.Port=@nasport or sa.Port is NULL)AND sa.AccountType = @atGO


For more information about this list (including removal) go to:

For more information about this list (including removal) go to: