Ilia, No, I were'nt doing that! That seems to have solved the problem. I'd not found that tip on the doucmentation. Now I'm having an invalid user oracle error, but I'll see it with the DBA. Thanks a lot, -- chabral Message: 8 Date: Sat, 17 Sep 2005 11:47:45 +0600 (YEKST) From: Ilia Chipitsine <ilia@paramon.ru> Subject: Re: Problems with oracle To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Message-ID: <20050917114703.M40140@office.paramon.ru> Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed using oracle require setting enviroment variable ORACLE_HOME before you start radiusd, did You do that ? Cheers, Ilia Chipitsine
Hi, I'm trying to use freeradius 1.0.1 with oracle 9i. I successfully (i think) compiled freeradius with oracle support. I've the files:
/usr/local/etc/raddb/oraclesql.conf /usr/local/lib/rlm_sql_oracle-1.0.1.so /usr/local/lib/rlm_sql_oracle.so /usr/local/lib/rlm_sql_oracle.la /usr/local/lib/rlm_sql_oracle.a
The problem is when I start "radiusd -X" I see the lines:
rlm_sql (sql): Driver rlm_sql_oracle (module rlm_sql_oracle) loaded and linked rlm_sql (sql): Attempting to connect to
TR_RADIUS@oracle:1521/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1521)))(CONNECT_DATA=(SID=TESTSID)(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)
Any help?
-- chabral
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html