How to integrate Freeradius with Oracle Database XE(18c)?

[Sajib Nandi]

Hi Peter,
I installed oracle-instantclient18.5
yum localinstall oracle-instantclient18.5-basic-18.5.0.0.0-3.x86_64.rpm
yum localinstall oracle-instantclient18.5-sqlplus-18.5.0.0.0-3.x86_64.rpm
yum localinstall oracle-instantclient18.5-devel-18.5.0.0.0-3.x86_64.rpm

The various packages installed into subdirectories of
/usr/lib/oracle
/usr/include/oracle and
/usr/share/oracle

I followed mentioned link for building the rlm_sql_oracl , I think this
instraction not fully clear, I used below command for building the
rlm_sql_oracle module intoFreeradius
#cd
/usr/local/freeradius-server-3.0.20/src/modules/rlm_sql/drivers/rlm_sql_oracle
#./configure --with-oracle-lib-dir=/usr/lib/oracle/18.5/client64/lib
--with-oracle-include-dir=/usr/include/oracle/18.5/client64
But make and make install command does not work
I see there is no Makefile

1. maybe  I was wrong with building the rlm_sql_oracle module
can you tell me how to build the rlm_sql_oracle module?


2. or I was wrong with oracle database connect:
vi /usr/local/etc/raddb/mods-available/sql
dialect = "oracle"
driver = "rlm_sql_${dialect}"
server = "radius/radius at 113.21.228.14:1521/xepdb1"
radius_db =
"DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=113.21.228.14)(PORT=1521))(CONNECT_DATA=(SID=XE)))"

is this right?

when I go to debugging mode I got following Error
radiusd -X

---------cut-----------
  # Instantiating module "sql" from file
/usr/local/etc/raddb/mods-enabled/sql
rlm_sql (sql): Attempting to connect to database
"DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=113.21.228.14)(PORT=1521))(CONNECT_DATA=(SID=XE)))"
rlm_sql (sql): Initialising connection pool
   pool {
        start = 5
        min = 3
        max = 32
        spare = 10
        uses = 0
        lifetime = 0
        cleanup_interval = 30
        idle_timeout = 60
        retry_delay = 30
        spread = no
   }
rlm_sql (sql): Opening additional connection (0), 1 of 32 pending slots used
rlm_sql_oracle: Oracle logon failed: 'ORA-12154: TNS:could not resolve the
connect identifier specified '
rlm_sql (sql): Opening connection failed (0)
rlm_sql (sql): Removing connection pool
/usr/local/etc/raddb/mods-enabled/sql[27]: Instantiation failed for module
"sql"
------------------------------------------


Thanks
Nandi




On Tue, Mar 31, 2020 at 4:44 AM Peter Lambrechtsen <peter at crypt.nz> wrote:

> Did you download the Oracle client for Linux and make sure that it was
> compiled in when you built the rlm_sql_oracle client?
>
> Oracle Linux Client:
>
> https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html
>
>
> Then follow the instructions on building the rlm_sql_oracle module into
> FreeRadius
>
> https://wiki.freeradius.org/modules/Rlm_sql_oracle
>
>
> On Tue, Mar 31, 2020 at 11:08 AM Sajib Nandi <sajib.aece at gmail.com> wrote:
>
> > I have installed Freeradius and Oracle Database 18c XE.
> > FreeRADIUS Version 3.0.20 -- it's working fine locally
> > Oracle Database XE working fine.
> > But I can not integrate Freeradius with Oracle Database.
> > I need help regarding this How can I integrate Freeradius with oracle
> > database.
> > anyone can help?
> >
> > Thanks
> > Nandi
> > -
> > List info/subscribe/unsubscribe? See
> > http://www.freeradius.org/list/users.html
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html