<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
Hi Chester,<BR>
I think for a good behaviour of SQL server, all of them have to be working in a normal startup of a freeradius service. Try to repair why your SQL server are down.<BR>
You have to have a stable system.<BR>
<BR>
Regards,<BR>
Santiago<BR> <BR>
<HR id=stopSpelling>
From: howmanynamesdoihavetotry@googlemail.com<BR>To: freeradius-users@lists.freeradius.org<BR>Subject: Redundant SQL<BR>Date: Mon, 18 Oct 2010 22:00:42 +0100<BR><BR>
<META name=Generator content="Microsoft SafeHTML">
<STYLE>
.ExternalClass p.ecxMsoNormal, .ExternalClass li.ecxMsoNormal, .ExternalClass div.ecxMsoNormal
{margin-bottom:.0001pt;font-size:11.0pt;font-family:'Calibri','sans-serif';}
.ExternalClass a:link, .ExternalClass span.ecxMsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.ecxMsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
.ExternalClass span.ecxEmailStyle17
{font-family:'Calibri','sans-serif';color:windowtext;}
.ExternalClass .ecxMsoChpDefault
{font-family:'Calibri','sans-serif';}
@page WordSection1
{size:612.0pt 792.0pt;}
.ExternalClass div.ecxWordSection1
{page:WordSection1;}
</STYLE>
<DIV class=ecxWordSection1>
<P class=ecxMsoNormal><SPAN style="FONT-SIZE: 9pt">I’m trying to implement the redundant SQL feature into my freeradius setup.</SPAN></P>
<P class=ecxMsoNormal><SPAN style="FONT-SIZE: 9pt"> </SPAN></P>
<P class=ecxMsoNormal><SPAN style="FONT-SIZE: 9pt">The one problem I am coming up against is when freeradius is starting, but not all the SQL servers are available. I have set up sql1 and sql2 as a single virtual module and would ideally like it to *<B>try</B>* to connect to all servers on start-up, but if an error occurs (can’t connect to one), then just bypass and continue.</SPAN></P>
<P class=ecxMsoNormal><SPAN style="FONT-SIZE: 9pt"> </SPAN></P>
<P class=ecxMsoNormal><SPAN style="FONT-SIZE: 9pt">Assuming the total failure to is what is meant to happen, I can understand why, but in my case I’d rather have it connect to at least one database server than fail if it can’t connect to them all.</SPAN></P>
<P class=ecxMsoNormal><SPAN style="FONT-SIZE: 9pt"> </SPAN></P>
<P class=ecxMsoNormal><SPAN style="FONT-SIZE: 9pt">Is this setup possible?</SPAN></P>
<P class=ecxMsoNormal><SPAN style="FONT-SIZE: 9pt"> </SPAN></P>
<P class=ecxMsoNormal><SPAN style="FONT-SIZE: 9pt">Regards,</SPAN></P>
<P class=ecxMsoNormal><SPAN style="FONT-SIZE: 9pt"> </SPAN></P>
<P class=ecxMsoNormal><SPAN style="FONT-SIZE: 9pt">Chester.</SPAN></P></DIV><BR>- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html </body>
</html>