RadiusNT and SAM

=?us-ascii?Q?Pedro_Simoes?= ( Pedro.Simoes@inesc.pt )
Wed, 18 Mar 1998 17:28:47 -0000

I am currently evaluating RadiusNT and Emerald which (if all goes well)
will be included in a solution we are building for a new ISP.

So far, I have the setup running but I have one problem: I can't
autenticate users in the NT SAM database. Could this be because I am
running RadiusNT in a BDC? (this is a testing environment but the new
machines will arrive shortly and RadiusNT will be running in a PDC)

All the rest seems to work correctly. I can autenticate users if they are
they have their password in the Emerald database in the SQLServer.

Can you supply some help on this?
I enclose the output of radius running from the command line, and the
response to a "radlogin tduser1 tdpass".
User tduser1 is defined as a user of the CCAE domain and I am running
radius from an Administration account.

best regards,
Pedro Simoes (pms@ccae-sv.inesc.pt)

************************************************************************

C:\radius>radius -x15

RadiusNT 2.2.41 7/27/97 Copyright (c) 1996-1997 IEA Software, Inc.
All Rights Reserved, Worldwide

Some portions Copyright (c) 1992 Livingston Enterprises, Inc.
and Copyright (c) 1995 Ascend Communications, Inc.

0) EncryptPasswords: 0
1) IgnoreCase: 0
2) ReqAcctAuth: 0
3) Mode: 1
4) Options: 0
5) Debug: 15
6) ODBCDatasource: Radius
7) DataDirectory:
8) AcctDirectory:
9) UsersFile: Users
10) Username: sa
11) Password:
12) CompanyName:
13) License:

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'Radius'...
Making ODBC Connection...

30 Days left of your 45 day trial.
Allocating Statement...

SQL Statement: Select Name, RadAttributeID, Type From RadAttributes

SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv, RadAttribut
es ra Where rv.RadAttributeID = ra.RadAttributeId

SQL Statement: Select Server, IPAddress, Secret From Servers

3 Clients Loaded
16 Accounting Columns Loaded

Radius NT is ready to receive requests!
radrecv: Request from host 92c12169 code=1, id=1, length=0
NAS-Identifier = 127.0.0.1
NAS-Port = 0
User-Name = "tduser1"
Password = "\304\302o\002l\007\260\356\034M2\317I\353\206\204"
rad_authenticate_ODBC()
Password = "\304\302o\002l\007\260\356\034M2\317I\353\206\204"
ODBC Datasource: 'Radius'...
Making ODBC Connection...

SQL Statement: Select DateAdd(Day, (ma.extension + ma.overdue), maExpireDate),
DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType, sa.Passw
ord, sa.Login, sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login=
'tduser1' or sa.Shell='tduser1') AND ma.CustomerID=sa.CustomerID and sa.Active<>
0 and ma.Active<>0

Decrypted Password: tdpass
Database Password: WINNT\CCAE
(WINNT) User:tduser1 Domain:CCAE Password:tdpass
Sending Reject of id 1 to 92c12169 (bilu.inesc.pt)
LOG: User: tduser1 Not found

User: tduser1 Not found

SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, UserName, Data) VALUE
S (10, GetDate(), 'tduser1', 'tdpass')

Resp Time: 471 Auth: 0/1 -> 1 Acct: 0/0/0 -> 0