Re: Problems with calls table

Dale E. Reed Jr. ( (no email) )
Tue, 23 Jun 1998 07:41:54 -0700

James B. Hrdy wrote:
> Problem: Calls table is inaccurate and causing the concurrency to not work correctly.
> RadiusNT thinks the user is still logged in.

Check the Accounting timeout on the Ascend. Sometimes its set to low and will
cause problems. It should be atleast 5.

> ODBC Error:23000:-1605:
> [Microsoft][ODBC Microsoft Access 97 Driver] The changes you requested to the table
> were not successful because they would create duplicate values in the index, primary key,
> or relationship. Change the data in the field or fields that contain duplicate data, remove
> the index, or redefine the index to permit duplicate entries and try again.
> Sending Accounting Ack of id 48 to d01a1663 (route-1)
> Resp Time: 1862 Auth: 1/0 -> 1 Acct: 1/0/1 -> 2

This just means we have already seen this request. Your response times
are rather high and will most likely cause problems in busy siutations.
(MS Access can vary quite a bit and can be prolematic).

> radrecv: Request from host d01a1663 code=4, id=49, length=89
> NAS-Identifier = NAS-Identifier
> NAS-Port = 20202
> NAS-Port-Type = Async
> Acct-Status-Type = Start
> Acct-Delay-Time = 0
> Acct-Session-Id = &quot266236812"
> Acct-Authentic = Local
> Caller-Id = &quotCaller-Id"
> NAS-Port-DNIS = &quotDNIS"
> SQL Statement: INSERT INTO Calls
> (CallDate,NASIdentifier,NASPort,NASPortType,AcctStatusType,AcctDelayTime,AcctSessi
> onId,CallerId, UserName) VALUES (Now(),'ipaddr',20202,0,1,0,'26623681','callerid','NULL')
> Incomplete accounting record. CallsOnline not updated
> Sending Accounting Ack of id 49 to d01a1663 (route-1)

There is not username in this accounting packet. Although RadiusNT could
enter a blank calls-online entry, its pretty useless.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |