Re: buffered-sql, radsqlrelay and fault resilience

2013-06-12 Thread Yann Belin
>> Seems that running additional radius server on management server will >> be a no-go for me. I'm reverting back to first idea and trying to find >> a workaround to get freeradius to start even if accounting/management >> DB is unreachable... Any ideas welcome. > > > Run the detail reader in a sep

Re: buffered-sql, radsqlrelay and fault resilience

2013-06-11 Thread Phil Mayers
On 11/06/13 13:12, Yann Belin wrote: We then have a detail reader (see "copy-acct-to-home-server" virtual server) that reads this file and relays it to the management RADIUS server for centralised logging. If the management server goes down, the files on disc just grow until it comes back again

Re: buffered-sql, radsqlrelay and fault resilience

2013-06-11 Thread Yann Belin
>> We then have a detail reader (see "copy-acct-to-home-server" >> virtual server) that reads this file and relays it to the >> management RADIUS server for centralised logging. >> >> If the management server goes down, the files on disc just grow >> until it comes back again and then the logs are

Re: buffered-sql, radsqlrelay and fault resilience

2013-06-11 Thread Yann Belin
> We then have a detail reader (see "copy-acct-to-home-server" > virtual server) that reads this file and relays it to the > management RADIUS server for centralised logging. > > If the management server goes down, the files on disc just grow > until it comes back again and then the logs are relaye

Re: buffered-sql, radsqlrelay and fault resilience

2013-06-11 Thread Yann Belin
> Which version are you on? > > This might be better/possible in 3.0, as the connection pool stuff might let > you set "0" as the number of initial server connections. Sorry, i should have started with that... Running 2.1.12, which indeed doesn't allow me to do so. - List info/subscribe/unsubscri

Re: buffered-sql, radsqlrelay and fault resilience

2013-06-10 Thread Matthew Newton
On Mon, Jun 10, 2013 at 05:14:16PM +0200, Yann Belin wrote: > I am trying to build a multi-server setup, where each server uses a > local user database (replicated from a central management server) and > buffers its accounting data before pushing it back to the management > server. I have tried two

Re: buffered-sql, radsqlrelay and fault resilience

2013-06-10 Thread Phil Mayers
On 10/06/13 16:14, Yann Belin wrote: On many aspects method #1 is better, but I would like to find a way to make the connection to management server optional at start-up, as I in my case accounting is secondary and should not be interfering with auth. Which version are you on? This might be b

buffered-sql, radsqlrelay and fault resilience

2013-06-10 Thread Yann Belin
Hi all, First a good day to you, since this is my first mail in this list. I am trying to build a multi-server setup, where each server uses a local user database (replicated from a central management server) and buffers its accounting data before pushing it back to the management server. I have