Calls table not functioning, Calls online not functioning

James B. Hrdy ( (no email) )
Tue, 23 Jun 1998 16:32:20 +0000

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Mike Cowan: "unsubscribe"
Next message: James B. Hrdy: "RadiusNT Version 2.5x"
Next in thread: Dale Reed: "Re: Calls table not functioning, Calls online not functioning"

Here is the debug info from a different install of RadiusNT, but with a
similar problem. The calls online isnt working.

NAS here is a USRTotal Control rack

0) IgnoreCase: 0
1) TrimName: 0
0) IgnoreCase: 0
1) TrimName: 0
2) AuthPort: 1645
3) ReqAcctAuth: 0
4) AllowMalformed: 0
5) AcctPort: 1646
6) Mode: 1
7) Proxy: 0
8) Options: 3
9) Debug: 0
10) LogFile:
11) AcctLogFile:
12) ODBCDatasource: radius
13) Username:
14) Password:
15) AcctODBCDatasource:
16) AcctUsername:
17) AcctPassword:
18) DataDirectory:
19) AcctDirectory:
20) UsersFile: Users
21) CompanyName: XXXXXXXXXXXXXXXXXXXXX
22) License: XXXXXXXXXXXXXXXXXXXXXXXXXX
23) IPAddress: XXXXXXXXXXXXXXXXXX

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'radius'...
Making ODBC Connection...
MS Access Mode Enabled
ODBC Datasource: 'radius'...
Making ODBC Connection...
MS Access Mode Enabled
Licensed MBRs: 3000
Allocating Statement...

SQL Statement: Select Name, RadAttributeID, Type From RadAttributes

SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv, RadAttributes ra
Where rv.RadAttributeID = ra.RadAttributeID

118 Dictionary Attributes Loaded...

SQL Statement: Select Server, IPAddress, Secret From Servers

2 Clients Loaded
Accounting Column 0 (16): 'NASIdentifier'
Accounting Column 1 (4): 'NASPort'
Accounting Column 2 (8): 'AcctSessionId'
Accounting Column 3 (2): 'AcctStatusType'
Accounting Column 4 (16): 'CallDate'
Accounting Column 5 (12): 'UserName'
Accounting Column 6 (4): 'AcctDelayTime'
Accounting Column 7 (4): 'AcctSessionTime'
Accounting Column 8 (16): 'FramedAddress'
Accounting Column 9 (4): 'AcctInputOctets'
Accounting Column 10 (4): 'AcctOutputOctets'
Accounting Column 11 (2): 'NASPortType'
Accounting Column 12 (10): 'ClientPortDNIS'
Accounting Column 13 (16): 'CallerID'
Accounting Column 14 (32): 'ConnectInfo'
15 Accounting Columns Loaded

Enterprise features enabled.

RadiusNT (Emerald Standard) Initialized...

radrecv: Request from host 97c95a15 code=4, id=148, length=246
User-Name = "xxxxxxxx"
NAS-Identifier = 000.000.000.000
Acct-Status-Type = Start
Acct-Session-Id = "4b020e00"
Acct-Delay-Time = 0
Acct-Authentic = RADIUS
User-Service = Framed-User
NAS-Port = 28
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Caller-Id = "1.123.123.1234"
NAS-Port-DNIS = "7286981"
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Framed-Protocol = PPP
Framed-Address = xxxxxxxxxx
Vendor-Specific = ""
Received unknown attribute 51
Received unknown attribute 50

SQL Statement: INSERT INTO Calls
(CallDate,UserName,NASIdentifier,AcctStatusType,AcctSessionId,AcctDelayTime,NASPor
t,CallerId,FramedAddress) VALUES
(Now(),'xxxxxxxx','000.000.000.000',1,'4b020e00',0,28,'1.123.123.1234','xxxxxxxxxx')

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 148 to 97c95a15 (USRTc)

Resp Time: 20 Auth: 2/0 -> 2 Acct: 1/0/1 -> 2
radrecv: Request from host 97c95a15 code=4, id=149, length=282
User-Name = "xxxxxxxx"
NAS-Identifier = 000.000.000.000
Acct-Status-Type = Stop
Acct-Session-Id = "4b020e00"
Acct-Delay-Time = 0
Acct-Authentic = RADIUS
User-Service = Framed-User
NAS-Port = 28
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Caller-Id = "1.123.123.1234"
NAS-Port-DNIS = "7286981"
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Framed-Protocol = PPP
Framed-Address = xxxxxxxxxx
Vendor-Specific = ""
Received unknown attribute 51
Received unknown attribute 50
Acct-Session-Time = 16
Acct-Terminate-Cause = User-Request
Acct-Input-Octets = 776
Acct-Output-Octets = 1252
Acct-Input-Packets = 20
Acct-Output-Packets = 21

SQL Statement: INSERT INTO Calls
(CallDate,UserName,NASIdentifier,AcctStatusType,AcctSessionId,AcctDelayTime,NASPor
t,CallerId,FramedAddress,AcctSessionTime,AcctInputOctets,AcctOutputOctets) VALUES
(Now(),'xxxxxxxx','000.000.000.000',2,'4b020e00',0,28,'1.123.123.1234','xxxxxxxxxx',16,776
,1252)

SQL Statement: UPDATE CallsOnline Set Username='xxxxxxxx',AcctStatusType=2,
CallDate=Now, FramedAddress='xxxxxxxxxx' WHERE NASIdentifier='000.000.000.000'
and NASPort=28 AND (DateAdd('s', 0-2, Now) >= CallDate OR CallDate IS NULL)

Sending Accounting Ack of id 149 to 97c95a15 (USRTc)

Resp Time: 30 Auth: 2/0 -> 2 Acct: 2/0/1 -> 3
radrecv: Request from host 97c95a15 code=4, id=149, length=282
User-Name = "xxxxxxxx"
NAS-Identifier = 000.000.000.000
Acct-Status-Type = Stop
Acct-Session-Id = "4b020e00"
Acct-Delay-Time = 0
Acct-Authentic = RADIUS
User-Service = Framed-User
NAS-Port = 28
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Caller-Id = "1.123.123.1234"
NAS-Port-DNIS = "7286981"
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Framed-Protocol = PPP
Framed-Address = xxxxxxxxxx
Vendor-Specific = ""
Received unknown attribute 51
Received unknown attribute 50
Acct-Session-Time = 16
Acct-Terminate-Cause = User-Request
Acct-Input-Octets = 776
Acct-Output-Octets = 1252
Acct-Input-Packets = 20
Acct-Output-Packets = 21

Sending Accounting Ack of id 149 to 97c95a15 (USRTc)

Resp Time: 20 Auth: 2/0 -> 2 Acct: 2/0/2 -> 4
radrecv: Request from host 97c95a15 code=1, id=31, length=142
User-Name = "xxxxxxxx"
Challenge-Response = "\003\272\234\010\344\215K\250\014\340\320Z\253\326[.\327"
Framed-Protocol = PPP
NAS-Identifier = 000.000.000.000
NAS-Port = 28
User-Service = Framed-User
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
NAS-Port-DNIS = "7286981"
Caller-Id = "1.123.123.1234"
NAS-Port-Type = Async
rad_authenticate_ODBC()
Challenge-Response = "\003\272\234\010\344\215K\250\014\340\320Z\253\326[.\327"

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='xxxxxxxx' or sa.Shell='xxxxxxxx' or
sa.Email='xxxxxxxx') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and
ma.Active<>0

Checking for duplicate logins.

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

xxxxxxxx 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=3448

Loading radius defaults for this type...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type, rc.RadVendorID,
rc.RadVendorType, rc.RadCheck From RadATConfigs rc, RadAttributes ra Where
ra.RadAttributeID=rc.RadAttributeID AND rc.AccountType='PPP'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Session-Timeout = 7200 (7200)
Sending Ack of id 31 to 97c95a15 (USRTc)
Framed-Protocol = PPP
User-Service = Framed-User
Session-Timeout = 7200

Resp Time: 100 Auth: 3/0 -> 3 Acct: 2/0/2 -> 4
radrecv: Request from host 97c95a15 code=4, id=150, length=246
User-Name = "xxxxxxxx"
NAS-Identifier = 000.000.000.000
Acct-Status-Type = Start
Acct-Session-Id = "4c020e00"
Acct-Delay-Time = 0
Acct-Authentic = RADIUS
User-Service = Framed-User
NAS-Port = 28
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Caller-Id = "1.123.123.1234"
NAS-Port-DNIS = "7286981"
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Framed-Protocol = PPP
Framed-Address =
Vendor-Specific = ""
Received unknown attribute 51
Received unknown attribute 50

Sending Accounting Ack of id 150 to 97c95a15 (USRTc)

Resp Time: 20 Auth: 4/0 -> 4 Acct: 3/0/3 -> 6
radrecv: Request from host 97c95a15 code=4, id=151, length=282
User-Name = "xxxxxxxx"
NAS-Identifier = 000.000.000.000
Acct-Status-Type = Stop
Acct-Session-Id = "4c020e00"
Acct-Delay-Time = 0
Acct-Authentic = RADIUS
User-Service = Framed-User
NAS-Port = 28
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Caller-Id = "1.123.123.1234"
NAS-Port-DNIS = "7286981"
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Framed-Protocol = PPP
Framed-Address =
Vendor-Specific = ""
Received unknown attribute 51
Received unknown attribute 50
Acct-Session-Time = 13
Acct-Terminate-Cause = User-Request
Acct-Input-Octets = 387
Acct-Output-Octets = 362
Acct-Input-Packets = 15
Acct-Output-Packets = 13

SQL Statement: UPDATE CallsOnline Set Username='xxxxxxxx',AcctStatusType=2,
CallDate=Now, FramedAddress='' WHERE NASIdentifier='000.000.000.000' and
NASPort=28 AND (DateAdd('s', 0-2, Now) >= CallDate OR CallDate IS NULL)

Sending Accounting Ack of id 151 to 97c95a15 (USRTc)

Resp Time: 30 Auth: 4/0 -> 4 Acct: 4/0/3 -> 7
radrecv: Request from host 97c95a15 code=4, id=151, length=282
User-Name = "xxxxxxxx"
NAS-Identifier = 000.000.000.000
Acct-Status-Type = Stop
Acct-Session-Id = "4c020e00"
Acct-Delay-Time = 0
Acct-Authentic = RADIUS
User-Service = Framed-User
NAS-Port = 28
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Caller-Id = "1.123.123.1234"
NAS-Port-DNIS = "7286981"
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Framed-Protocol = PPP
Framed-Address =
Vendor-Specific = ""
Received unknown attribute 51
Received unknown attribute 50
Acct-Session-Time = 13
Acct-Terminate-Cause = User-Request
Acct-Input-Octets = 387
Acct-Output-Octets = 362
Acct-Input-Packets = 15
Acct-Output-Packets = 13

ODBC Error:23000:-1605:

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

Previous message: Mike Cowan: "unsubscribe"
Next message: James B. Hrdy: "RadiusNT Version 2.5x"
Next in thread: Dale Reed: "Re: Calls table not functioning, Calls online not functioning"