Re: On the Bleeding Edge again

Mitchell B. Wagers ( (no email) )
Thu, 08 Jan 1998 09:14:15 -0800

Check your database field for the SessionID in the Calls Table, should be
at least 25 characters from what I've gotten so far! If the field is too
short, of course the data gets truncated, causing it to appear as duplicate
entries. Easy way to find out is disable the primary keys, let it run
accounting for an hour or so, then use a "Find Duplicate" query to see
what's going on.

At 10:36 AM 1/8/98 -0500, you wrote:
>
>We're working with a new USR HiPerARC access router here, and I've gotten it
>to authenticate, but for some reason I'm not getting any entries into
>callsonline. I'm including at the bottom of this two entries from the
>radius server (in terminal mode). Has anyone else seen other equipment work
>like this (has proper radius settings and is being put into calls, but not
>callsonline)?
>
>Thanks for any help!
>
>Brian Lube
>MPInet
>http://www.mpinet.net
>
>
>
>Resp Time: 10 Auth: 7/1 -> 8 Acct: 6/238/3 -> 247
>radrecv: Request from host d006c705 code=4, id=21, length=277
> User-Name = "rlee"
> NAS-Identifier = 208.6.199.5
> Acct-Status-Type = Stop
> Acct-Session-Id = "17000301"
> Acct-Delay-Time = 60
> Acct-Authentic = RADIUS
> User-Service = Framed-User
> NAS-Port = 52
> Vendor-Specific = ""
> Vendor-Specific = ""
> Vendor-Specific = ""
> Vendor-Specific = ""
> Caller-Id = "4078340213"
> NAS-Port-DNIS = "4751041"
> Vendor-Specific = ""
> Vendor-Specific = ""
> Vendor-Specific = ""
> Vendor-Specific = ""
> Framed-Protocol = PPP
> Framed-Address = 208.6.199.13
> Vendor-Specific = ""
>Received unknown attribute 51
>Received unknown attribute 50
> Acct-Session-Time = 51
> Acct-Terminate-Cause = User-Request
> Acct-Input-Octets = 1005
> Acct-Output-Octets = 372
> Acct-Input-Packets = 46
> Acct-Output-Packets = 15
>
> SQL Statement: INSERT INTO Calls
>(CallDate,UserName,NASIdentifier,AcctStatusTyp
>e,AcctSessionId,AcctDelayTime,UserService,NASPort,NASPortDNIS,FramedProtocol
>,Fra
>medAddress,AcctSessionTime,AcctTerminateCause,AcctInputOctets,AcctOutputOcte
>ts)
>VALUES
>(GetDate(),'rlee','208.6.199.5',2,'17000301',60,2,52,'4751041',1,'208.6.1
>99.13',51,1,1005,372)
>
>ODBC: SQLExecDirect Error 2627:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
>constra
>int 'pk_Calls': Attempt to insert duplicate key in object 'Calls'.
>Sending Accounting Ack of id 21 to d006c705 (hiper1.mpinet.net)
>
>Resp Time: 40 Auth: 7/1 -> 8 Acct: 6/238/4 -> 248
>radrecv: Request from host d006c705 code=4, id=23, length=242
> User-Name = "wfwitt"
> NAS-Identifier = 208.6.199.5
> Acct-Status-Type = Start
> Acct-Session-Id = "1000100"
> Acct-Delay-Time = 60
> Acct-Authentic = RADIUS
> User-Service = Framed-User
> NAS-Port = 5
> Vendor-Specific = ""
> Vendor-Specific = ""
> Vendor-Specific = ""
> Vendor-Specific = ""
> Caller-Id = "4073319606"
> NAS-Port-DNIS = "6601986"
> Vendor-Specific = ""
> Vendor-Specific = ""
> Vendor-Specific = ""
> Vendor-Specific = ""
> Framed-Protocol = PPP
> Framed-Address = 208.6.199.14
> Vendor-Specific = ""
>Received unknown attribute 51
>Received unknown attribute 50
>
> SQL Statement: INSERT INTO Calls
>(CallDate,UserName,NASIdentifier,AcctStatusTyp
>e,AcctSessionId,AcctDelayTime,UserService,NASPort,NASPortDNIS,FramedProtocol
>,Fra
>medAddress) VALUES
>(GetDate(),'wfwitt','208.6.199.5',1,'1000100',60,2,5,'6601986
>',1,'208.6.199.14')
>
>ODBC: SQLExecDirect Error 2627:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
>constra
>int 'pk_Calls': Attempt to insert duplicate key in object 'Calls'.
>Sending Accounting Ack of id 23 to d006c705 (hiper1.mpinet.net)
>
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>
>