(RADIATOR) Re: SessionDatabse SQL and Multiple Logins

[Hugh Irvine]

Hello Vignesa -

This question comes up now and again (you will find the discussions on the 
archive site http://www.open.com.au/archives/radiator).

If you look at the delete query closely, you will see that it is the 
NASIDENTIFIER and NASPORT values that are used.

delete from RADONLINE where NASIDENTIFIER='%1' and NASPORT=0%2

This is a preventative maintenance approach to keeping the session database 
up to date. As you know, radius is UDP-based and accounting records can and 
do go missing from time to time. This being the case, Radiator always does a 
delete for the NAS-Identifier and NAS-Port attributes contained in an access 
request. The reasoning being that there cannot already be a session on that 
NAS-Identifier/NAS-Port combination, by definition (a new call cannot come in 
on a channel that already has a call on it).

hth

Hugh


On Mon, 27 May 2002 02:35, Vignesa Moorthy wrote:
> I have configured my Radiator 3.0 & 3.1 to use a Mysql database for session
> management.
>
> I assume that "SessionDatabase SQL" is a global directive.
>
> In each relam that I only want to permit single logins. I have specified
> "DefaultSimultaneousUse 1"
>
> I am using the database schema for the RADONLINE from the goodies dir.
>
> The strange thing is the following:
>
> when an authentication request is first received,
>
> DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER=....
>
> if this is done, the user's session will always be deleted from the
> database. As such multiple logins will be permitted.
>
> Is there something I am missing here?
>
> Regards

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.