22 Jan
2009
22 Jan
'09
8:21 a.m.
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.