I am a newbie to FreeRadius, I prefer some kind of validation/authorization before.<div><br clear="all"><font class="Apple-style-span" size="3"></font><br><div class="gmail_quote">2011/7/6 Arran Cudbard-Bell <span dir="ltr"><<a href="mailto:a.cudbardb@freeradius.org" target="_blank">a.cudbardb@freeradius.org</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">Why don't you add it to the wiki ;)<div><br></div><div>-Arran<div><div></div><div><br><div><div>On Jul 6, 2011, at 10:59 AM, Aurélien Lafranchise wrote:</div><br><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 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/" style="color:rgb(17, 85, 204)" target="_blank">rlm_sql_oracle-2.1.11.so</a></span></div>
<div><font color="#500050" face="arial, sans-serif"><span style="border-collapse:collapse">3. cp .libs/</span></font> <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/" style="color:rgb(17, 85, 204)" target="_blank">rlm_sql_oracle-2.1.11.so</a></span><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 color="#500050" face="arial, sans-serif"><span style="border-collapse:collapse">4. ln -s </span></font><span style="border-collapse:collapse;color:rgb(80, 0, 80);font-family:arial, sans-serif;font-size:13px"> /usr/lib64/freeradius/</span><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/" style="color:rgb(17, 85, 204)" target="_blank">rlm_sql_oracle-2.1.11.so</a> </span><span style="border-collapse:collapse;color:rgb(80, 0, 80);font-family:arial, sans-serif;font-size:13px">/usr/lib64/freeradius/</span><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/" style="color:rgb(17, 85, 204)" target="_blank">rlm_sql_oracle.so</a></span></div>
<div><font color="#500050" face="arial, sans-serif"><span style="border-collapse:collapse">5.1 in /etc/raddb cnfigure sql.conf</span></font></div><div><font color="#500050" face="arial, sans-serif"><span style="border-collapse:collapse">5.2 radiusd.conf(uncomment </span></font><span style="border-collapse:collapse;color:rgb(80, 0, 80);font-family:arial, sans-serif">$INCLUDE sql.conf)</span></div>
<div><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 color="#500050" face="arial, sans-serif"><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 color="#500050" face="arial, sans-serif"><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" target="_blank">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><<a href="mailto:aurelien_lafranchise@snype.org" target="_blank">aurelien_lafranchise@snype.org</a>> wrote:<br>
</div><div>> 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>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" target="_blank">http://www.freeradius.org/list/users.html</a></blockquote></div><br></div></div><div>
<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;text-align:auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><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;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><div style="word-wrap:break-word">
<div>Arran Cudbard-Bell</div><div><a href="mailto:a.cudbardb@freeradius.org" target="_blank">a.cudbardb@freeradius.org</a></div><div><br></div><div>RADIUS - Half the complexity of Diameter</div></div></span></span>
</div>
<br></div></div><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></blockquote></div><br></div>