From: "Denny Figuerres" <firstname.lastname@example.org> Subject: RE: [RadiusNT] Radius 3.0.184 , caching and concurrency Date: Thu, 21 Dec 2000 13:21:41 -0500 Message-ID: <NDBBLBKDALOHCLAFDAPIOEFNCCAA.email@example.com>
Um... for part of this check the advanced SNMP features.
With SNMP active Radius will do an SNMP call to ask that Terminal if in fact
that user is on-line and if not let them login.
Also I seem to recall that if you do that then the serverports table will
clean-up on it's own over time.
Check the docs about the needed setup info.
[mailto:firstname.lastname@example.org]On Behalf Of Serkan SUBA?I
Sent: Thursday, December 21, 2000 8:34 AM
Subject: [RadiusNT] Radius 3.0.184 , caching and concurrency
I think caching mechanism must be adjusted carefully when using
we are running radius 8.0.184 on a windows 2000 server SP1 (and post sp1
and radius database is a MS SQL server 7.0 SP2 on a windows 2000 server
SP1 (and post sp1 fixes)
months we are having so much concurrency problems, we are trying to
analyze the problem, so far we found that, there can be at least two
reasons for this
1. acccounting records are late (one user disconnects from port x, and
then trying to connect port y, and got an error 'concurrency limit')
we build a trigger like this and see that, not every error has an
serverports record (AcctStatusType = 1), some
CREATE TRIGGER RadLogs_Insert ON dbo.RadLogs
INSERT into serverports_LOG (ServerID, Port, UserName, AccountID,
AcctStatusType, CallDate, FramedAddress, CallerID, RLCallerID,
AcctSessionID, ConnectInfo, NASPortDNIS, SNMPUser, RSPCheck, LastReset,
SELECT sp.ServerID, sp.Port, sp.UserName, sp.AccountID, sp.AcctStatusType,
sp.CallDate, sp.FramedAddress, sp.CallerID, i.CallerID, sp.AcctSessionID,
sp.ConnectInfo, sp.NASPortDNIS, sp.SNMPUser, sp.RSPCheck, sp.LastReset,
from serverports sp, inserted i
where sp.username = i.username AND i.RadLogMsgID = 11
AND sp.AcctStatusType <> 2
2. caching mechanism may lately send update serverports queries , or
insert radlogs queries
I set in cache tab, acccounting section (1000 items, 0 sec, 0 items)
Do you have any idea , how can we solve this problem ?