freeradius + oracle for users

From: chabral <chabral_at_hotmail.com>
Date: Thu, 5 May 2005 22:55:30 -0300
Message-ID: <427ace96$0$79459$14726298@news.sunsite.dk>

Hi,
 I'm dealing trying to make freeradius (1.0.1) communicate with oracle 9i
(9.0.2.6) but with no luck at the moment.
 I sucessfully compiled the rlm_sql_oracle freeradius module, and also installed the oracle instant client. Doing an strace of the radiusd program I see that it finds all files and libraries, but I can't still make the connection.
Here's the relevant output of radiusd -X:

sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" rlm_sql (sql): Driver rlm_sql_oracle (module rlm_sql_oracle) loaded and linked
rlm_sql (sql): Attempting to connect to TR_RADIUS_at_192.168.32.32:/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.32.32)(PORT=1521)))(CONNECT_DATA=(SID=LIVEDB)(SERVER=DEDICATED)))

rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_oracle #0
rlm_sql_oracle: Couldn't init Oracle OCI environment (OCIEnvCreate())
rlm_sql (sql): Failed to connect DB handle #0
rlm_sql (sql): starting 1
rlm_sql (sql): starting 2
rlm_sql (sql): starting 3
rlm_sql (sql): starting 4
rlm_sql (sql): Failed to connect to any SQL server.

Module: Instantiated sql (sql)

I'm still getting the "Couldn't init Oracle OCI environment
(OCIEnvCreate())" error.

Can anyone give me a tip?
Thanks in advance,

--
chabral 

Received on Thu May 05 2005 - 20:55:30 CDT