Multiple database and virtual server

[Michael Plourde]

> Michael Plourde wrote:
> > I want to use multiple database to sort different kind of radius
> > authentification (dialup, wireless, router login, etc). I don't know if
i'm
> > using it the right way, but I have try to run freeradius with two
virtual
> > server using two different sql instance. Those sql instance are
configured
> > the same way except for the database: one use "radius_db =
radius_dialup"
> > and the other one "radius_db = radius_login".
>
>   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  ?
>
> > If I load only one of those
> > virtual server at radiusd startup (I remove sites-enabled links for one
of
> > those server), everything works fine. If I try them together, I got this
> > error:
> >
> > Adding client 172.16.0.2 (gw-calma.digicom.ca, server=MT-Login-User) to
> > clients list
> > Failed to add duplicate client gw-calma.digicom.ca
> > rlm_sql (sql_MT): Failed to add client 172.16.0.2 (gw-calma.digicom.ca)
to
> > clients list.  Maybe there's a duplicate?
> > Failed to load clients from SQL.
> ...
> > Doesn't each virtual server had his own clients list ? Why duplicate
entry ?
> > How can I force freeradius to use one client list per virtual server
taken
> > from SQL table ?
>
>   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:
> > Adding client 172.16.0.2 (gw-calma.digicom.ca, server=MT-Login-User) to
> > clients list
but even with server specify I've got this error with Freeradius 2.1.0.
>
>   Alan DeKok.
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>
>
> -- 
> Internal Virus Database is out-of-date.
> Checked by AVG.
> Version: 7.5.549 / Virus Database: 270.8.5/1758 - Release Date: 2008-10-31
08:22
>
>

Thank you for your help,

Michael Plourde