RE: using the unix passwd file

Frank Nowling ( (no email) )
Tue, 14 Jul 1998 08:44:55 -0500

Dale,
Still no go. I didn't have the data directory specified, and now I do. Tried
it two different ways: c:\radius and c:\radius\. Here's the start up of
radius, and my attempted login (with passwords edited to protect the
innocent, except for the database password: UNIX). Any further thoughts?

Thanks
Frank

============================================
C:\radius>radius -x15

RadiusNT 2.5.124 Copyright (c) 1995-1997 IEA Software, Inc.
All Rights Reserved, Worldwide

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

0) IgnoreCase: 0
1) TrimName: 0
2) ReqAcctAuth: 0
3) AllowMalformed: 1
4) Mode: 1
5) Proxy: 0
6) Options: 195
7) Debug: 0
8) LogFile:
9) AcctLogFile:
10) ODBCDatasource: Radius
11) Username: radservice
12) Password: letmein
13) AcctODBCDatasource:
14) AcctUsername:
15) AcctPassword:
16) DataDirectory: c:\radius\
17) AcctDirectory:
18) UsersFile: Users
19) CompanyName: Netropolis Communications
20) License: yadda yadda yadda
21) IPAddress: All

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'Radius'...
Making ODBC Connection...
MS SQL Server Mode Enabled
ODBC Datasource: 'Radius'...
Making ODBC Connection...
MS SQL Server Mode Enabled
Allocating Statement...

SQL Statement: Select Name, RadAttributeID, Type From RadAttributes

SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv,
RadAttributes ra Where rv.RadAttributeID = ra.RadAttributeID

122 Dictionary Attributes Loaded...

SQL Statement: Select Server, IPAddress, Secret From Servers

12 Clients Loaded
Accounting Column 0 (16): 'NASIdentifier'
Accounting Column 1 (4): 'NASPort'
Accounting Column 2 (8): 'AcctSessionId'
Accounting Column 3 (2): 'AcctStatusType'
Accounting Column 4 (16): 'CallDate'
Accounting Column 5 (12): 'UserName'
Accounting Column 6 (2): 'AcctAuthentic'
Accounting Column 7 (2): 'UserService'
Accounting Column 8 (2): 'LoginService'
Accounting Column 9 (16): 'LoginHost'
Accounting Column 10 (4): 'AcctDelayTime'
Accounting Column 11 (4): 'AcctSessionTime'
Accounting Column 12 (4): 'FramedProtocol'
Accounting Column 13 (16): 'FramedAddress'
Accounting Column 14 (4): 'AcctInputOctets'
Accounting Column 15 (4): 'AcctOutputOctets'
Accounting Column 16 (4): 'AcctInputPackets'
Accounting Column 17 (4): 'AcctOutputPackets'
Accounting Column 18 (2): 'NASPortType'
Accounting Column 19 (10): 'ClientPortDNIS'
20 Accounting Columns Loaded

RadiusNT Standard Initialized...

radrecv: Request from host ccb02f51 code=1, id=187, length=58
NAS-IP-Address = 127.0.0.1
NAS-Port = 0
User-Name = "frankn"
Password = "\043!\375Q\224v\259\365/0\336c\337Z'y"
rad_authenticate_ODBC()
Password = "\043!\375Q\224v\259\365/0\336c\337Z'y"

SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,
(ma.Extension+ma.OverDue+1), maExpireDate)), DateDiff(Minute, GetDat
e(), DateAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID,
sa.AccountType, sa.Password, sa.Login, sa.Shell, sa.LoginLimit From
MasterAccounts ma, SubAccounts sa Where (sa.Login='frankn' or
sa.Shell='frankn') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 a
nd ma.Active<>0

Decrypted Password: letmein
Database Password: UNIX
Sending Reject of id 187 to ccb02f51 (dhcp10)

SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data)
VALUES (11, GetDate(), 'frankn', 'letmein')

User: frankn Bad Password

User: frankn Bad Password

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