Re: [RadiusNT] concurrency checking problem with roaming dial-ups

Josh Hillman ( (no email) )
Fri, 6 Oct 2000 15:12:44 -0400

From: "Dale E. Reed Jr." <daler@iea-software.com>
> Make sure RadCheckOnline is ONLY using the ServerPorts table, not
> CallsOnline
> or a union of both ServerPorts and RadRoamPorts.

About a minute after I sent my message, I found the RadCheckOnline sp and
added one line to the end:

CREATE PROCEDURE RadCheckOnline @UserName varchar(64) AS
Select Count(*) From CallsOnline Where UserName=@UserName and
AcctStatusType=1
AND NasIdentifier LIKE '123.123.%'

I used the first two octets of an IP address there because all local NASes
have the same first two octets and all roaming NASes are something
completely different.

This should also do the trick, right?
The first two lines of the sp were never modified and came from whatever
Emerald script generated the sp a while back.

Josh

> Josh Hillman wrote:
> >
> > Dale,
> >
> > What stored procedure do I modify to allow roaming dial-up connections
to
> > connect even if Emerald sees them online already? I don't need to
modify
> > anything for our local dial-ups since that works fine and also uses SNMP
> > concurrency checking.
> >
> > Unfortunately, we're apparently not receiving some of the stop records
for
> > our roaming customers when they disconnect, so Emerald still thinks
they're
> > online and therefore subsequent connections for these people are being
> > rejected because of concurrency (eventhough they're not online). I
can't
> > use SNMP concurrency checking for the roaming people.

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