<div dir="ltr">Dears<br><br>I have a question regarding the configurable failover codes.<br><br>Our accounting module is  defined as follows <br><br><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Detail…</span></p>




<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Detail_hour_ae1</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">…</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">…</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Redundant{</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Sql2 {</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">    Fail=1</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">    …</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">    …</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> }</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Sql2_redundant {</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">    Fail= return</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">    …</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">    …</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">}</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Sql_update_xxxx</span></b></p><b>
</b><p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Sql_update_yyyy</span></b></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p>
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">}</span><br><br>The last two sql updates ie <b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">"Sql_update_xxxx"  and </span></b><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">"Sql_update_yyyy" </span></b>do
 not have a redundant module defined. The actions of these statement is 
not very critical. However we observe that if the radius is unable to 
execute these the radius drops the session and returns a FAIL. <br>


<br>One way to avoid this session disconnection is to implement a redundant module for the last two statements as well.<br><br>We are looking at a possibility of this second solution. And require help in this regard.<br>


If we modify our configuration to something like this<br><br><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Redundant{</span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">     Sql{</span></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Ok=2</span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">     }</span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">    Sql2</span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">     {</span></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Ok=3</span></p>
<p class="MsoNormal" style="margin-left:0.5in"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)">     }</span></p><p class="MsoNormal" style="margin-left:0.5in"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)"></span></p>


<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">}<br></span></p>
<p class="MsoNormal" style="margin-left:0.5in"><span style="font-size:11pt;font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><br></span></p><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Group{</span></p>



<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">                               Sql_update_xxxx</span></b></p><b>
</b><p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">                               Sql_update_yyyy</span></b></p><p class="MsoNormal" style="margin-left:.5in;text-indent:.5in">


<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">…</span></p>
<p class="MsoNormal" style="margin-left:.5in;text-indent:.5in"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Fail =1</span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">}</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">}</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Ok  will override Fail because the priority is higher.</span></b></p><b>
</b><p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">So the accounting module will not return failure because of the third module (atleast in theory)</span><span style="font-size:11.0pt;font-family:Wingdings;color:#1f497d"></span>.</b></p>


<p class="MsoNormal"><br></p><p class="MsoNormal">Does anyone have a solution/suggestions for this kind of a problem. <br></p><p class="MsoNormal"><br></p><p class="MsoNormal">Thanks & Regards</p><p class="MsoNormal">
Shweta</p></div>