Hi Ric, Each AuthBy SQL clause (ie each instance of Radiu::AuthSQL) opens its own connection to the SQL server, which it tries to keep open as long as possible. Hope that helps. Cheers. ---------------------------------------------------------------------------- --------------- Mike McCauley [EMAIL PROTECTED] Open System Consultants +61 3 9598 0985 Mike is travelling right now, and there may be delays in our correspondence. -----Original Message----- From: Ric O'Connell <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Cc: Mark Stokan <[EMAIL PROTECTED]> Date: Thursday, October 14, 1999 3:10 PM Subject: (RADIATOR) How does Radiator handle multple SQL connections? >Hello all, > >We have Radiator authenticating to our Oracle SQL database. I have a schema >per realm, so I am wondering how Radius's AuthbySQL module will handle this. >Is it going to open a connection to one database, then close it, and then >open a connection to the other database? > >DBI-->Connect statements are costly and slow, and I'd like to keep the >Database pointer open as long as Radiator is running. Will it open a pointer >per realm, or is the SQL pointer a global varialble? I've poked around a bit >in AuthSQL.pm and it looks like you open the database in "initialize" which >is called once per instance and not "new" which is called once per realm. Is >this right? > >Ric > >-- >Ric O'Connell >Engineering Director >1stUp.com Corporation >[EMAIL PROTECTED] >tel:415.782.3920 >cell:415.305.3235 >fax:415.981.9353 > >-- Free The WebŪ -- > > > > > >________________________________________________________ > 1stUp.com - Free the Web.(TM) > Get your free Internet access at http://www.1stUp.com > >=== >Archive at http://www.thesite.com.au/~radiator/ >To unsubscribe, email '[EMAIL PROTECTED]' with >'unsubscribe radiator' in the body of the message. > === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.