[RadiusNT] Vendor attributes and calls online

Tim Pitman ( (no email) )
Wed, 20 Oct 1999 17:45:03 -0500

I have two problems one is that two of my nas update the callsonline data
just fine, but the third doesn't. The first two are USR Netserver 8/Is
while the third is a Total Control Chassis. Shown below is the data taken
from the server and serverports table. I am unsure as to why the Total
Choice data makes it to the calls table, but not to the serverports table.
The one that is not working is ServerID of 7 in Servers table

Second problem in the radius debug file below I am getting Unknown
attributes, how do I fix this problem?

Thanks,
Tim

ServerID Server IPAddress Location Ports
Modems PhoneNumber ContactName ContactPhone ContactPage
Comments
DynamicStart DynamicEnd Secret
----------- ------------------------- ---------------- --------------- -----
------ ----------- ------------ ------------------------- ------------ -----
------- --------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------- ---------------- ---------------- ------
----------
1 caribbean.tdpnet.com 216.178.205.136 Home 10
8 314-218-1342 Tim Pitman 314-940-8458 888-928-7316
USR Netserver8/I
209.74.129.11 209.74.129.18 netserver
2 dialup.tdpnet.com 216.178.205.130 Home 0
0 314-218-1342
netserver
4 yucatan.tdpnet.com 216.178.205.137 Home 10
8 314-218-1342 Tim Pitman 314-940-8458 888-928-7316
USR Netserver8/I plus
209.74.129.21 209.74.129.29 netserver
7 harc1.tdpnet.com 216.178.205.139 Home 3840
3840 636-328-0008 Tim Pitman 314-550-3697 888-928-7316
USR Total Choice
216.178.205.140 216.178.205.189 netserver

(4 row(s) affected)

ServerID Port IPAddress MaxSessionTime CostPerMinute
UserName AcctStatusType CallDate
FramedAddress
----------- ----------- --------------- -------------- ------------- -------
------------------------- -------------- --------------------------- -------
---------
1 3 (null) 0 0 stackkj
2 Oct 20 1999 4:29PM 216.178.205.170
1 4 (null) 0 0 michael
2 Oct 20 1999 12:49PM 216.178.205.171
1 5 (null) 0 0
stoeppler 2 Oct 19 1999 10:42PM
216.178.205.172
1 6 (null) 0 0 condra
2 Oct 20 1999 1:02AM 216.178.205.173
1 7 (null) 0 0 jrsmas
2 Oct 19 1999 10:55PM 216.178.205.174
1 8 (null) 0 0 herman
2 Oct 18 1999 9:12PM 216.178.205.175
1 9 (null) 0 0 jzilch
2 Oct 18 1999 9:49PM 216.178.205.172
1 10 (null) 0 0 jbwils
2 Oct 15 1999 7:22PM 216.178.205.177
4 3 (null) 0 0 mac
2 Oct 18 1999 11:54PM 216.178.205.180
4 4 (null) 0 0
dmkleusch 2 Oct 17 1999 11:13PM
216.178.205.180
4 5 (null) 0 0
dmkleusch 2 Oct 12 1999 10:10PM
216.178.205.180
4 6 (null) 0 0
reichare 2 Oct 12 1999 9:35PM
216.178.205.183
4 7 (null) 0 0 ellebt
2 Oct 16 1999 8:29PM 216.178.205.180
4 8 (null) 0 0 michael
2 Oct 6 1999 10:22PM 216.178.205.185
4 9 (null) 0 0 dgl0001
2 Jun 9 1999 10:52PM 209.74.129.23
4 10 (null) 0 0
dmkleusch 2 Feb 16 1999 9:29PM
209.74.129.28
7 257 (null) 0 0 (null)
(null) (null) (null)
7 258 (null) 0 0 (null)
(null) (null) (null)
7 259 (null) 0 0 (null)
(null) (null) (null)
7 260 (null) 0 0 (null)
(null) (null) (null)
7 513 (null) 0 0 (null)
(null) (null) (null)
7 514 (null) 0 0 (null)
(null) (null) (null)
7 515 (null) 0 0 (null)
(null) (null) (null)
7 516 (null) 0 0 (null)
(null) (null) (null)
7 768 (null) 0 0 (null)
(null) (null) (null)
7 769 (null) 0 0 (null)
(null) (null) (null)
7 770 (null) 0 0 (null)
(null) (null) (null)
7 771 (null) 0 0 (null)
(null) (null) (null)
7 1025 (null) 0 0 (null)
(null) (null) (null)
7 1026 (null) 0 0 (null)
(null) (null) (null)
7 1027 (null) 0 0 (null)
(null) (null) (null)
7 1028 (null) 0 0 (null)
(null) (null) (null)
7 1281 (null) 0 0 (null)
(null) (null) (null)
7 1282 (null) 0 0 (null)
(null) (null) (null)
7 1283 (null) 0 0 (null)
(null) (null) (null)
7 1284 (null) 0 0 (null)
(null) (null) (null)
7 1537 (null) 0 0 (null)
(null) (null) (null)
7 1538 (null) 0 0 (null)
(null) (null) (null)
7 1539 (null) 0 0 (null)
(null) (null) (null)
7 1540 (null) 0 0 (null)
(null) (null) (null)
7 1793 (null) 0 0 (null)
(null) (null) (null)
7 1794 (null) 0 0 (null)
(null) (null) (null)
7 1795 (null) 0 0 (null)
(null) (null) (null)
7 1796 (null) 0 0 (null)
(null) (null) (null)
7 2049 (null) 0 0 (null)
(null) (null) (null)
7 2050 (null) 0 0 (null)
(null) (null) (null)
7 2051 (null) 0 0 (null)
(null) (null) (null)
7 2052 (null) 0 0 (null)
(null) (null) (null)
7 2305 (null) 0 0 (null)
(null) (null) (null)
7 2306 (null) 0 0 (null)
(null) (null) (null)
7 2307 (null) 0 0 (null)
(null) (null) (null)
7 2308 (null) 0 0 (null)
(null) (null) (null)
7 2561 (null) 0 0 (null)
(null) (null) (null)
7 2562 (null) 0 0 (null)
(null) (null) (null)
7 2563 (null) 0 0 (null)
(null) (null) (null)
7 2564 (null) 0 0 (null)
(null) (null) (null)
7 2817 (null) 0 0 (null)
(null) (null) (null)
7 2818 (null) 0 0 (null)
(null) (null) (null)
7 2819 (null) 0 0 (null)
(null) (null) (null)
7 2820 (null) 0 0 (null)
(null) (null) (null)
7 3073 (null) 0 0 (null)
(null) (null) (null)
7 3074 (null) 0 0 (null)
(null) (null) (null)
7 3075 (null) 0 0 (null)
(null) (null) (null)
7 3076 (null) 0 0 (null)
(null) (null) (null)

(64 row(s) affected)

RADIUS -X15 debug:

119 Dictionary Attributes Loaded...

SQL Statement: Select Server, IPAddress, Secret From Servers

4 Clients Loaded
Accounting Column 0 (16): 'NASIdentifier'
Accounting Column 1 (4): 'NASPort'
Accounting Column 2 (25): 'AcctSessionID'
Accounting Column 3 (1): 'AcctStatusType'
Accounting Column 4 (16): 'CallDate'
Accounting Column 5 (32): 'UserName'
Accounting Column 6 (1): 'UserService'
Accounting Column 7 (4): 'AcctDelayTime'
Accounting Column 8 (4): 'AcctSessionTime'
Accounting Column 9 (4): 'FramedProtocol'
Accounting Column 10 (16): 'FramedAddress'
Accounting Column 11 (4): 'AcctInputOctets'
Accounting Column 12 (4): 'AcctOutputOctets'
Accounting Column 13 (1): 'AcctTerminateCause'
Accounting Column 14 (1): 'NASPortType'
Accounting Column 15 (10): 'NASPortDNIS'
16 Accounting Columns Loaded

RadiusNT 2.5.175 Standard Initialized...

radrecv: Request from host d8b2cd8b code=1, id=167, length=186

User-Name = "timdp"
Password = "\342F\271iG\265\342\016TM\355s\235\336\350\304"
NAS-Identifier = 216.178.205.139
NAS-Port = 1284
Acct-Session-Id = "1168"
Received unknown attribute 38979, vendor 429
Received unknown attribute 39049, vendor 429
User-Service = Framed-User
Framed-Protocol = PPP
Received unknown attribute 36889, vendor 429
Received unknown attribute 36890, vendor 429
Received unknown attribute 36891, vendor 429
Received unknown attribute 36899, vendor 429
Caller-Id = "6369408458"
NAS-Port-DNIS = "3280008"
NAS-Port-Type = Async
rad_authenticate_ODBC()

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 From MasterAccounts ma,
SubAccounts sa Where sa.Login='timdp' AND ma.CustomerID=sa.CustomerID and
sa.Active<>0 and ma.Active<>0

Checking for duplicate logins.

SQL Statement: RadCheckOnline 'timdp'

timdp found on-line 0 time(s).

SQL Statement: RadGetConfigs 1

SQL Statement: RadGetATConfigs '56k X2'

Sending Ack of id 167 to d8b2cd8b (harc1.tdpnet.com)

User-Service = Framed-User
Framed-Protocol = PPP
Session-Timeout = 28800
Idle-Timeout = 1200
Framed-Address = 255.255.255.254
Framed-Netmask = 255.255.255.255
Framed-Routing = None
Resp Time: 30 Auth: 1/0 -> 1 Acct: 0/0/0 -> 0

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart