Virtual server specific SQL schema.

2010-06-15 Thread Stephen Fulton
Greetings, I am building an FR server using a shared MySQL database that will have multiple virtual servers. Each of the virtual servers needs to use different radcheck and radacct tables, each of which has a unique name (eg. radcheck1, radcheck2). The stated preference is that a single

Re: Virtual server specific SQL schema.

2010-06-15 Thread Stephen Fulton
...@lists.freeradius.org] On Behalf Of Stephen Fulton Sent: Tuesday, June 15, 2010 8:43 PM To: freeradius user Subject: Virtual server specific SQL schema. Greetings, I am building an FR server using a shared MySQL database that will have multiple virtual servers. Each of the virtual servers needs to use different

Re: Virtual server specific SQL schema.

2010-06-15 Thread Stephen Fulton
Tim, You're correct, though there are a few factors causing me to cautious. The first is I'm working on new, untested hardware, and given the complexity of the requirements, I'd rather defer to the knowledge of the list re: performance, before fully implementing it. The second is that the

High CPU usage after SQL failure when using buffered-sql

2009-05-05 Thread Stephen Fulton
Hi all, First, I've used FreeRADIUS for a number of years in a number of installations, and I'm fairly comfortable with it. I have looked through the archives, as well as read the documentation, FAQ, wiki and the notes within each of the configuration files that make up FR, such as the

Re: High CPU usage after SQL failure when using buffered-sql

2009-05-05 Thread Stephen Fulton
Thanks Alan, I'll do that. -- Stephen Alan DeKok wrote: Stephen Fulton wrote: Is there any way to mitigate these CPU issues in version 2.1.4? No. You will need to either upgrade, or *manually* pull the patches from git into a local copy of 2.1.4. Alan DeKok. - List info/subscribe

Re: High CPU usage after SQL failure when using buffered-sql

2009-05-05 Thread Stephen Fulton
Alan, I forgot to ask, is the fix part of stable or development? Thanks, -- Stephen Stephen Fulton wrote: Thanks Alan, I'll do that. -- Stephen Alan DeKok wrote: Stephen Fulton wrote: Is there any way to mitigate these CPU issues in version 2.1.4? No. You will need to either

Re: High CPU usage after SQL failure when using buffered-sql

2009-05-05 Thread Stephen Fulton
Thanks Alan. To follow-up, 2.1.5 was tested using my parameters, and the condition did not reappear. Cheers, -- Stephen Alan DeKok wrote: Stephen Fulton wrote: I forgot to ask, is the fix part of stable or development? Both. The next release will be off of the stable tree. Alan