Re: Virtual server specific SQL schema.

15 Jun 2010

      Hi Stefan,

Thanks for the suggestion, that's actually my back-up plan.  The key issue is 
that a single MySQL server will be used, and peak-load on that server can be 
quite high.  By creating multiple instances, I cannot scale the maximum number 
of sockets high enough meet the requirements.  Perhaps on missing something with 
regard to MySQL optimization, but during testing I found increasing the maximum 
number of sockets was necessary to meet the performance requirements.

-- Stephen

On 6/15/2010 15:20, Stefan A. wrote:
...
Stephen,
what's about using instances in the sql.conf like
sql sql_virtual_1{
  database = "mysql"
  driver = "rlm_sql_${database}"
  server = "dbcnode2"
  port="3306"
  login = "user"
  password = "pw"
  radius_db = "dbname"
  ...all the other stuff...
}
Having several such sections, you'd be able to call them in cour virtual
server as
authorize {
  preprocess
  chap
  mschap
  suffix
  eap {
      ok = return
  }
  unix
-->	sql_virtual_1	
  files
  expiration
  logintime
  pap
}
You only have to exchange the values of
  server = "dbcnode2"
  port="3306"
  login = "user"
  password = "pw"
for each instance...
Does this help?
Stefan
...
-----Original Message-----
From: freeradius-users-
bounces+a.freeradius=premit.de@lists.freeradius.org [mailto:freeradius-
users-bounces+a.freeradius=premit.de@lists.freeradius.org] On Behalf Of
Stephen Fulton
Sent: Tuesday, June 15, 2010 8:43 PM
To: freeradius user
Subject: Virtual server specific SQL schema.
Greetings,
I am building an FR server using a shared MySQL database that will have
multiple
virtual servers.  Each of the virtual servers needs to use different
radcheck
and radacct tables, each of which has a unique name (eg. radcheck1,
radcheck2).
   The stated preference is that a single database be used, and the
different
tables reside within.  For performance reasons, I would rather specify
the DB
server specific parameters (hostname, user/pass, maximum number of
sockets etc)
globally.
My question:  Is it possible to use a global DB configuration as
outlined above,
but call the schema specific info from within a virtual server?
Thanks,
-- Stephen
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html