------=_NextPart_000_0010_01BEDCDE.0CD09800
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
I am asking for ANYONE'S support out there. I have emailed RadiusNT support
twice last week, made a phone call with credit card in hand & ready to pay
and was told I need to pay $995 or $1495 for which ever support option I
chose. The excuse was "Well, we have over a 1000 customers..." Guess what?
So do I!!! Enough compliaining...Here is the problem (debug text
attached)
-----------------------------------------------
RadiusNT 2.5.175
No Emerald (sorry)
NT4.0 - Service Pack 5.0
SQL 6.5 DB
SQL 32 bit ODBC driver 3.60.03.19 - 6/3/98
Boardtown's Platypus ver 2.9 Build 505
I've attached the debug text. Here's the problem. I had RadiusNT turned
off and these admin packets/Telenet sessions are coming in like crazy. It
also happens when it is authenticating. Our network admin turned off all
the "listening", "logging", etc. that he is aware of and it still happens.
The initial problem was that Radius stops writing to the Calls table ever
12 - 24 hours and the Calls online view does not work at all. However
Boardtown wanted me to get the admin packets stopped first. I have no idea
where they are coming from as the Host addresses are from all over the
place on our Livingston PM3's. Any clues, pointers, etc. would be greatly
appreciated.
Lorri A. Manning
Cowtown Net
Fort Worth, TX
(817)293-9353
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
To the world you may be just one person,
but to one person you may be the world
Stay above this line - These instructions will not show in the message you
send.
------=_NextPart_000_0010_01BEDCDE.0CD09800
Content-Type: text/plain;
name="Debug.txt"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="Debug.txt"
C:\>cd radius
C:\radius>radius -x15
RadiusNT 2.5.175 Copyright (c) 1995-1998 IEA Software, Inc.
All Rights Reserved, Worldwide
Some portions Copyright (c) 1992 Livingston Enterprises, Inc.
and Copyright (c) 1995 Ascend Communications, Inc.
0) Mode: 1
1) IgnoreCase: 3
2) TrimName: 1
3) AuthPort: 1645
4) ReqAcctAuth: 0
5) AllowMalformed: 0
6) AcctPort: 1646
7) Proxy: 0
8) Options: 64
9) SNMP: 0
10) Debug: 7
11) LogFile:
12) AcctLogFile:
13) ODBCDatasource: PLATYPUS2
14) Username: ***********
15) Password: ********
16) AcctODBCDatasource:
17) AcctUsername:
18) AcctPassword:
19) TestDatabaseSecs:
20) DataDirectory: c:\radius
21) AcctDirectory: c:\radius
22) UsersFile: Users
23) CompanyName: Cowtown Net
24) License: It's valid - I just wiped it out for this
25) IPAddress: All
Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'PLATYPUS2'...
Making ODBC Connection...
MS SQL Server Mode Enabled
SQL Statement: Select DISTINCT Company, LicenseID From Licenses
SQL Statement: Select DISTINCT Company, LiscenseID From Liscenses
ODBC Datasource: 'PLATYPUS2'...
Making ODBC Connection...
MS SQL Server Mode Enabled
SQL Statement: Select DISTINCT Company, LicenseID From Licenses
SQL Statement: Select DISTINCT Company, LiscenseID From Liscenses
Allocating Statement...
SQL Statement: Select Name, RadAttributeID, Type, RadVendorID, =
RadVendorType Fr
om RadAttributes Order By RadVendorID, RadAttributeID
SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv, =
RadAttribut
es ra Where rv.RadAttributeID =3D ra.RadAttributeID
237 Dictionary Attributes Loaded...
SQL Statement: Select Server, IPAddress, Secret From Servers
7 Clients Loaded
Accounting Column 0 (16): 'NASIdentifier'
Accounting Column 1 (4): 'NASPort'
Accounting Column 2 (10): 'AcctSessionID'
Accounting Column 3 (1): 'AcctStatusType'
Accounting Column 4 (16): 'CallDate'
Accounting Column 5 (45): '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'
Accounting Column 16 (30): 'ConnectInfo'
17 Accounting Columns Loaded
RadiusNT 2.5.175 Standard Initialized...
radrecv: Request from host d190067b code=3D4, id=3D205, length=3D85
Acct-Session-Id =3D "3F0063DC"
User-Name =3D "admin"
NAS-Identifier =3D 209.144.6.123
Acct-Status-Type =3D Stop
Acct-Session-Time =3D 852
Acct-Authentic =3D Local
User-Service =3D Administrative
Login-Service =3D Telnet
Login-Host =3D 209.144.6.223
Acct-Delay-Time =3D 53624
SQL Statement: INSERT INTO Calls =
(CallDate,AcctSessionId,UserName,NASIdentifier
,AcctStatusType,AcctSessionTime,UserService,AcctDelayTime) VALUES =
(GetDate(),'3F
0063DC','admin','209.144.6.123',2,852,6,53624)
ODBC Error:23000:233:
[Microsoft][ODBC SQL Server Driver][SQL Server]The column NASPort in =
table Call
s may not be null.
Resp Time: 1272 Auth: 0/0 -> 0 Acct: 0/1/0 -> 1
radrecv: Request from host d190067b code=3D4, id=3D151, length=3D79
Acct-Session-Id =3D "3F0063DC"
User-Name =3D "admin"
NAS-Identifier =3D 209.144.6.123
Acct-Status-Type =3D Start
Acct-Authentic =3D Local
User-Service =3D Administrative
Login-Service =3D Telnet
Login-Host =3D 209.144.6.223
Acct-Delay-Time =3D 54476
SQL Statement: INSERT INTO Calls =
(CallDate,AcctSessionId,UserName,NASIdentifier
,AcctStatusType,UserService,AcctDelayTime) VALUES =
(GetDate(),'3F0063DC','admin',
'209.144.6.123',1,6,54476)
ODBC Error:23000:233:
[Microsoft][ODBC SQL Server Driver][SQL Server]The column NASPort in =
table Call
s may not be null.
Resp Time: 1181 Auth: 0/0 -> 0 Acct: 0/2/0 -> 2
radrecv: Request from host d190067b code=3D4, id=3D95, length=3D85
Acct-Session-Id =3D "3F0051AB"
User-Name =3D "admin"
NAS-Identifier =3D 209.144.6.123
Acct-Status-Type =3D Stop
Acct-Session-Time =3D 1283
Acct-Authentic =3D Local
User-Service =3D Administrative
Login-Service =3D Telnet
Login-Host =3D 209.144.6.114
Acct-Delay-Time =3D 437691
SQL Statement: INSERT INTO Calls =
(CallDate,AcctSessionId,UserName,NASIdentifier
,AcctStatusType,AcctSessionTime,UserService,AcctDelayTime) VALUES =
(GetDate(),'3F
0051AB','admin','209.144.6.123',2,1283,6,437691)
ODBC Error:23000:233:
[Microsoft][ODBC SQL Server Driver][SQL Server]The column NASPort in =
table Call
s may not be null.
Resp Time: 1241 Auth: 0/0 -> 0 Acct: 0/3/0 -> 3
radrecv: Request from host d190067b code=3D4, id=3D43, length=3D79
Acct-Session-Id =3D "3F0051AB"
User-Name =3D "admin"
NAS-Identifier =3D 209.144.6.123
Acct-Status-Type =3D Start
Acct-Authentic =3D Local
User-Service =3D Administrative
Login-Service =3D Telnet
Login-Host =3D 209.144.6.114
Acct-Delay-Time =3D 438974
SQL Statement: INSERT INTO Calls =
(CallDate,AcctSessionId,UserName,NASIdentifier
,AcctStatusType,UserService,AcctDelayTime) VALUES =
(GetDate(),'3F0051AB','admin',
'209.144.6.123',1,6,438974)
ODBC Error:23000:233:
[Microsoft][ODBC SQL Server Driver][SQL Server]The column NASPort in =
table Call
s may not be null.
Resp Time: 1212 Auth: 0/0 -> 0 Acct: 0/4/0 -> 4
radrecv: Request from host d190067b code=3D4, id=3D110, length=3D85
Acct-Session-Id =3D "3F005040"
User-Name =3D "admin"
NAS-Identifier =3D 209.144.6.123
Acct-Status-Type =3D Stop
Acct-Session-Time =3D 259
Acct-Authentic =3D Local
User-Service =3D Administrative
Login-Service =3D Telnet
Login-Host =3D 209.144.6.25
Acct-Delay-Time =3D 481612
SQL Statement: INSERT INTO Calls =
(CallDate,AcctSessionId,UserName,NASIdentifier
,AcctStatusType,AcctSessionTime,UserService,AcctDelayTime) VALUES =
(GetDate(),'3F
005040','admin','209.144.6.123',2,259,6,481612)
ODBC Error:23000:233:
[Microsoft][ODBC SQL Server Driver][SQL Server]The column NASPort in =
table Call
s may not be null.
Resp Time: 1242 Auth: 0/0 -> 0 Acct: 0/5/0 -> 5
radrecv: Request from host d190067b code=3D4, id=3D91, length=3D79
Acct-Session-Id =3D "3F005040"
User-Name =3D "admin"
NAS-Identifier =3D 209.144.6.123
Acct-Status-Type =3D Start
Acct-Authentic =3D Local
User-Service =3D Administrative
Login-Service =3D Telnet
Login-Host =3D 209.144.6.25
Acct-Delay-Time =3D 481870
SQL Statement: INSERT INTO Calls =
(CallDate,AcctSessionId,UserName,NASIdentifier
,AcctStatusType,UserService,AcctDelayTime) VALUES =
(GetDate(),'3F005040','admin',
'209.144.6.123',1,6,481870)
ODBC Error:23000:233:
[Microsoft][ODBC SQL Server Driver][SQL Server]The column NASPort in =
table Call
s may not be null.
Resp Time: 1182 Auth: 0/0 -> 0 Acct: 0/6/0 -> 6
radrecv: Request from host d190067b code=3D4, id=3D96, length=3D85
Acct-Session-Id =3D "3F004FAE"
User-Name =3D "admin"
NAS-Identifier =3D 209.144.6.123
Acct-Status-Type =3D Stop
Acct-Session-Time =3D 821
Acct-Authentic =3D Local
User-Service =3D Administrative
Login-Service =3D Telnet
Login-Host =3D 209.176.34.41
Acct-Delay-Time =3D 489382
SQL Statement: INSERT INTO Calls =
(CallDate,AcctSessionId,UserName,NASIdentifier
,AcctStatusType,AcctSessionTime,UserService,AcctDelayTime) VALUES =
(GetDate(),'3F
004FAE','admin','209.144.6.123',2,821,6,489382)
ODBC Error:23000:233:
[Microsoft][ODBC SQL Server Driver][SQL Server]The column NASPort in =
table Call
s may not be null.
Resp Time: 1242 Auth: 0/0 -> 0 Acct: 0/7/0 -> 7
radrecv: Request from host d190067b code=3D4, id=3D31, length=3D79
Acct-Session-Id =3D "3F004FAE"
User-Name =3D "admin"
NAS-Identifier =3D 209.144.6.123
Acct-Status-Type =3D Start
Acct-Authentic =3D Local
User-Service =3D Administrative
Login-Service =3D Telnet
Login-Host =3D 209.176.34.41
Acct-Delay-Time =3D 490203
SQL Statement: INSERT INTO Calls =
(CallDate,AcctSessionId,UserName,NASIdentifier
,AcctStatusType,UserService,AcctDelayTime) VALUES =
(GetDate(),'3F004FAE','admin',
'209.144.6.123',1,6,490203)
ODBC Error:23000:233:
[Microsoft][ODBC SQL Server Driver][SQL Server]The column NASPort in =
table Call
s may not be null.
Resp Time: 1201 Auth: 0/0 -> 0 Acct: 0/8/0 -> 8
------=_NextPart_000_0010_01BEDCDE.0CD09800--