FreeRadios rlm_sql dumps if databaase server hiccups

[Michael Lecuyer]

I think that authenticating everyone if the database went down would be 
called 'foolsafe' :) If your database is down you're out of business.

There are much better 'failsafe' methods - search for fail-over in the 
FreeRadius documentation.

Matt wrote:
> Ok,
> Well with no answer to this question let me ask it another way...
> 
> In the event of database (via ODBC) failure... is there a way I can
> make the radius server go into "failsafe" mode, and just authenticate
> anything?
> 
> On 6/15/06, Matt <mhoppes at gmail.com> wrote:
> 
>> Hi,
>> We use FreeRadius with unixODBC and the rlm_sql to connect to a
>> Microsoft SQL database.  All works great... except if the SQL database
>> goes down, firewall has the translate table, someone trips over a
>> network cable.... anything that causes the connection between the
>> radius and SQL to be disturbed, it just says
>>
>> "There are no DB handles available...." instead of reconnecting... the
>> only way I've found to reconnect, is to restart...
>>
>> Any comments or thoughts on this problem?
>>
> - List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html
> 
>