FreeRadios rlm_sql dumps if databaase server hiccups
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?
Matt wrote:
"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?
Please upgrade FreeRADIUS to version 1.1.2. -- Nicolas Baradakis
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@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?
Hi, we are looking at setting up FreeRadius on a test SME 7 box for the first time - we are using an AOpen AP as a test AP. Is there any step-by-step intro available on the web, we are getting bogged down in a mass of details and conf files. Thanks for any pointers. Dylan Dylan Haines - IT Support Specialist dhaines@ssrsb.ca CNA, A+, Network+, ACDT South Shore Regional School Board Nova Scotia 902-624-2127
Sorry, I messed up the subject, corrected above. We have now found the correct templates folders but are still a bit in the dark as to where to start. /etc/e-smith/templates-custom/etc/raddb and radiusclient (copied from the templates folder) Dylan Dylan Haines - IT Support Specialist dhaines@ssrsb.ca CNA, A+, Network+, ACDT South Shore Regional School Board Nova Scotia 902-624-2127
dhaines@ssrsb.ca 6/16/2006 10:50:44 am >>> Hi, we are looking at setting up FreeRadius on a test SME 7 box for the first time - we are using an AOpen AP as a test AP.
Is there any step-by-step intro available on the web, we are getting bogged down in a mass of details and conf files. Thanks for any pointers. Dylan Dylan Haines - IT Support Specialist dhaines@ssrsb.ca CNA, A+, Network+, ACDT South Shore Regional School Board Nova Scotia 902-624-2127 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
"Dylan Haines" <dhaines@ssrsb.ca> wrote:
Is there any step-by-step intro available on the web, we are getting bogged down in a mass of details and conf files.
Install the server. Test it with a simple user in the "users" file, as suggested in the FAQ. Once that works, see http://www.freeradius.org/doc/ for how to configure EAP certificates. Then, try the access point. It would also help to say *where* you're getting bogged down and *why*. Alan DeKok.
Thanks, this is a start. Dylan Dylan Haines - IT Support Specialist dhaines@ssrsb.ca CNA, A+, Network+, ACDT South Shore Regional School Board Nova Scotia 902-624-2127
aland@nitros9.org 6/16/2006 12:54 pm >>> "Dylan Haines" <dhaines@ssrsb.ca> wrote: Is there any step-by-step intro available on the web, we are getting bogged down in a mass of details and conf files.
Install the server. Test it with a simple user in the "users" file, as suggested in the FAQ. Once that works, see http://www.freeradius.org/doc/ for how to configure EAP certificates. Then, try the access point. It would also help to say *where* you're getting bogged down and *why*. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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@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
I'll do that, however unless the fail-over has something to do with freeradius, we already do it (with our access servers)... the problem is... freradius is sending a reject packet back when it doesn't get a responce from the database.... EXAMPLE: Database server gets restarted (for whatever reason) at 4am when we do some maintence. I now need to restart every one of our radius servers.. because they don't reconnect the ODBC stream to MS SQL! On 6/16/06, Michael Lecuyer <mjl@theorem.com> wrote:
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@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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (5)
-
Alan DeKok -
Dylan Haines -
Matt -
Michael Lecuyer -
Nicolas Baradakis