Multiple database and virtual server

Alan DeKok aland at deployingradius.com
Thu Nov 13 16:29:40 CET 2008


Michael Plourde wrote:
>>   You don't have to do that.  You can use one SQL instance, and change
>> the radius_db on the fly.  But for now, it's likely good enough.
> 
> How can I change radius_db on the fly  ?

  It's just another piece of text in a configuration file.  Edit it to
something like:

	radius_db = %{control:Foo-Bar-Baz}

  Edit raddb/dictionary to add the attribute Foo-Bar-Baz (with a name
that makes sense).  Follow the instructions there for picking numbers, etc.

  Once that's done, just set it at the top of the "authorize" and
"preacct" sections in the virtual servers:

	update control {
		Foo-Bar-Baz = "database-name-1"
	}

  Or "database-name-2".  That will work.

>>   See the sample SQL queries && schema.  2.1.1 allows you to define a
>> "server" column.  That entry is used to associate one client with a
>> particular server.
> 
> That already done as I said upper:

  Hmm...  it *should* work.  I haven't spent much time with that portion
of the code, though.

  Alan DeKok.



More information about the Freeradius-Users mailing list