(RADIATOR) Recommendation on Session Table

[S H A N]

hi,
	thanks for your assistance. i appreciate your promptness.
rgds,

On Tue Jul 15, 2003 at 04:11:20PM SGT, Hugh Irvine wrote:

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

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