rlm_sql_oracle: Oracle logon failed: 'unknown'

Kyuyoung Kim jadebrill at gmail.com
Fri Nov 13 08:48:09 CET 2015


    
Hello,
 
I have a issue to use FreeRADIUS with Oracle DB(rlm_sql_oracle).
I can see errors on log files. I don't know what is problem.
I tried to find how can I fix it. but, I couldn't why.
How can I fix this issue?
Help me, please!!
 
Thank you.
 
I'm using CentOS 7, FreeRADIUS is 3.0.10.
 
Env Variables are
 
NLS_LANG=.AL32UTF8
ORACLE_HOME=/usr/lib/oracle/11.2/client64
TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin
LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib:/usr/local/lib64
 
This is log
 
Fri Nov 13 16:04:58 2015 : Info: Found debugger attached
Fri Nov 13 16:04:58 2015 : Info: rlm_sql (oracle): Driver rlm_sql_oracle (module rlm_sql_oracle) loaded and linked
Fri Nov 13 16:04:58 2015 : Info: rlm_sql (oracle): Attempting to connect to database "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.xx.xx)(PORT=1521))(CONNECT_DATA=(SID=XXXXDB)))"
Fri Nov 13 16:04:58 2015 : Info: rlm_sql (oracle): Opening additional connection (0), 1 of 128 pending slots used
Fri Nov 13 16:04:58 2015 : Error: rlm_sql_oracle: Oracle logon failed: 'unknown'
Fri Nov 13 16:04:58 2015 : Error: rlm_sql (oracle): Opening connection failed (0)
Fri Nov 13 16:04:58 2015 : Error: /etc/raddb/mods-enabled/sql.oracle[20]: Instantiation failed for module "oracle"


More information about the Freeradius-Users mailing list