Thanks Alan Dekok for your replay. I am communicating with oracle expert. Thanks Nandi On Tue, Mar 31, 2020 at 6:32 PM Alan DeKok <aland@deployingradius.com> wrote:
On Mar 31, 2020, at 1:20 AM, Sajib Nandi <sajib.aece@gmail.com> wrote:
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
That's good.
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
There should be a file 'src/modules/rlm_sql/drivers/rlm_sql_oracle/ all.mk
You can edit this file directly if necessary.
1. maybe I was wrong with building the rlm_sql_oracle module can you tell me how to build the rlm_sql_oracle module?
That should work. And, see below...
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@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----------- ... 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 '
You build the rlm_sql_oracle module correctly. That's good.
The issue now is Oracle. It doesn't like that "radius_db" string, *or* something else. It's hard to say, as we're not Oracle people.
A quick google search yields this, which might help:
https://community.oracle.com/thread/3510766?start=0&tstart=0
If it still fails after that, call Oracle. I presume you have support...
Once rlm_sql_oracle is built and returning errors from Oracle, there's little more we can do. The errors come from Oracle, not from FreeRADIUS.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html