Multiple database and virtual server

[Michael Plourde]

Hi,

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". 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.

The previous Virtual server client list contain:
rlm_sql (sql_dialup): Read entry
nasname=172.16.0.113,shortname=test,secret=secret
rlm_sql (sql_dialup): Adding client 172.16.0.113 (test, server=dialup) to
clients list
rlm_sql (sql_dialup): Read entry
nasname=172.16.0.2,shortname=calma,secret=xxxxxx
rlm_sql (sql_dialup): Adding client 172.16.0.2 (calma, server=dialup) to
clients list
rlm_sql (sql_dialup): Read entry
nasname=10.0.0.2,shortname=PowerAP-test,secret=xxxxx
rlm_sql (sql_dialup): Adding client 10.0.0.2 (PowerAP-test, server=dialup)
to clients list
rlm_sql (sql_dialup): Read entry
nasname=10.10.0.5,shortname=395scott,secret=xxxxxx
rlm_sql (sql_dialup): Adding client 10.10.0.5 (395scott, server=dialup) to
clients list
rlm_sql (sql_dialup): Read entry
nasname=172.16.0.237,shortname=calma2,secret=xxxxxx
rlm_sql (sql_dialup): Adding client 172.16.0.237 (calma2, server=dialup) to
clients list

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 ?

Regards,

Michael Plourde