Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)
Hi! There's a newer linux-oracle-instantclient-sdk available in the ports (10.2.0.3), and maybe it helps to compile and link a newer DBD::Oracle. I have that one (actually, those three), but they are nine years old as well: 20061115_5 is coded into the ports name. The API did not change that much, so I guess it might work to use 10.2.0.3 to update the DBD::Oracle port to 1.74. I'm currently upgrading my test host from perl5.20 to perl5.22, so it will take some time until I can experiment with 1.74. -- p...@opsec.eu+49 171 3101372 5 years to go !
Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)
According to Kurt Jaeger dbi-us...@opsec.eu on Thu, 06/04/15 at 09:38: My guess: no-one had the need, time and skills to fix it. There's a newer linux-oracle-instantclient-sdk available in the ports (10.2.0.3), and maybe it helps to compile and link a newer DBD::Oracle. I have that one (actually, those three), but they are nine years old as well: 20061115_5 is coded into the ports name. And there's an newer version (12.1.0.2.0) pending commit: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=157544 Thanks! :-) Regards, web... -- /\ ASCII RIBBON / William Bulley \ / CAMPAIGN AGAINST / XHTML E-MAIL AND / E-MAIL: w...@umich.edu / \ LISTSERV POSTINGS / 72 characters width template -|
Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)
Hi! What is confusing to me is why FreeBSD _still_ contains DBD::Oracle 1.19 in their ports tree! After all these years! Because: DBD::Oracle no longer supports Oracle client versions before 9.2 Try a version before 1.25 for 9 and 1.18 for 8! at ./Makefile.PL line 271. and there is no oracle9-client port on FreeBSD. -- p...@opsec.eu+49 171 3101372 5 years to go !
Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)
Hi! There's a newer linux-oracle-instantclient-sdk available in the ports (10.2.0.3), and maybe it helps to compile and link a newer DBD::Oracle. I have that one (actually, those three), but they are nine years old as well: 20061115_5 is coded into the ports name. The API did not change that much, so I guess it might work to use 10.2.0.3 to update the DBD::Oracle port to 1.74. I'm currently upgrading my test host from perl5.20 to perl5.22, so it will take some time until I can experiment with 1.74. It looks promising, but: The FreeBSD ld does not like the SYSV shared lib to link with: LD_RUN_PATH=/compat/linux/usr/lib/oracle/10.2.0.3/client/lib cc -shared -L/usr/ports/lang/perl5.22/work/perl-5.22.0 -L/usr/local/lib/perl5/5.22/mach/CORE -Wl,-rpath=/usr/local/lib/perl5/5.22/mach/CORE -lperl -L/usr/local/lib -fstack-protector Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.so -L/compat/linux/usr/lib/oracle/10.2.0.3/client/lib -L/usr/local/home/pi/myp/databases/p5-DBD-Oracle/work/DBD-Oracle-1.74/../.. -locci -lclntsh -lpthread /usr/bin/ld: skipping incompatible /compat/linux/usr/lib/oracle/10.2.0.3/client/lib/libocci.so when searching for -locci /usr/bin/ld: cannot find -locci cc: error: linker command failed with exit code 1 (use -v to see invocation) file /compat/linux/usr/lib/oracle/10.2.0.3/client/lib/libocci.so libocci.so.10.1: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), dynamically linked, not stripped and I do not have a non-shared lib to link against. Any ideas ? Can a SYSV shared lib be transformed into some other shlib ? -- p...@opsec.eu+49 171 3101372 5 years to go !
Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)
According to Kurt Jaeger dbi-us...@opsec.eu on Thu, 06/04/15 at 02:50: DBD::Oracle no longer supports Oracle client versions before 9.2 Try a version before 1.25 for 9 and 1.18 for 8! at ./Makefile.PL line 271. and there is no oracle9-client port on FreeBSD. Thanks. That makes sense. What doesn't make sense and begs the following question is: Why isn't there an oracle9-client port for FreeBSD? Is this an Oracle issue? Is this a FreeBSD issue? Or what? Thanks! Regards, web... -- /\ ASCII RIBBON / William Bulley \ / CAMPAIGN AGAINST / XHTML E-MAIL AND / E-MAIL: w...@umich.edu / \ LISTSERV POSTINGS / 72 characters width template -|
Re: DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)
Hi! According to Kurt Jaeger dbi-us...@opsec.eu on Thu, 06/04/15 at 02:50: DBD::Oracle no longer supports Oracle client versions before 9.2 Try a version before 1.25 for 9 and 1.18 for 8! at ./Makefile.PL line 271. and there is no oracle9-client port on FreeBSD. Thanks. That makes sense. What doesn't make sense and begs the following question is: Why isn't there an oracle9-client port for FreeBSD? Is this an Oracle issue? Is this a FreeBSD issue? Or what? Thanks! My guess: no-one had the need, time and skills to fix it. There's a newer linux-oracle-instantclient-sdk available in the ports (10.2.0.3), and maybe it helps to compile and link a newer DBD::Oracle. And there's an newer version (12.1.0.2.0) pending commit: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=157544 -- p...@opsec.eu+49 171 3101372 5 years to go !
DBD::Oracle 1.19 in FreeBSD Ports (was Re: help with odd DBI perpare/execute errors)
in message 20150603172207.gf2...@itcom245.staff.itd.umich.edu, wrote William Bulley thusly... ... My focus now is trying to install DBD::Oracle 1.74 from CPAN (from April of 2014) on my system. ... What is confusing to me is why FreeBSD _still_ contains DBD::Oracle 1.19 in their ports tree! After all these years! Since it's maintainership was passed to perl@freebsd ... r296145 | skv | 2012-05-07 05:42:51 -1000 (Mon, 07 May 2012) | 4 lines Pass maintainership of almost of my p5-* ports to perl@. (I hope updating of them will be improved). ... DBD::Oracle has not been updated. (The updates that are there are related to Ports infrastructure build/install.) Somebody needs to file a PR to update the port. (Tsk, tsk [0,1].) - parv [0] http://www.freebsd.org/doc/en_US.ISO8859-1/books/porters-handbook/ [1] https://bugs.freebsd.org/bugzilla/enter_bug.cgi?component=Individual%20Port%28s%29product=Ports%20%26%20Packages --