Re: Building rlm_sql_oracle
Maxim Denisov wrote: Has enybody successfully built freeradius 2.1.4 with instant client? Yes. It sometimes takes a bit of fighting, but it works. I have installed oracle instant client basic 10.2.0.4 + sqlplus + sdk for linux x86_64, everything from rpm. I can successfully connect with sqlplus64, paths are correct but when I execute configure in rlm_sql_oracle I am getting If configure doesn't work, don't worry. Just edit the file /rlm_sql_oracle/Makefile directly. The only magic I've found is 32/64-bit issues. You might have to link explicitly to a particular library, rather than using -l. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Building rlm_sql_oracle
Thank you for your reply. I alredy built it, the problem was in configure file logic - it tried to detect oracle version by looking for $ORACLE_HOME variable and if it is absent it mentioned that you have 8i. Also I didn't find where --with-oracle-include-dir used and I changed the pathes in configure file. Now I have successfully compiled freeradius with the following keys: ./configure --enable-shared --disable-static --with-gnu-ld --with-threads --with-thread-pool --disable-ltdl-install --without-rlm-sql_postgresql --without-rlm-sql_mysql --with-rlm-sql --with-rlm-sql_oracle --with-oracle-home-dir=/usr/lib/oracle/10.2.0.4/client64--with-oracle-lib-dir=/usr/lib/oracle/ 10.2.0.4/client64/lib --with-oracle-include-dir=/usr/include/oracle/ 10.2.0.4/client64 Everything works fine except oracle - radiusd is not linked to rlm_sql_oracle.so r...@truba:~/freeradius-server-2.1.4# ldd /usr/local/sbin/radiusd libfreeradius-radius-2.1.5.so = /usr/local/lib/ libfreeradius-radius-2.1.5.so (0x002a95579000) libnsl.so.1 = /lib64/libnsl.so.1 (0x00322bc0) libresolv.so.2 = /lib64/libresolv.so.2 (0x00322510) libpthread.so.0 = /lib64/tls/libpthread.so.0 (0x00322490) libcrypt.so.1 = /lib64/libcrypt.so.1 (0x00322b40) libltdl.so.3 = /usr/lib64/libltdl.so.3 (0x003ab670) libssl.so.4 = /lib64/libssl.so.4 (0x00322800) libcrypto.so.4 = /lib64/libcrypto.so.4 (0x00322790) libc.so.6 = /lib64/tls/libc.so.6 (0x003223e0) /lib64/ld-linux-x86-64.so.2 (0x003223c0) libdl.so.2 = /lib64/libdl.so.2 (0x00322430) libgssapi_krb5.so.2 = /usr/lib64/libgssapi_krb5.so.2 (0x003227c0) libkrb5.so.3 = /usr/lib64/libkrb5.so.3 (0x003227e0) libcom_err.so.2 = /lib64/libcom_err.so.2 (0x00322750) libk5crypto.so.3 = /usr/lib64/libk5crypto.so.3 (0x00322770) libz.so.1 = /usr/lib64/libz.so.1 (0x003224f0) r...@truba:~/freeradius-server-2.1.4# ldd /usr/local/lib/ libfreeradius-radius-2.1.5.so libc.so.6 = /lib64/tls/libc.so.6 (0x002a95698000) /lib64/ld-linux-x86-64.so.2 (0x00552000) Can anybody tell me what have I done wrong? 2009/5/14 Alan DeKok al...@deployingradius.com Maxim Denisov wrote: Has enybody successfully built freeradius 2.1.4 with instant client? Yes. It sometimes takes a bit of fighting, but it works. I have installed oracle instant client basic 10.2.0.4 + sqlplus + sdk for linux x86_64, everything from rpm. I can successfully connect with sqlplus64, paths are correct but when I execute configure in rlm_sql_oracle I am getting If configure doesn't work, don't worry. Just edit the file /rlm_sql_oracle/Makefile directly. The only magic I've found is 32/64-bit issues. You might have to link explicitly to a particular library, rather than using -l. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Building rlm_sql_oracle
Maxim Denisov wrote: Everything works fine except oracle - radiusd is not linked to rlm_sql_oracle.so It's not supposed to be. That's what dynamically loaded modules are for. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Building rlm_sql_oracle
Has enybody successfully built freeradius 2.1.4 with instant client? I have installed oracle instant client basic 10.2.0.4 + sqlplus + sdk for linux x86_64, everything from rpm. I can successfully connect with sqlplus64, paths are correct but when I execute configure in rlm_sql_oracle I am getting Have you tried/checked the ORACLE_HOME environment variable? I inslled instant-client from Debian packages, and it didn't set this env-var by default. -- damjan | дамјан This is my jabber ID -- dam...@bagra.net.mk -- not my mail address, it's a Jabber ID --^ :) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Building rlm_sql_oracle
I have exported it in order to avoid editing alot of configure script - as I understood it is one of the ways to detect oracle version. Now I've successfully compiled 2.1.6 with it but I had to specify path to my instant client SDK in CFLAGS, otherwise configure tried to locate it in preconfigured location ignoring --with-oracle-include-dir=$correct_path. 2009/5/14 Damjan gdam...@mail.net.mk Has enybody successfully built freeradius 2.1.4 with instant client? I have installed oracle instant client basic 10.2.0.4 + sqlplus + sdk for linux x86_64, everything from rpm. I can successfully connect with sqlplus64, paths are correct but when I execute configure in rlm_sql_oracle I am getting Have you tried/checked the ORACLE_HOME environment variable? I inslled instant-client from Debian packages, and it didn't set this env-var by default. -- damjan | дамјан This is my jabber ID -- dam...@bagra.net.mk -- not my mail address, it's a Jabber ID --^ :) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Building rlm_sql_oracle
I have figured out my problem. I forgot to enable sql in aaa methods - the config now located in sites-enabled directory, now everything works fine. Also it will be good if you fix --with-oracle-include-dir option in configure. Thank you for help. 2009/5/14 Alan DeKok al...@deployingradius.com Maxim Denisov wrote: Everything works fine except oracle - radiusd is not linked to rlm_sql_oracle.so It's not supposed to be. That's what dynamically loaded modules are for. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Building rlm_sql_oracle
Hi! Has enybody successfully built freeradius 2.1.4 with instant client? I have installed oracle instant client basic 10.2.0.4 + sqlplus + sdk for linux x86_64, everything from rpm. I can successfully connect with sqlplus64, paths are correct but when I execute configure in rlm_sql_oracle I am getting checking for oracle_init in -loracleclient... no configure: WARNING: oracle libraries not found. Use --with-oracle-lib-dir=path. I've unsuccessfully tried to specify correct paths in --with-oracle-lib-dir, $CFLAGS and $LDFLAGS but can't find whare oracle_init() located. Can anybody say where this function located? I have the folliwing rpms installed: [r...@truba rlm_sql_oracle]# rpm -qa | grep oracle oracle-instantclient-sqlplus-10.2.0.4-1 oracle-instantclient-basic-10.2.0.4-1 oracle-logos-1.1.1-3 oracle-instantclient-odbc-10.2.0.4-1 oracle-instantclient-devel-10.2.0.4-1 glade2-2.6.0-1.oracle Should I install anything else? - Regards, Maxim S. Denisov IP Studio, Inc. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html