[RadiusNT] ServerAccess "time of day" accounts fixed, CallsOnline

Mike Miller ( michael@abraxis.com )
Thu, 25 Feb 1999 12:55:34 -0500

Hello again,

When we upgraded from Radius 2.2 to 2.5 the Server Port Access features for
"time of day" accounts started working properly.

Since the 2.5 upgrade we seem to have a new issue. For at least six months
prior to this upgrade we have never had a problem with users getting "hung"
in the calls online list. I have now observed that one or two people each
day are getting stuck as an acctstatustype of online, when they really have
logged off. We have to manually reset their status type to offline for the
account to be usable again. Concurrency control is a must in our
environment, which means accuracy of this data is very important. Out of
the several thousand daily accounting records Radius processes, one or two
daily errors may seem like a awful small percentage, but it is a nuisance
nonetheless, and raises questions about the accounting data integrity of
Radius 2.5. Are there any issues we should be aware of between the 2.2 to
2.5 upgrade that may be affecting proper reporting of CallsOnline?

-Mike Miller
Abraxis Networks

--At 09:18 AM 2/18/99 -0800, you wrote:>Mike Miller wrote:>> >> Software running:>> Radius NT 2.2>> MS-SQL 6.5 SP4>> >> We are trying to set up a "time of day" account on one of our NASs.  We>> have done the following:>>RadiusNT 2.2 used a different scale (I believe it was seconds based)>that 2.5 does.  I would recommend upgrading to RadiusNT 2.5, as it>fixed a couple of other issues with the server port access as well.> >> 1. Enabled "Server Port Access" in the RadiusNT administrator>> 2. Populated the ServerAccess table for the NAS in question with the>> following:>>     ServerID: <server id of the nas from servers table>>>     Port: 10101-10124, 10201-10224, 20101-20124, 20201-20224>>           (this is an Ascend box)>>     StartTime: 1110 (6:30 PM)>>     StopTime: 1410 (11:30 PM)>> >> After having problems with this we checked the list archives and added the>> following stored procedure to SQL:>> >> CREATE PROCEDURE RadCheckPort @nasid varchar(16), @nasport integer, @at>> varchar(15) AS>> Select MaxSessionLength, StartTime, StopTime, CurrTime = (DatePart(Hour,>> GetDate()) * 60) + DatePart(Minute, GetDate())>> >From Servers s, ServerAccess sa>> Where s.ServerID = sa.ServerID>> AND s.IPAddress = @nasid>> AND (sa.Port=@nasport or sa.Port=NULL)>> AND sa.AccountType = @at>> GO>> >> The problem is Radius is authenticating on this port at *any* time of the>> day without regard to the specified start and stop times.  Is there>> something I am missing here?>> >> -Mike Miller>> >> -->====================================================  /\                          Mike A. Miller     == /--\         \/              Abraxis Networks   ==/    \ B R A  /\ I S                             ==             /                                   ==      N E T W O R K S         michael@abraxis.com====================================================

For more information about this list, including removal, pleasesee this URL: http://www.iea-software.com/maillist.html