[RadiusNT Digest]

radiusnt-digest-request@iea-software.com
Thu, 27 Aug 1998 00:01:38 -0700

Message 1: ODBC Error...?
from postman@cp-tel.net (Postman Account)

Message 2: Concurrency control
from postman@cp-tel.net (Postman Account)

Message 3: RadiuNT/SQL slow response
from "Kurt Lange" <klange@usinternet.com>

Message 4: Unix passwd file
from "Frank Nowling" <frankn@netropolis.net>

Message 5:
from "Phillip White" <pw@dentech.net>

Message 6: Re: RadiuNT/SQL slow response
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 7: Re: Concurrency control
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 8: Re: User Restrictions
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 9: Mail list Users: If possible please make your To: field the full E-Mail Address name
from "Rudy Komsic" <rudyk@cyberglobe.net>

Message 10: Re: Radius / SQL question for Calls Table
from "Josh Hillman" <admin-maillist@talstar.com>

Message 11: RE: User Restrictions
from "Robert F. O'Connor" <sysadmin@metro.net>

Message 12: RE: User Restrictions
from Tim Ballingall <tim@mazda.com.au>

Message 13: Radius Stopping
from "Humberto Guzman" <hguzman@sysop.com.mx>

Message 14: Time of day limits
from "Andy Dubinsky" <andy@netfast.net>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: ODBC Error...?
From: postman@cp-tel.net (Postman Account)
Date: Wed, 26 Aug 1998 10:06:18 -0500

What is causing this error? We just enabled concurrency control.

ODBC Error:S0002:208:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'CallsOnline'.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Concurrency control
From: postman@cp-tel.net (Postman Account)
Date: Wed, 26 Aug 1998 10:47:01 -0500

We're running MS SQL 6.5 with RadiusNT.

Our concurrency control isn't working.... our ServerPorts table is not
being updated... I've selected Manual Calls update... and restarted
RadiusNT.

Our ServerPorts table has the ServerID, Port#, and IP address
filled out... but, the table isn't being populated with caller
information.... any ideas?

Also, we are seeing the following error now...

ODBC Error:S0002:208:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'CallsOnline'.

any suggestions? Please respond... thanks in advance..

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RadiuNT/SQL slow response
From: "Kurt Lange" <klange@usinternet.com>
Date: Wed, 26 Aug 1998 10:51:14 -0500

I'm having a problem getting RadiusNT to authenticate more than 7 USR TC
Netserver Chassis (14 t1's). It seems to Authenticate 14 T-1's OK but when
I add a few more all authentication stops. Anyone running this on 30+ t1's?
My response time between Radius and SQL doesn't seem impressive but it's
consistent across multiple SQL/PC tests.

Checking Radius user test:
Sent: 2 Good: 1 Bad: 0 T/O:0 Out: 1 Avg: 1234
Sent: 3 Good: 2 Bad: 0 T/O:0 Out: 1 Avg: 1320
Sent: 4 Good: 3 Bad: 0 T/O:0 Out: 1 Avg: 1447
Sent: 5 Good: 4 Bad: 0 T/O:0 Out: 1 Avg: 1566
Sent: 7 Good: 5 Bad: 0 T/O:0 Out: 2 Avg: 1671
Sent: 8 Good: 6 Bad: 0 T/O:0 Out: 2 Avg: 1778
Sent: 9 Good: 7 Bad: 0 T/O:0 Out: 2 Avg: 1870
Sent: 10 Good: 8 Bad: 0 T/O:0 Out: 2 Avg: 1956
Sent: 11 Good: 9 Bad: 0 T/O:0 Out: 2 Avg: 2027
Sent: 12 Good: 11 Bad: 0 T/O:0 Out: 1 Avg: 2119
Sent: 13 Good: 12 Bad: 0 T/O:0 Out: 1 Avg: 2140
Sent: 14 Good: 13 Bad: 0 T/O:0 Out: 1 Avg: 2142
Sent: 15 Good: 14 Bad: 0 T/O:0 Out: 1 Avg: 2127
Sent: 16 Good: 16 Bad: 0 T/O:0 Out: 0 Avg: 2052
Sent: 17 Good: 17 Bad: 0 T/O:0 Out: 0 Avg: 2001
Sent: 18 Good: 18 Bad: 0 T/O:0 Out: 0 Avg: 1959
Sent: 19 Good: 19 Bad: 0 T/O:0 Out: 0 Avg: 1916

At the Radius -x15 debug screen the response time for each of those requests
was between 1100-1299, the times do not correspond.

When I add on the 8th/9th/etc.. chassis and run radlogin it just times out
on every request. When I switch all the chassis off Radius NT it will
continue displaying debug/auth. information for awhile 10-20 seconds. It
seems like it's getting behind and it's processing the requests but by the
time it processes the request the NAS has given up and sent a new request
and it ignore's the last ACK???

I have run this on multiple different PCs, SQL Servers and run radlogin
directly from the Radius/SQL server and the response times always seem to be
between 1000-2000. Lasts results ran against a Double Pentium II/300, 512MB
Ram, RadiusNT, SQL and Radlogin all running on same PC I think that should
eliminate network performance. Also, run as service and without accounting
(currently still running without accounting).

SQL Performance Monitor Stats:

Cache Hit Response 97 97 97 97
IO Tran/sec .67 1.78 .66 18.6
IO Page read/sec .0 .3 .0 11.65
IO SP w/s .0 .14 .0 3.3
user 20 20 20 20

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Unix passwd file
From: "Frank Nowling" <frankn@netropolis.net>
Date: Wed, 26 Aug 1998 11:32:07 -0500

Does anyone have the unix password replacement function working correctly?
Did you do anything different/in addition to the instructions in the radius
2.5 manual? We are running radiusnt v2.5.124/MSSQL6.5, and haven't had any
success.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 5 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject:
From: "Phillip White" <pw@dentech.net>
Date: Wed, 26 Aug 1998 13:21:07 -0500

This is a multi-part message in MIME format.

------=_NextPart_000_0004_01BDD0F4.625CF9E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

unsubscribe

------=_NextPart_000_0004_01BDD0F4.625CF9E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

unsubscribe
------=_NextPart_000_0004_01BDD0F4.625CF9E0--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: RadiuNT/SQL slow responseFrom: "Dale E. Reed Jr." Date: Wed, 26 Aug 1998 14:27:15 -0700Kurt Lange wrote:> > I'm having a problem getting RadiusNT to authenticate more than 7 USR TC> Netserver Chassis (14 t1's). It seems to Authenticate 14 T-1's OK but when> I add a few more all authentication stops. Anyone running this on 30+ t1's?> My response time between Radius and SQL doesn't seem impressive but it's> consistent across multiple SQL/PC tests.> > Checking Radius user test:....> At the Radius -x15 debug screen the response time for each of those requests> was between 1100-1299, the times do not correspond.Run RadiusNT with debug all turned off as a service. Does the responsetimes change? You will ALWAYS see a significant performance hit byrunning in -x15 debug mode. If you don't have a specific reason, don'trun it in that mode.RadiusNT reports its repsonse time of handling the request. Radlogin reports the roundtrip response time including the network latency. They will not be the same. > When I add on the 8th/9th/etc.. chassis and run radlogin it just times out> on every request. When I switch all the chassis off Radius NT it will> continue displaying debug/auth. information for awhile 10-20 seconds. It> seems like it's getting behind and it's processing the requests but by the> time it processes the request the NAS has given up and sent a new request> and it ignore's the last ACK???Most likely. You need to be seeing < 250ms response times when running as a service. If you are not, you need to find out why. > I have run this on multiple different PCs, SQL Servers and run radlogin> directly from the Radius/SQL server and the response times always seem to be> between 1000-2000. Lasts results ran against a Double Pentium II/300, 512MB> Ram, RadiusNT, SQL and Radlogin all running on same PC I think that should> eliminate network performance. Also, run as service and without accounting> (currently still running without accounting).You should look at home much memory is allocated to SQL Server. On myp133 Notebook with 16mb of memory to SQL Server and 5000 users, I canget80ms from RadiusNT and radlogin all day long.You also might want to setup a second machine running RadiusNT and splittheprimary auth load between the two of them (using the other one as thesecondary auth). That should help improve things a bit. RadiusNTitselfisn't CPU intensive, so it can run on just about any type of machine.-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Concurrency controlFrom: "Dale E. Reed Jr." Date: Wed, 26 Aug 1998 14:30:46 -0700Postman Account wrote:> > We're running MS SQL 6.5 with RadiusNT.> > Our concurrency control isn't working.... our ServerPorts table is not> being updated... I've selected Manual Calls update... and restarted> RadiusNT.> > Our ServerPorts table has the ServerID, Port#, and IP address> filled out... but, the table isn't being populated with caller> information.... any ideas?It could be because below. Assuming you are receiving accounting andthats your calls table is being populated, check whether you havemanual calls update enabled or a trigger installed. > Also, we are seeing the following error now...> > ODBC Error:S0002:208:> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name> 'CallsOnline'.> > any suggestions? Please respond... thanks in advance..You need to create a view called CallsOnline like this (and grantpermissions):CREATE VIEW CallsOnline ASSelect s.IPAddress, Port, UserName, AcctStatusType, CallDate,FramedAddress