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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
