<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Why don't you add it to the wiki ;)<div><br></div><div>-Arran<br><div><div>On Jul 6, 2011, at 10:59 AM, Aurélien Lafranchise wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Hi all,<div><br></div><div>As I said, here is the step by step when using Oracle Instant Client 11 :</div><div><br></div><div>1. Decompress the tar file.</div><div>2. In src/modules/rlm_sql/drivers/rlm_sql_oracle :</div><div>
2.1. Do "autoconf"</div><div>2.2 .and then ./configure --with-oracle-lib-dir=/usr/lib/oracle/11.2/client64/lib --with-oracle-include-dir=/usr/lib/oracle/11.2/client64</div><div>2.3. then "make" and you should have a .libs directory with a file <span class="Apple-style-span" style="border-collapse: collapse; color: rgb(80, 0, 80); font-family: arial, sans-serif; font-size: 13px; "><a href="http://rlm_sql_oracle-2.1.11.so/" target="_blank" style="color: rgb(17, 85, 204); ">rlm_sql_oracle-2.1.11.so</a></span></div>
<div><font class="Apple-style-span" color="#500050" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">3. cp .libs/</span></font> <span class="Apple-style-span" style="border-collapse: collapse; color: rgb(80, 0, 80); font-family: arial, sans-serif; font-size: 13px; "><a href="http://rlm_sql_oracle-2.1.11.so/" target="_blank" style="color: rgb(17, 85, 204); ">rlm_sql_oracle-2.1.11.so</a></span><span class="Apple-style-span" style="border-collapse: collapse; color: rgb(80, 0, 80); font-family: arial, sans-serif; font-size: 13px; "> /usr/lib64/freeradius/</span></div>
<div><font class="Apple-style-span" color="#500050" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">4. ln -s </span></font><span class="Apple-style-span" style="border-collapse: collapse; color: rgb(80, 0, 80); font-family: arial, sans-serif; font-size: 13px; "> /usr/lib64/freeradius/</span><span class="Apple-style-span" style="border-collapse: collapse; color: rgb(80, 0, 80); font-family: arial, sans-serif; font-size: 13px; "><a href="http://rlm_sql_oracle-2.1.11.so/" target="_blank" style="color: rgb(17, 85, 204); ">rlm_sql_oracle-2.1.11.so</a> </span><span class="Apple-style-span" style="border-collapse: collapse; color: rgb(80, 0, 80); font-family: arial, sans-serif; font-size: 13px; ">/usr/lib64/freeradius/</span><span class="Apple-style-span" style="border-collapse: collapse; color: rgb(80, 0, 80); font-family: arial, sans-serif; font-size: 13px; "><a href="http://rlm_sql_oracle-2.1.11.so/" target="_blank" style="color: rgb(17, 85, 204); ">rlm_sql_oracle.so</a></span></div>
<div><font class="Apple-style-span" color="#500050" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">5.1 in /etc/raddb cnfigure sql.conf</span></font></div><div><font class="Apple-style-span" color="#500050" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">5.2 radiusd.conf(uncomment </span></font><span class="Apple-style-span" style="border-collapse: collapse; color: rgb(80, 0, 80); font-family: arial, sans-serif; ">$INCLUDE sql.conf)</span></div>
<div><span class="Apple-style-span" style="border-collapse: collapse; color: rgb(80, 0, 80); font-family: arial, sans-serif; ">5.3 site-available/default uncomment linewith sql in the wanted section</span></div><div><font class="Apple-style-span" color="#500050" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">5.4 from the decopressed archive cp -r raddb/sql/oracle /etc/raddb/sql/<br>
</span></font></div><div><font class="Apple-style-span" color="#500050" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">6. Be sure that environnement variables for the user who launch radiusd to have </span></font>export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib and export ORACLE_HOME=/usr/include/oracle/11.2/client64</div>
<div>6.1 if not put it in the /etc/init.d/radiusd file</div><div>7. Launch freeradius (radiusd -X for debug and if ok service radiusd start)</div><div><br></div><div>Hope this will help other people and at least to correct the bug of the 2.1.11 release installation procedure.</div>
<div><div class="gmail_quote"><br></div><div class="gmail_quote">Thanks all</div><div class="gmail_quote"><br></div><div class="gmail_quote"><br></div><div class="gmail_quote">2011/7/6 Fajar A. Nugraha <span dir="ltr"><<a href="mailto:list@fajar.net">list@fajar.net</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">On Tue, Jul 5, 2011 at 10:02 PM, Aurélien Lafranchise<br>
<div class="im"><<a href="mailto:aurelien_lafranchise@snype.org">aurelien_lafranchise@snype.org</a>> wrote:<br>
</div><div class="im">> I putted <a href="http://rlm_sql_oracle-2.1.11.so/" target="_blank">rlm_sql_oracle-2.1.11.so</a> in /usr/lib64/freeradius/ and create the<br>
> symbolic link on /usr/lib64/freeradius/rlm_sql_oracle.so<br>
> but :<br>
> Could not link driver rlm_sql_oracle: file not found<br>
> Make sure it (and all its dependent libraries!) are in the search path of<br>
> your system's ld.<br>
> /etc/raddb/sql.conf[22]: Instantiation failed for module "sql"<br>
> /etc/raddb/sites-enabled/default[393]: Failed to load module "sql".<br>
> /etc/raddb/sites-enabled/default[360]: Errors parsing accounting section.<br>
> Could it be because I compile a 2.1.11 version and putted<br>
> the <a href="http://rlm_sql_oracle-2.1.11.so/" target="_blank">rlm_sql_oracle-2.1.11.so</a> on a 2.1.10 ?<br>
<br>
</div>That's why I said earlier it's better to rebuild the RPM with modified<br>
SPEC file. One of the reasons was to avoid version and location mess.<br>
John posted an additional link earlier with more useful information.<br>
<br>
If you want to mix RPM and self-compiled module, better use it from<br>
the same version, as there might be some incompatible changes between<br>
versions.<br>
<font color="#888888"><br>
--<br>
</font><div><div></div><div class="h5">Fajar<br>
<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>
</div></div></blockquote></div><br></div>
-<br>List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></blockquote></div><br><div>
<span class="Apple-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-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-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; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Arran Cudbard-Bell</div><div><a href="mailto:a.cudbardb@freeradius.org">a.cudbardb@freeradius.org</a></div><div><br></div><div>RADIUS - Half the complexity of Diameter</div></div></span></span>
</div>
<br></div></body></html>