(RADIATOR) Recommendation on Session Table

[Hugh Irvine]

Hello Shan -

I don't think you can use only userids, because the session database is 
updated with a delete when an new user access request is processed by 
Radiator (this is done as a "tidy up" measure in case we missed a stop 
for a user session). If you only have the userids, then you will never 
have more than one session for any user.

The standard AddQuery and DeleteQuery are designed so that only the 
correct sessions are manipulated for access requests, accounting starts 
and accounting stops.

regards

Hugh


On Tuesday, Jul 15, 2003, at 17:57 Australia/Melbourne, S H A N wrote:

>
> so if i opt to use only userid then session table with userids only 
> would be ok?
>
> rgds,
>
> On Tue Jul 15, 2003 at 03:32:31PM SGT, Hugh Irvine wrote:
>
>>
>> Hello Shan -
>>
>> You can configure your own AddQuery in the SessionDatabase SQL clause.
>>
>> See section 6.7.3 in the Radiator 3.6 reference manual.
>>
>> regards
>>
>> Hugh
>>
>>
>> On Tuesday, Jul 15, 2003, at 16:49 Australia/Melbourne, S H A N wrote:
>>
>>>
>>> hi,
>>> 	i need to maintain session table in a mysql database table. by
>>> default radiator is inserting too many variables for each acct start
>>> which in my case i may not require partly because i am looking for
>>> speed.
>>>
>>> 	please advise, what would be the best minimal possible session table
>>> structure i should go with (bearing performance in mind) my session
>>> table is expected to grow to 40,000 entries at peak and I'm going to
>>> use session table to limit simultaneous login to single instance.
>>>
>>> 	thanks & rgds,
>>> -- 
>>> S H A N
>>>
>>> ===
>>> 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.
>>>
>>>
>>
>> NB: have you included a copy of your configuration file (no secrets),
>> together with a trace 4 debug showing what is happening?
>>
>> -- 
>> 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.
>
> -- 
> S H A N
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
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.