From: "Craig Hulbert" <craig@daytondigital.net> Subject: [RadiusNT] RadiusNT RADLOGIN problems after server migration Date: Mon, 18 Aug 2003 17:04:56 -0400 Message-ID: <000b01c365cc$66d6c1f0$6401a8c0@barolo>
... Old Emerald 2.5 Server died
Install on new server and try to get life happy..
All NAS's auth fine and life seems ok.. But
I use radlogin to test things as we all do.. And I can't seem to get it
working...
I would greatly appreciate any help.. It has been too long since I have
had to install emerald or radiusnt to remember what causes radlogin to
not work...
Debug snippet...
0) IgnoreCase: 0
1) ReqAcctAuth: 0
2) AllowMalformed: 0
3) TrimName: 0
4) Mode: 1
5) Proxy: 0
6) Options: 1097
7) SNMP: 3
8) Debug: 0
9) LogFile:
10) AcctLogFile:
11) ODBCDatasource: radius
14) AcctODBCDatasource:
15) AcctUsername:
16) AcctPassword:
17) TestDatabaseSecs:
18) DataDirectory: d:\Progra~1\emerald
19) AcctDirectory: d:\Progra~1\emerald
20) UsersFile: Users
21) CompanyName:
22) License:
23) IPAddress: All
24) AuthPort: 1645
25) AcctPort: 1646
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
Licensed MBRs: 500
SQL Statement: Select Name, RadAttributeID, Type, RadVendorID,
RadVendorType From RadAttributes Order By RadVendorID, RadAttributeID
DESC
SQL Statement: Select ra.Name, rv.Name, rv.Value, rv.RadVendorID,
rv.RadVendorType From RadValues rv, RadAttributes ra Where
rv.RadAttributeID = ra.RadAttributeID and rv.RadVendorID =
ra.RadVendorID and rv.RadVendorType = ra.RadVendorType Order By
rv.RadVendorID, rv.RadAttributeID DESC
Dictionary: Vendors: 7 Attributes:367 Values: 391
SQL Statement: Select Server, IPAddress, Secret From Servers
5 Clients Loaded
19 Accounting Columns Loaded
Enterprise features enabled.
RadiusNT 2.5.217 (Emerald Standard) Initialized...
radrecv: Request from host 7f000001 code=1, id=107, length=60
NAS-Identifier = 127.0.0.1
NAS-Port = 0
User-Name = "chulbert"
Password = "\232QG\253v\257O5\207\335\006\036\244Bpv"
rad_authenticate_ODBC()
SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,
(ma.Extension+ma.OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(),
DateAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID,
sa.AccountType, sa.Password, sa.Login, sa.Shell, sa.LoginLimit,
ma.Balance, ma.OverLimit From MasterAccounts ma, SubAccounts sa Where
sa.Login='chulbert' AND ma.CustomerID=sa.CustomerID and
sa.Active<>0
and ma.Active<>0
Decrypted Password: §çSÍ=rßÅU]øëØu
Database Password: password
Sending Reject of id 107 to 7f000001 (localhost)
SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username,
Data, NASIdentifier, NASPort, CallerID) VALUES (11, GetDate(),
'chulbert', '§çSÍ=rßÅU]øëØu', '127.0.0.1', 0,
NULL)
User: chulbert Bad Password
Resp Time: 51 Auth: 0/1 -> 1 Acct: 0/0/0 -> 0
CLEANUP IN PROGRESS (2)....