RE: [RadiusNT] Modifying RadCheckPort

Graeme Slogrove ( Graeme@na.co.za )
Thu, 9 Mar 2000 22:00:09 +0200

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

Regards,
Graeme

---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 [mailto:mikek@netdotcom.com]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 '255.255.255.255' 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 = 255.255.255.255)AND (sa.Port=@nasport or sa.Port is NULL)AND sa.AccountType = @atGO

Mike







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