Hi all,

As I said, here is the step by step when using Oracle Instant Client 11 :

1. Decompress the tar file.

2. In src/modules/rlm_sql/drivers/rlm_sql_oracle :

2.1. Do "autoconf"

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

2.3. then "make" and you should have a .libs directory with a file rlm_sql_oracle-2.1.11.so

3. cp .libs/ rlm_sql_oracle-2.1.11.so /usr/lib64/freeradius/

4. ln -s  /usr/lib64/freeradius/rlm_sql_oracle-2.1.11.so /usr/lib64/freeradius/rlm_sql_oracle.so

5.1  in /etc/raddb cnfigure sql.conf

5.2 radiusd.conf(uncomment $INCLUDE sql.conf)

5.3 site-available/default uncomment linewith sql in the wanted section

5.4 from the decopressed archive cp -r raddb/sql/oracle /etc/raddb/sql/

6. Be sure that environnement variables for the user who launch radiusd to have export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib and export ORACLE_HOME=/usr/include/oracle/11.2/client64

6.1 if not put it in the /etc/init.d/radiusd file

7. Launch freeradius (radiusd -X for debug and if ok service radiusd start)

Hope this will help other people and at least to correct the bug of the 2.1.11 release installation procedure.

Thanks all

2011/7/6 Fajar A. Nugraha <list@fajar.net>

On Tue, Jul 5, 2011 at 10:02 PM, Aurélien Lafranchise

<aurelien_lafranchise@snype.org> wrote:

> I putted rlm_sql_oracle-2.1.11.so in  /usr/lib64/freeradius/ and create the
> symbolic link on /usr/lib64/freeradius/rlm_sql_oracle.so
> but :
> Could not link driver rlm_sql_oracle: file not found
> Make sure it (and all its dependent libraries!) are in the search path of
> your system's ld.
> /etc/raddb/sql.conf[22]: Instantiation failed for module "sql"
> /etc/raddb/sites-enabled/default[393]: Failed to load module "sql".
> /etc/raddb/sites-enabled/default[360]: Errors parsing accounting section.
> Could it be because I compile a 2.1.11 version and putted
> the rlm_sql_oracle-2.1.11.so on a 2.1.10 ?

That's why I said earlier it's better to rebuild the RPM with modified
SPEC file. One of the reasons was to avoid version and location mess.
John posted an additional link earlier with more useful information.

If you want to mix RPM and self-compiled module, better use it from
the same version, as there might be some incompatible changes between
versions.

--

Fajar

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html