Hi Alan, Ok, glad to know it wasn't me :) Regards, Kelvin
Date: Thu, 22 Jan 2009 14:21:26 +0100 From: aland@deployingradius.com To: freeradius-users@lists.freeradius.org Subject: Re: Virtual Server with Multiple Databases
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. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
_________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/