Re: [RadiusNT] RadGetUser in RadiusNT30

Peter Deacon ( peterd@iea-software.com )
Thu, 15 Jun 2000 11:18:07 -0700 (Pacific Daylight Time)

On Thu, 15 Jun 2000, Christian Gatti wrote:

> Option 'Disable User Cache Authentication' in RadiusNT Administrator 3.0 is
> checked.

> I tried to intercept the username and password of every user that logs in,
> by adding a sql-insert-cmd to the stored procedure 'RadGetUsers':

Hmm, Create an MBR for the accounts you want to import into your other
radius server and write down it's CustomerID.

> CREATE PROCEDURE RadGetUser @user VARCHAR(64) , @password VARCHAR(32) AS

IF NOT EXISTS (SELECT * FROM SubAccounts WHERE Login = @user)
BEGIN
INSERT INTO SubAccounts
(CustomerID,FirstName,LastName,AccountType,Login,Password,LoginLimit)
SELECT (customer id of your new mbr), 'spy','table','PPP',@user,'ANY',1
END

SELECT ... (The stock SELECT statement which comes with RadGetUser)
go

Enable Password replace in Radius Administrator.

This will create a SubAccount for each missing user (as they login) in the
database. With password replace Radius replaces the ANY keyword in the
new accounts password field with the password they entered.

Have Fun!
Peter

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