Virtual Server with Multiple Databases

Alan DeKok aland at
Thu Jan 22 14:21:26 CET 2009

Kelvin Chiang wrote:
> It seems that the issue is not the MySQL database. If I defined
> radius_db = "my_radiusdb_name" in the sql instance, everything works
> fine. However, if I used authorize and preacct to define the database
> name on the fly, the errors occurred.

  Ah.  That isn't supported.  It is a limitation of the SQL client API's
of most SQL DB's.

  The SQL module keeps socket connections open for a long time to help
performance.  This means connecting to a specific database.

  You will need to define multiple SQL modules to get the same effect.

  Alan DeKok.

More information about the Freeradius-Users mailing list