RE: [RadiusNT] Changing StoredProcedures

Graeme Slogrove ( Graeme@na.co.za )
Tue, 14 Sep 1999 21:41:27 +0200

Radius does not only use this stored procedure when verifying users

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: Nicolaj Ottsen [mailto:no@webpartner.dk]Sent: 14 September 1999 05:32To: radiusnt@iea-software.comSubject: [RadiusNT] Changing StoredProcedures

I have tried to change some of the different StoredProcedures, ex.RadGetUser.

Before:

CREATE PROCEDURE RadGetUser @user VARCHAR(64) , @password VARCHAR(32) ASSELECT sa.AccountID, sa.Login, sa.Password, NULL, sa.AccountType,sa.LoginLimit, sa.TimeLeft, MasterExpire=DateAdd(Day, ma.Extension+ma.OverDue+1, maExpireDate), SubExpire=DateAdd(Day, sa.Extension+1, saExpireDate) FROM SubAccounts sa, MasterAccounts ma WHERE sa.CustomerID = ma.CustomerID AND sa.Active <> 0 AND ma.Active <> 0 AND sa.Login = @user AND sa.Password = @password

Now:

CREATE PROCEDURE RadGetUser @user VARCHAR(64) , @password VARCHAR(32) ASSELECT sa.AccountID, sa.Login, sa.Password, NULL, sa.AccountType,sa.LoginLimitFROM SubAccounts sa, MasterAccounts ma WHERE sa.CustomerID = ma.CustomerID AND sa.Active <> 0 AND ma.Active <> 0 AND sa.Login = @user AND sa.Password = @password

I removed the sections with ExpireDate verification, since we don't needthat, but the server still runs the same SQL when verifing users. That is

CREATE PROCEDURE RadGetUser @user VARCHAR(64) , @password VARCHAR(32) ASSELECT sa.AccountID, sa.Login, sa.Password, NULL, sa.AccountType,sa.LoginLimit, sa.TimeLeft, MasterExpire=DateAdd(Day, ma.Extension+ma.OverDue+1, maExpireDate), SubExpire=DateAdd(Day, sa.Extension+1, saExpireDate) FROM SubAccounts sa, MasterAccounts ma WHERE sa.CustomerID = ma.CustomerID AND sa.Active <> 0 AND ma.Active <> 0 AND sa.Login = @user AND sa.Password = @password

Is the SQL code "HardCoded" into RadiusNT ?

Nicolaj OttsenTjantik

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