n--------- Original Message ----------------------------------
Fhostmaster@interaxs.net
RTo: radiusnt@iea-software.com
DThu, 28 Oct 1999 08:48:38 -0400
ocumentation regarding the RadATConfigs table. You must make
>lt entries for each 'account type' that you will use.
>m
> 05:42 PM 10/28/1999 -0700, you wrote:
> test RadiusNT with Oracle 8i for NT. But I found many errors like PPP
>us Attributes not found. I am attaching the debug file in which all
>rs are shown. Here is another error in file that "invalid date format".
>Salman
>
>usNT 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
>gnoreCase: 3
>rimName: 1
>uthPort: 1645
>eqAcctAuth: 1
>llowMalformed: 0
>cctPort: 1646
>roxy: 0
>ptions: 583
>NMP: 0
>Debug: 15
>LogFile:
>AcctLogFile:
>ODBCDatasource: Radius
>Username: sa
>Password: sa
>AcctODBCDatasource: Radius
>AcctUsername: sa
>AcctPassword: sa
>TestDatabaseSecs:
>DataDirectory:
>AcctDirectory:
>UsersFile: Users
>CompanyName:
>License:
>IPAddress: All
>Param: Debug Level: 15
>ializing Winsock...
> Datasource: 'Radius'...
>ng ODBC Connection...
>le RDBMS Mode Enabled
> SQL Statement: Select DISTINCT Company, LicenseID From Licenses
>ODBC Datasource: 'Radius'...
>ng ODBC Connection...
>le RDBMS Mode Enabled
> SQL Statement: Select DISTINCT Company, LicenseID From Licenses
>Allocating Statement...
> SQL Statement: Select Name, RadAttributeID, Type, RadVendorID,
>VendorType From RadAttributes Order By RadVendorID, RadAttributeID
>
>L Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv,
>Attributes ra Where rv.RadAttributeID =3D ra.RadAttributeID
> 161 Dictionary Attributes Loaded...
> SQL Statement: Select Server, IPAddress, Secret From Servers
> 2 Clients Loaded
>unting Column 0 (16): 'NASIDENTIFIER'
>unting Column 1 (22): 'NASPORT'
>unting Column 2 (10): 'ACCTSESSIONID'
>unting Column 3 (22): 'ACCTSTATUSTYPE'
>unting Column 4 (7): 'CALLDATE'
>unting Column 5 (32): 'USERNAME'
>unting Column 6 (22): 'ACCTDELAYTIME'
>unting Column 7 (22): 'ACCTSESSIONTIME'
>unting Column 8 (16): 'FRAMEDADDRESS'
>unting Column 9 (22): 'ACCTTERMINATECAUSE'
> Accounting Columns Loaded
>RadiusNT 2.5.175 Standard Initialized...
>
>ecv: Request from host c0a80120 code=3D1, id=3D8, length=3D90
> User-Name =3D "test"
> CHAP-Challenge =3D "5\347\230~#\337Nc\320K\177\367\317 \277\001"
> Challenge-Response =3D
>06\3329f\036\264\300E\313)c\253\247\232\032\246\254"
> NAS-Port =3D 2
> Framed-Protocol =3D PPP
> NAS-Identifier =3D "TRANING"
> NAS-Port-Type =3D 5
>authenticate_ODBC()
> SQL Statement: Select maExpireDate+ma.Extension+1,
>xpireDate+sa.Extension+1, sa.AccountID, sa.AccountType, sa.Password,
>Login, sa.Shell, sa.TimeLeft, sa.LoginLimit From MasterAccounts ma, SubAc
>ts sa Where sa.Login=3D'test' AND ma.CustomerID=3Dsa.CustomerID and
>ctive<>0 and ma.Active<>0
>Checking for duplicate logins.
> SQL Statement: Select Count(Username) From ServerPorts Where
>rname=3D'test' and AcctStatusType=3D1
>ODBC Error:22007:0:
>racle][ODBC]Invalid datetime format.
>
>L Statement: Select ra.RadAttributeID, Name, Data, Value, Type,
>RadVendorID, rc.RadVendorType, rc.RadCheck From RadConfigs rc,
>Attributes ra Where ra.RadAttributeID=3Drc.RadAttributeID AND rc.A
>ntID=3D1
>
>L Statement: Select ra.RadAttributeID, Name, Data, Value, Type,
>RadVendorID, rc.RadVendorType, rc.RadCheck From RadATConfigs rc,
>Attributes ra Where ra.RadAttributeID=3Drc.RadAttributeID AND rc
>ountType=3D'PPP'
>Sending Reject of id 8 to c0a80120 (192.168.1.32)
>: 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?+GY=FFFFFFF1b=FFFFFFB1++J~+=FFFFFFB2=FFFFFFBC', NULL)=
>Time: 151 Auth: 0/1 -> 1 Acct: 0/0/0 -> 0
>
>
>--------------------------
>aster@interaxs.net
>Net Access Network
>Daniel Street
>n, OH 45405-4816
>: 937-461-3660 Fax:937-228-2773
>r more information about this list (including removal) go to:
>//www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart