MySQL Fail Over Error When 1 DB is Down

2011-08-29 Thread Det Det
Hi there, I can't get FreeRADIUS to ignore error and continue processing when 1 DB is down even when it can connect to the other DB. Below is my config. # radiusd.conf instantiate { ...     redundant redundant_sql {     sql1     sql2                 handled    

MySQL Fail Over Error When 1 DB is Down

2011-08-29 Thread Det Det
PM Subject: MySQL Fail Over Error When 1 DB is Down Hi there, I can't get FreeRADIUS to ignore error and continue processing when 1 DB is down even when it can connect to the other DB. Below is my config. # radiusd.conf instantiate { ...     redundant redundant_sql {     sql1

Re: MySQL Fail Over Error When 1 DB is Down

2011-08-29 Thread Alan DeKok
Det Det wrote: When I shutdown one of the DB, it generates an error. How do I tell freeradius to ignore that and proceed if it can connect to at least one of the DB? You don't. The only way to change this is via source code patches. Alan DeKok. - List info/subscribe/unsubscribe? See

Re: MySQL Fail Over Error When 1 DB is Down

2011-08-29 Thread Det Det
...@deployingradius.com To: Det Det det.explo...@yahoo.com; FreeRadius users mailing list freeradius-users@lists.freeradius.org Sent: Monday, August 29, 2011 6:21 PM Subject: Re: MySQL Fail Over Error When 1 DB is Down Det Det wrote: When I shutdown one of the DB, it generates an error. How do I tell freeradius

Re: MySQL Fail Over Error When 1 DB is Down

2011-08-29 Thread Alan DeKok
Det Det wrote: Really? sigh If you think I'm lying, why ask questions? What is the failover feature for? Read the docs. It's explained. I can specify multiple DBs but if FreeRADIUS cannot connect to at least one of the DBs it will have an error and will not be able to start. There

Re: MySQL Fail Over Error When 1 DB is Down

2011-08-29 Thread Rich Graves
When I shutdown one of the DB, it generates an error. How do I tell freeradius to ignore that and proceed if it can connect to at least one of the DB? /etc/freeradius/sql2.conf[22]: Instantiation failed for module sql2 Both databases must be up at the time of radiusd startup. This seems

Re: MySQL Fail Over Error When 1 DB is Down

2011-08-29 Thread det.explo...@yahoo.com
Hi, Sorry, I honestly don't mean it that way. I just want to clarify some of that thoughts/concepts. I understand now what you mean by this. Fail-over is for when something goes wrong while the server is running. Thanks, Det Sent from my iPad On Aug 29, 2011, at 9:34 PM, Alan DeKok

Re: MySQL Fail Over Error When 1 DB is Down

2011-08-29 Thread det.explo...@yahoo.com
Thanks so much! I understand it now. And thanks for the suggestions and additional inputs. BRegards, Det Sent from my iPad On Aug 29, 2011, at 10:56 PM, Rich Graves rgra...@carleton.edu wrote: When I shutdown one of the DB, it generates an error. How do I tell freeradius to ignore that and