Jim
At 05:42 PM 10/28/1999 -0700, you wrote:
>I am test RadiusNT with Oracle 8i for NT. But I found many errors like PPP=
=20
>Radius Attributes not found. I am attaching the debug file in which all=20
>errors are shown. Here is another error in file that "invalid date format".
>
>Salman
>
>
>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,=20
> RadVendorType From RadAttributes Order By RadVendorID, RadAttributeID
>
>
> SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv,=20
> RadAttributes ra Where rv.RadAttributeID =3D 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=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=20
> "\006\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
>rad_authenticate_ODBC()
>
> SQL Statement: Select maExpireDate+ma.Extension+1,=20
> saExpireDate+sa.Extension+1, sa.AccountID, sa.AccountType, sa.Password,=20
> sa.Login, sa.Shell, sa.TimeLeft, sa.LoginLimit From MasterAccounts ma,=
SubAc
>counts sa Where sa.Login=3D'test' AND ma.CustomerID=3Dsa.CustomerID and=
=20
>sa.Active<>0 and ma.Active<>0
>
>Checking for duplicate logins.
>
> SQL Statement: Select Count(Username) From ServerPorts Where=20
> Username=3D'test' and AcctStatusType=3D1
>
>ODBC Error:22007:0:
> [Oracle][ODBC]Invalid datetime format.
>
>
> SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type,=20
> rc.RadVendorID, rc.RadVendorType, rc.RadCheck From RadConfigs rc,=20
> RadAttributes ra Where ra.RadAttributeID=3Drc.RadAttributeID AND rc.A
>ccountID=3D1
>
>
> SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type,=20
> rc.RadVendorID, rc.RadVendorType, rc.RadCheck From RadATConfigs rc,=20
> RadAttributes ra Where ra.RadAttributeID=3Drc.RadAttributeID AND rc
>.AccountType=3D'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,=
=20
> CallerID) VALUES (19, sysdate, 'test', '++v?+GY=F1b=B1++J~+=B2=BC', NULL)
>
>Resp Time: 151 Auth: 0/1 -> 1 Acct: 0/0/0 -> 0
>
>
>
>
----------------------------
hostmaster@interaxs.net
InterNet Access Network
18 McDaniel Street
Dayton, OH 45405-4816
Voice: 937-461-3660 Fax:937-228-2773
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart