Problems with calls table

James B. Hrdy ( (no email) )
Tue, 23 Jun 1998 09:07:58 +0000

Hi, I am re-submitting this problem with an additional question. Could this be from a
accountid problem. Anyone on the list know what an ascend needs in radat info area ?

Running RadiusNT with the latest update.
Ascend 4048 with latest software update.
Ascend Database
Allowmalformed packets checked
Concurrency and manual calls update checked

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

Any hints from anyone ?

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Session-Timeout = 7200 (7200)
Sending Ack of id 157 to d01a1663 (route-1)
Framed-Protocol = PPP
User-Service = Framed-User
Session-Timeout = 7200

Resp Time: 4066 Auth: 1/0 -> 1 Acct: 1/0/0 -> 1
radrecv: Request from host d01a1663 code=4, id=48, length=112
User-Name = &quotUser-Name"
NAS-Identifier = 10.0.0.1
NAS-Port = 20201
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = &quot266236811"
Acct-Authentic = RADIUS
Caller-Id = &quotxxxxx"
NAS-Port-DNIS = &quotxxxx"
Framed-Protocol = PPP
Framed-Address = xxxxx

SQL Statement: INSERT INTO Calls
(CallDate,UserName,NASIdentifier,NASPort,NASPortType,AcctStatusType,AcctDelayTime,
AcctSessionId,CallerId,FramedAddress) VALUES
(Now(),'hannibal','correctip',20201,0,1,0,'26623681','correctid','correctaddress')

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
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)

Resp Time: 3084 Auth: 1/0 -> 1 Acct: 2/0/1 -> 3
radrecv: Request from host d01a1663 code=4, id=50, length=185
NAS-Identifier = NAS-Identifier
NAS-Port = 20202
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = &quot266236812"
Acct-Authentic = Local
Acct-Session-Time = 28
Acct-Input-Octets = 435
Acct-Output-Octets = 474
Acct-Input-Packets = 0
Acct-Output-Packets = 0
Ascend-Disconnect-Cause = 11
Ascend-Connect-Progress = 40
Ascend-Xmit-Rate = 33600
Ascend-Data-Rate = 26400
Ascend-PreSession-Time = 20
Ascend-Pre-Input-Octets = 0
Ascend-Pre-Output-Octets = 0
Ascend-Pre-Input-Packets = 0
Ascend-Pre-Output-Packets = 0
Ascend-Modem-PortNo = 15
Ascend-Modem-SlotNo = 4
Caller-Id = &quotCaller-Id"
NAS-Port-DNIS = &quot3221896"

SQL Statement: INSERT INTO Calls
(CallDate,NASIdentifier,NASPort,NASPortType,AcctStatusType,AcctDelayTime,AcctSessi
onId,AcctSessionTime,AcctInputOctets,AcctOutputOctets,CallerId, UserName) VALUES
(Now(),'ipaddr',20202,0,2,0,'26623681',28,435,474,'callerid','NULL')

Incomplete accounting record. CallsOnline not updated
Sending Accounting Ack of id 50 to d01a1663 (route-1)

Resp Time: 591 Auth: 1/0 -> 1 Acct: 3/0/1 -> 4
radrecv: Request from host d01a1663 code=1, id=158, length=104
User-Name = &quotgregchris"
Password = &quotpassword"
NAS-Identifier = NAS-Identifier
NAS-Port = 20202
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
State = ""
Caller-Id = &quotCallerId"
NAS-Port-DNIS = &quot3221896"
Acct-Session-Id = &quot266236813"
rad_authenticate_ODBC()
Password = &quotpassword"

SQL Statement: Select DateDiff('n', Now, DateAdd('d', ma.Extension+1, maExpireDate)),
DateDiff('n', Now, DateAdd('d', ma.Extension+1, maExpireDate)), sa.AccountID,
sa.AccountType, sa.Password, sa.Login, sa.Shell From MasterAccounts ma,
SubAccounts sa Where (sa.Login='gregchris' or sa.Shell='gregchris') AND
ma.CustomerID=sa.CustomerID and sa.Active<&gt0 and ma.Active<&gt0

Decrypted Password: correct
Database Password: correct
Checking for duplicate logins.

SQL Statement: Select Count(Username) From ServerPorts Where Username='gregchris'
and AcctStatusType=1

gregchris found on-line 0 time(s).

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type, rc.RadVendorID,
rc.RadVendorType, rc.RadCheck From RadConfigs rc, RadAttributes ra Where
ra.RadAttributeID=rc.RadAttributeID AND rc.AccountID=71

James B. Hrdy
email: jhrdy@greensoft.com
web: http://www.greensoft.com/billing
GreenSoft Solutions, Inc.
Voice: 785.843.8683 ext 203
2317 Ponderosa Drive
Fax: 785.840.0055
Lawrence, Ks.
United States of America