Virtual server specific SQL schema.

[Stefan A.]

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