<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>hey thanks! got it working using that configuration below. It also worked when placed in instantiate block.<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 face="Arial" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Arran Cudbard-Bell <a.cudbardb@freeradius.org><br><b><span style="font-weight: bold;">To:</span></b> FreeRadius users mailing list <freeradius-users@lists.freeradius.org><br><b><span style="font-weight: bold;">Cc:</span></b> Det Det <det.explorer@yahoo.com><br><b><span style="font-weight: bold;">Sent:</span></b> Tuesday, October 4, 2011 6:24 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: SQL IP
 Pool Not Accepting Redundant SQL<br></font><br>
<meta http-equiv="x-dns-prefetch-control" content="off"><div id="yiv641400821"><div><div><br><blockquote type="cite"><div style="word-wrap: break-word;"><div><div><br></div><div>You can't, 'redundant_sql' is not an sql-instance. You need to create two instances of sqlippool, then wrap them in a redundant block...</div></div></div></blockquote><div><br></div><div>If you're using FR >= 2.1.11 or 3.*</div></div><div><br></div><div>Overload the sqlippool module</div><div><br></div><div>policy.conf</div><div><br></div><div>policy {</div><div><span class="yiv641400821Apple-tab-span" style="white-space: pre;">   </span>sqlippool {</div><div><span class="yiv641400821Apple-tab-span" style="white-space: pre;">            </span>redundant {</div><div><span class="yiv641400821Apple-tab-span" style="white-space: pre;">                    </span>sqlippool1</div><div><span class="yiv641400821Apple-tab-span" style="white-space: pre;">                     </span>sqlippool2</div><div><span
 class="yiv641400821Apple-tab-span" style="white-space: pre;">           </span>}</div><div><span class="yiv641400821Apple-tab-span" style="white-space: pre;">      </span>}</div><div>}</div><div><br></div><br><div>
<span class="yiv641400821Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;"><span class="yiv641400821Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;"><div style="word-wrap: break-word;"><span class="yiv641400821Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height:
 normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;"><div style="word-wrap: break-word;">Arran Cudbard-Bell<br><a rel="nofollow" ymailto="mailto:a.cudbardb@freeradius.org" target="_blank" href="mailto:a.cudbardb@freeradius.org">a.cudbardb@freeradius.org</a><br><br>Betelwiki, Betelwiki, Betelwiki....<span class="yiv641400821Apple-converted-space"> </span>http://wiki.freeradius.org/ !</div></span></div></span></span>
</div>

<br></div></div><meta http-equiv="x-dns-prefetch-control" content="on"><br><br></div></div></div></body></html>