I have attached an ebuild for libsqlora8, which is a simple C-library to access Oracle databases via the OCI interface. The homepage is: http://www.poitschke.de/libsqlora8/index_noframe.html I suggest that it be placed in dev-db/libsqlora8. The dependencies are: Oracle 8 client libraries. Cheers, Josh
Created attachment 22098 [details] dev-db/libsqlora8-2.2.11.ebuild (New Package)
wanna try this ?
I'll run this through when I test it at my work box, where I have Oracle installed. FYI don't specify arches other than those you have yourself tested. And even then initial ebuild commits should be in unstable for those arches. I'm going to assume you've only tested on x86 so keywords should ONLY be "~x86"
I'm getting this during the configure stage: -- checking Oracle version >= 8.0... 9.0.1.0 checking linking with oracle shared libs (-lclntsh -ldl -lm -lpthread) works... no Cannot link with oracle !!! LDFLAGS=-L/opt/oracle/product/9.0.1/lib -Wl,-R/opt/oracle/product/9.0.1/lib -Wl,-R/usr/lib LIBS=-lclntsh -ldl -lm -lpthread -- My $ORACLE_HOME is /opt/oracle/product/9.0.1, so that appears to be correct. This happens with both pthreads and orathreads.
Don, Do you have Oracle 8 installed anywhere? This library is meant for Oracle 8, and I would be kind of surprised to see it work with Oracle 9. I would recommend checking to see whether the libclntsh.so library file exists in /opt/oracle/product/9.0.1/lib. Like I said, this seems to be an Oracle 9 issue.
Sorry I didn't get back right away. No all of my boxes are Oracle 9 (9.0.1 and 9.2.0.4). What I might do in the meantime is put this ebuild into portage and mask it. You can unmask it on your machine via /etc/portage/package.unmask and let me know if it works alright for you. Then I'll unmask it globally.
Also this probably will go into dev-libs and not dev-db, since it appears to be libraries and not an actualy application.
OK dev-libs/libsqlora8 is checked into portage and is hard-masked. There are still some things I need to play with. Main hurdle for me is that I don't have an Oracle8 linux box. :p
Josh can you verify if this works for you? If so I'll unmask and close this bug.
Yes: : jmglov@jglover; qpkg -I -i libsqlora dev-db/libsqlora8-2.2.11 * libsqlora8 is simple C-library to access Oracle databases via the OCI interface [ http://www.poitschke.de/libsqlora8/index_noframe.html ] I have used it on my box successfully.
Great to hear.
Created attachment 33940 [details] dev-libs/libsqlora8-2.2.11.ebuild (Bug Fix) Maybe something in Portage changed, but when I tried this ebuild recently, it did not work. The issue was that I was tweaking LD_LIBRARY_PATH in pkg_setup(), so it "went out of scope" by src_compile(). This is fixed now. Don, do you mind if I take over maintaining this ebuild, now that I am a developer? Since I actually use it, I thought I might be ideal. :)
Last release is 2.3.3 from 2005... Either find a maintainer, or if you want to maintain it yourself, feel free to reopen with updated ebuild and join project sunrise, details here: http://www.gentoo.org/proj/en/sunrise Thanks. WONTFIX meanwhile.