[RadiusNT] PPP Radius Attribute not found

Salman Karim ( (no email) )
Thu, 28 Oct 1999 17:42:44 PDT

------------------------------------------------------------------------
This mail message contains standard MIME attachments. If you see this
note, your e-mail program does not support MIME. You may need a MIME-
compliant mail reader to read any non-text attachments in this message.
------------------------------------------------------------------------

--==IMail_v5.0==
Content-Type: text/plain; charset=us-ascii

I am test RadiusNT with Oracle 8i for NT. But I found many errors like PPP Radius Attributes not found. I am attaching the debug file in which all errors are shown. Here is another error in file that "invalid date format".

Salman

--==IMail_v5.0==
Content-Type: text/plain; name="Debug.txt "
Content-Transfer-Encoding: binary

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

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

0) Mode: 1
1) IgnoreCase: 3
2) TrimName: 1
3) AuthPort: 1645
4) ReqAcctAuth: 1
5) AllowMalformed: 0
6) AcctPort: 1646
7) Proxy: 0
8) Options: 583
9) SNMP: 0
10) Debug: 15
11) LogFile:
12) AcctLogFile:
13) ODBCDatasource: Radius
14) Username: sa
15) Password: sa
16) AcctODBCDatasource: Radius
17) AcctUsername: sa
18) AcctPassword: sa
19) TestDatabaseSecs:
20) DataDirectory:
21) AcctDirectory:
22) UsersFile: Users
23) CompanyName:
24) License:
25) IPAddress: All

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'Radius'...
Making ODBC Connection...
Oracle RDBMS Mode Enabled

SQL Statement: Select DISTINCT Company, LicenseID From Licenses

ODBC Datasource: 'Radius'...
Making ODBC Connection...
Oracle RDBMS Mode Enabled

SQL Statement: Select DISTINCT Company, LicenseID From Licenses

Allocating Statement...

SQL Statement: Select Name, RadAttributeID, Type, RadVendorID, RadVendorType From RadAttributes Order By RadVendorID, RadAttributeID

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

161 Dictionary Attributes Loaded...

SQL Statement: Select Server, IPAddress, Secret From Servers

2 Clients Loaded
Accounting Column 0 (16): 'NASIDENTIFIER'
Accounting Column 1 (22): 'NASPORT'
Accounting Column 2 (10): 'ACCTSESSIONID'
Accounting Column 3 (22): 'ACCTSTATUSTYPE'
Accounting Column 4 (7): 'CALLDATE'
Accounting Column 5 (32): 'USERNAME'
Accounting Column 6 (22): 'ACCTDELAYTIME'
Accounting Column 7 (22): 'ACCTSESSIONTIME'
Accounting Column 8 (16): 'FRAMEDADDRESS'
Accounting Column 9 (22): 'ACCTTERMINATECAUSE'
10 Accounting Columns Loaded

RadiusNT 2.5.175 Standard Initialized...

radrecv: Request from host c0a80120 code=1, id=8, length=90
User-Name = "test"
CHAP-Challenge = "5\347\230~#\337Nc\320K\177\367\317 \277\001"
Challenge-Response = "\006\3329f\036\264\300E\313)c\253\247\232\032\246\254"
NAS-Port = 2
Framed-Protocol = PPP
NAS-Identifier = "TRANING"
NAS-Port-Type = 5
rad_authenticate_ODBC()

SQL Statement: Select maExpireDate+ma.Extension+1, saExpireDate+sa.Extension+1, sa.AccountID, sa.AccountType, sa.Password, sa.Login, sa.Shell, sa.TimeLeft, sa.LoginLimit From MasterAccounts ma, SubAc
counts sa Where sa.Login='test' AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0

Checking for duplicate logins.

SQL Statement: Select Count(Username) From ServerPorts Where Username='test' and AcctStatusType=1

ODBC Error:22007:0:
[Oracle][ODBC]Invalid datetime format.

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type, rc.RadVendorID, rc.RadVendorType, rc.RadCheck From RadConfigs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.A
ccountID=1

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type, rc.RadVendorID, rc.RadVendorType, rc.RadCheck From RadATConfigs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc
..AccountType='PPP'

Sending Reject of id 8 to c0a80120 (192.168.1.32)
test: PPP has no RADIUS default attributes.

test: PPP has no RADIUS default attributes.

SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data, CallerID) VALUES (19, sysdate, 'test', '++v?+GYb++J~+', NULL)

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

--==IMail_v5.0==--