<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>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?<br></span></div><div><br><span></span></div><div><span>/etc/freeradius/sql2.conf[22]: Instantiation failed for module "sql2"<br>/etc/freeradius/radiusd.conf[75]: Failed to find module "sql2".<br>/etc/freeradius/radiusd.conf[75]: Failed to parse "sql2" entry.<br>/etc/freeradius/sites-enabled/default[1]: Errors parsing authorize section. <br><br></span></div><div><br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font size="2" face="Arial"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Det Det
<det.explorer@yahoo.com><br><b><span style="font-weight: bold;">To:</span></b> FreeRadius mailing list <freeradius-users@lists.freeradius.org><br><b><span style="font-weight: bold;">Sent:</span></b> Monday, August 29, 2011 2:05 PM<br><b><span style="font-weight: bold;">Subject:</span></b> MySQL Fail Over Error When 1 DB is Down<br></font><br><meta http-equiv="x-dns-prefetch-control" content="off"><div id="yiv1578932026"><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: times new roman,new york,times,serif; font-size: 12pt;"><div>Hi there,</div><div><br></div><div>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.<br></div><div><br></div><div># radiusd.conf<br>instantiate {<br></div><div>...<br></div><div> redundant redundant_sql
{<br> sql1<br> sql2</div><div><span class="yiv1578932026tab"> </span><span class="yiv1578932026tab"> </span><span class="yiv1578932026tab"> </span><span class="yiv1578932026tab"> handled</span><br> }<br>}<br>modules {</div><div>...</div><div>
$INCLUDE sql1.conf<br> $INCLUDE sql2.conf<span class="yiv1578932026tab"></span><span class="yiv1578932026tab"></span><br>}<br><br># sql1.conf<br>sql sql1 {<br> database = "mysql"<br>…<br>}<br><br># sql2.conf<br>sql sql2 {<br>...<br> database = "mysql"<br>}<br><br># sites-enabled/default<br><br>authorize {<br> redundant_sql<br>}<br>accounting {<br> redundant_sql<br>}<br>session {<br> redundant_sql<br>}<br>post-auth {<br> redundant_sql<br> Post-Auth-Type REJECT {<br>
redundant_sql<br> attr_filter.access_reject<br> }<br>}</div><div><br></div><div><br></div><div>bregards,</div><div>det<br></div></div></div><meta http-equiv="x-dns-prefetch-control" content="on"><br>-<br>List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br><br></div></div></div></body></html>