Re: [Emerald] Radius Error

Kenneth Gustav Eitenmiller Jr ( keitenmiller@hughestech.net )
Wed, 10 May 2000 11:54:37 -0500

This is a multi-part message in MIME format.

------=_NextPart_000_006C_01BFBA76.841ACF40
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_006D_01BFBA76.841ACF40"

------=_NextPart_001_006D_01BFBA76.841ACF40
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Attached is a SMALL text file showing the actual errors:

3 errors and 1 that went through ok...
Thanks,
Ken

------=_NextPart_001_006D_01BFBA76.841ACF40
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

Attached is a SMALL text file showing =the actual=20errors:
 
3 errors and 1 that went through =ok...
Thanks,
Ken
 
------=_NextPart_001_006D_01BFBA76.841ACF40--------=_NextPart_000_006C_01BFBA76.841ACF40Content-Type: text/plain; name="radiusbad.txt"Content-Transfer-Encoding: quoted-printableContent-Disposition: attachment; filename="radiusbad.txt"0) Mode: 11) IgnoreCase: 32) TrimName: 13) AuthPort: 16454) ReqAcctAuth: 05) AllowMalformed: 16) AcctPort: 16467) Proxy: 08) Options: 649) SNMP: 010) Debug: 1511) LogFile:=2012) AcctLogFile:=2013) ODBCDatasource: Emerald14) Username: sa15) Password: alena16) AcctODBCDatasource:=2017) AcctUsername:=2018) AcctPassword:=2019) TestDatabaseSecs:=2020) DataDirectory: C:\Radius21) AcctDirectory: C:\Radius22) UsersFile: users23) CompanyName:=2024) License:=2025) IPAddress: AllParam: Debug Level: 15Initializing Winsock...ODBC Datasource: 'Emerald'...Making ODBC Connection...MS SQL Server Mode EnabledODBC Datasource: 'Emerald'...Making ODBC Connection...MS SQL Server Mode EnabledLicensed MBRs: 3000 SQL Statement: Select Name, RadAttributeID, Type, RadVendorID, =RadVendorType From RadAttributes Order By RadVendorID DESC, =RadAttributeID DESC SQL Statement: Select ra.Name, rv.Name, rv.Value, rv.RadVendorID, =rv.RadVendorType From RadValues rv, RadAttributes ra Where =rv.RadAttributeID =3D ra.RadAttributeID and rv.RadVendorID =3D =ra.RadVendorID and rv.RadVendorType =3D ra.RadVendorType Order By =rv.RadVendorID DESC, rv.RadAttributeID DESC Dictionary: Vendors: 7 Attributes:286 Values: 198=20 SQL Statement: Select Server, IPAddress, Secret From Servers 3 Clients Loaded 19 Accounting Columns Loaded Enterprise features enabled.RadiusNT 2.5.206 (Emerald Standard) Initialized...radrecv: Request from host d1532104 code=3D4, id=3D200, length=3D262=0D Acct-Session-Id =3D "0e0b0083" User-Name =3D "cronan" NAS-Identifier =3D 209.83.33.4 NAS-Port =3D 84 Acct-Status-Type =3D Stop Acct-Session-Time =3D 459 Acct-Terminate-Cause =3D User-Request Acct-Authentic =3D RADIUS NAS-Port-DNIS =3D "6400" Connect-Speed =3D 32 Modulation_Type =3D 33 Simplified_MNP_Levels =3D 3 Simplified_V42bis_Usage =3D 1 Chasis-Call-Slot =3D 14 Chasis-Call-Span =3D 0 Chasis-Call-Channel =3D 11 Unauthenticated_Time =3D 23 NAS-Identifier =3D "beloit1.nserve" Acct-Input-Octets =3D 2233 Acct-Output-Octets =3D 697 Acct-Input-Packets =3D 52 Acct-Output-Packets =3D 10 NAS-Port-Type =3D Async User-Service =3D Framed-User Framed-Protocol =3D PPP Framed-Address =3D 209.83.33.69 Acct-Delay-Time =3D 0 SQL Statement: INSERT INTO Calls =(CallDate,AcctSessionID,Username,NASIdentifier,NASPort,AcctStatusType,Acc=tSessionTime,AcctTerminateCause,NASPortDNIS,AcctInputOctets,AcctOutputOct=ets,NASPortType,FramedAddress,AcctDelayTime) VALUES =(GetDate(),'0e0b0083','cronan','209.83.33.4',84,2,459,1,'6400',2233,697,0=,'209.83.33.69',0)ODBC Error:23000:2627: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY =constraint 'pk_Calls': Attempt to insert duplicate key in object ='Calls'.Sending Accounting Ack of id 200 to d1532104 (Beloit1)Resp Time: 20 Auth: 5/0 -> 5 Acct: 4/0/1 -> 5radrecv: Request from host d1532104 code=3D4, id=3D201, length=3D261=0D Acct-Session-Id =3D "03020035" User-Name =3D "RMOON" NAS-Identifier =3D 209.83.33.4 NAS-Port =3D 11 Acct-Status-Type =3D Stop Acct-Session-Time =3D 6603 Acct-Terminate-Cause =3D User-Request Acct-Authentic =3D RADIUS NAS-Port-DNIS =3D "6400" Connect-Speed =3D 27 Modulation_Type =3D 33 Simplified_MNP_Levels =3D 3 Simplified_V42bis_Usage =3D 1 Chasis-Call-Slot =3D 0 Chasis-Call-Span =3D 0 Chasis-Call-Channel =3D 6 Unauthenticated_Time =3D 25 NAS-Identifier =3D "beloit1.nserve" Acct-Input-Octets =3D 53714 Acct-Output-Octets =3D 264432 Acct-Input-Packets =3D 679 Acct-Output-Packets =3D 724 NAS-Port-Type =3D Async User-Service =3D Framed-User Framed-Protocol =3D PPP Framed-Address =3D 209.83.33.133 Acct-Delay-Time =3D 0 SQL Statement: INSERT INTO Calls =(CallDate,AcctSessionID,Username,NASIdentifier,NASPort,AcctStatusType,Acc=tSessionTime,AcctTerminateCause,NASPortDNIS,AcctInputOctets,AcctOutputOct=ets,NASPortType,FramedAddress,AcctDelayTime) VALUES =(GetDate(),'03020035','RMOON','209.83.33.4',11,2,6603,1,'6400',53714,2644=32,0,'209.83.33.133',0)ODBC Error:23000:2627: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY =constraint 'pk_Calls': Attempt to insert duplicate key in object ='Calls'.Sending Accounting Ack of id 201 to d1532104 (Beloit1)Resp Time: 30 Auth: 5/0 -> 5 Acct: 4/0/2 -> 6radrecv: Request from host d1532104 code=3D1, id=3D202, length=3D207=0D User-Name =3D "teachcu" Password =3D "G\027fP\003a\204\272\357\351\005c&\337\331\250" NAS-Identifier =3D 209.83.33.4 NAS-Port =3D 30 User-Service =3D Framed-User Framed-Protocol =3D PPP NAS-Port-DNIS =3D "6400" Connect-Speed =3D 26 Modulation_Type =3D 33 Simplified_MNP_Levels =3D 3 Simplified_V42bis_Usage =3D 1 Chasis-Call-Slot =3D 0 Chasis-Call-Span =3D 1 Chasis-Call-Channel =3D 1 NAS-Identifier =3D "beloit1.nserve" Acct-Session-Id =3D "0801006a" NAS-Port-Type =3D Asyncrad_authenticate_ODBC()=0D 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=3D'teachcu' AND ma.CustomerID=3Dsa.CustomerID and sa.Active<>0 =and ma.Active<>0 SQL Statement: RadGetConfigs 1076 SQL Statement: RadGetATConfigs 'PPP Wisc'Sending Ack of id 202 to d1532104 (Beloit1)=0D User-Service =3D Framed-User Framed-Protocol =3D PPP Session-Timeout =3D 28800Resp Time: 0 Auth: 6/0 -> 6 Acct: 4/0/2 -> 6radrecv: Request from host d1532104 code=3D4, id=3D203, length=3D227=0D Acct-Session-Id =3D "0801006a" User-Name =3D "teachcu" NAS-Identifier =3D 209.83.33.4 NAS-Port =3D 30 Acct-Status-Type =3D Start Acct-Authentic =3D RADIUS NAS-Port-DNIS =3D "6400" Connect-Speed =3D 26 Modulation_Type =3D 33 Simplified_MNP_Levels =3D 3 Simplified_V42bis_Usage =3D 1 Chasis-Call-Slot =3D 0 Chasis-Call-Span =3D 1 Chasis-Call-Channel =3D 1 Unauthenticated_Time =3D 24 NAS-Identifier =3D "beloit1.nserve" NAS-Port-Type =3D Async User-Service =3D Framed-User Framed-Protocol =3D PPP Framed-Address =3D 209.83.33.98 Acct-Delay-Time =3D 0 SQL Statement: INSERT INTO Calls =(CallDate,AcctSessionID,Username,NASIdentifier,NASPort,AcctStatusType,NAS=PortDNIS,NASPortType,FramedAddress,AcctDelayTime) VALUES =(GetDate(),'0801006a','teachcu','209.83.33.4',30,1,'6400',0,'209.83.33.98=',0)Sending Accounting Ack of id 203 to d1532104 (Beloit1)Resp Time: 30 Auth: 6/0 -> 6 Acct: 5/0/2 -> 7radrecv: Request from host d1532104 code=3D4, id=3D204, length=3D266=0D Acct-Session-Id =3D "07030078" User-Name =3D "sbwindstar" NAS-Identifier =3D 209.83.33.4 NAS-Port =3D 28 Acct-Status-Type =3D Stop Acct-Session-Time =3D 3755 Acct-Terminate-Cause =3D User-Request Acct-Authentic =3D RADIUS NAS-Port-DNIS =3D "6400" Connect-Speed =3D 31 Modulation_Type =3D 33 Simplified_MNP_Levels =3D 3 Simplified_V42bis_Usage =3D 1 Chasis-Call-Slot =3D 0 Chasis-Call-Span =3D 0 Chasis-Call-Channel =3D 23 Unauthenticated_Time =3D 29 NAS-Identifier =3D "beloit1.nserve" Acct-Input-Octets =3D 494825 Acct-Output-Octets =3D 1691555 Acct-Input-Packets =3D 7277 Acct-Output-Packets =3D 6316 NAS-Port-Type =3D Async User-Service =3D Framed-User Framed-Protocol =3D PPP Framed-Address =3D 209.83.33.101 Acct-Delay-Time =3D 0 SQL Statement: INSERT INTO Calls =(CallDate,AcctSessionID,Username,NASIdentifier,NASPort,AcctStatusType,Acc=tSessionTime,AcctTerminateCause,NASPortDNIS,AcctInputOctets,AcctOutputOct=ets,NASPortType,FramedAddress,AcctDelayTime) VALUES =(GetDate(),'07030078','sbwindstar','209.83.33.4',28,2,3755,1,'6400',49482=5,1691555,0,'209.83.33.101',0)ODBC Error:23000:2627: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY =constraint 'pk_Calls': Attempt to insert duplicate key in object ='Calls'.Sending Accounting Ack of id 204 to d1532104 (Beloit1)Resp Time: 40 Auth: 6/0 -> 6 Acct: 5/0/3 -> 8------=_NextPart_000_006C_01BFBA76.841ACF40--