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...@lists.freeradius.org [mailto:freeradius-
> users-bounces+a.freeradius=premit...@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
