RE: Virtual Server with Multiple Databases

2009-01-22 Thread tnt
>I tried that before, it worked fine. The reason why I explored the possibility >of using CONTROL is avoid similar sections that called to different sql >instance in the configuration file counter.conf, which will require the server >section to call noresetcounter1, noresetcounter2 and . >

RE: Virtual Server with Multiple Databases

2009-01-22 Thread Kelvin Chiang
Hi Alan, Ok, glad to know it wasn't me :) Regards, Kelvin > Date: Thu, 22 Jan 2009 14:21:26 +0100 > From: al...@deployingradius.com > To: freeradius-users@lists.freeradius.org > Subject: Re: Virtual Server with Multiple Databases > > Kelvin Chiang wrote: > > It se

Re: Virtual Server with Multiple Databases

2009-01-22 Thread Alan DeKok
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.

RE: Virtual Server with Multiple Databases

2009-01-22 Thread Kelvin Chiang
. Or may be I am wrong, that there is an easier way to manage the counter even if I define multiple sql instances? Regards, Kelvin > To: freeradius-users@lists.freeradius.org > Subject: Re: Virtual Server with Multiple Databases > Date: Thu, 22 Jan 2009 11:15:35 +0100 > From: t.

RE: Virtual Server with Multiple Databases

2009-01-22 Thread Kelvin Chiang
, 22 Jan 2009 11:12:14 +0100 > From: al...@deployingradius.com > To: freeradius-users@lists.freeradius.org > Subject: Re: Virtual Server with Multiple Databases > > Kelvin Chiang wrote: > ... > > rlm_sql (radius_test_sql): Ignoring unconnected handle 4.. > > rlm_sql (ra

Re: Virtual Server with Multiple Databases

2009-01-22 Thread tnt
>I am currently using version 2.1.3-1. I was trying to create virtual servers >accessing to different mysql databases. Create multiple sql instances in sql.conf: sql sql1 { .. } sql sql2 { .. } etc. Use the name of the instance you want in the virtual server instead of "sql". Ivan Kalik Kalik

Re: Virtual Server with Multiple Databases

2009-01-22 Thread Alan DeKok
Kelvin Chiang wrote: ... > rlm_sql (radius_test_sql): Ignoring unconnected handle 4.. > rlm_sql (radius_test_sql): Ignoring unconnected handle 3.. > rlm_sql (radius_test_sql): Ignoring unconnected handle 2.. Your SQL database is down. This has nothing to do with the configuration changes you ma

Virtual Server with Multiple Databases

2009-01-21 Thread Kelvin Chiang
Hi, I am currently using version 2.1.3-1. I was trying to create virtual servers accessing to different mysql databases. From some of the historical threads, I understood that the followings steps are needed: 1. Create an entry in /etc/raddb/dictionary. I had the line as: ATTRIBUTE My-DB 3000