All the Perl that's Practical to Extract and Report
use Perl Log In
jdavidb (1361)
(email not shown publicly)
http://voiceofjohn.blogspot.com/
J. David Blackstone has a Bachelor of Science in Computer Science and Engineering and nine years of experience at a wireless telecommunications company, where he learned Perl and never looked back. J. David has an advantage in that he works really hard, he has a passion for writing good software, and he knows many of the world's best Perl programmers.
LD_LIBRARY_PATH, part 2
As I remarked to Uri about my LD_LIBRARY_PATH problem, the real solution is that Oracle.so needs to get built properly. Today I discovered how to do that (shortly after remarking to Uri, in fact
The good news is I don't have to do any re-execing. As I got this working I feared that I would still have a mess because the environment on this box naturally sets LD_LIBRARY_PATH to what I do not want it to be (and in case you are unaware, YOU SHOULD NOT DO THAT! ) and I thought that would override it even if the correct library directory was compiled into Oracle.so. But it doesn't seem to. ldd finds the right library in the right directory, and a simple DBI script now works perfectly with no monkeying around with that awful variable.
So, here are the steps:
- Run Makefile.PL.
- Hand edit Makefile and mk.pm. Look for every instance of an Oracle library directory. The directory names will include the Oracle version number at some point (10.1.0 here and now), so search for every instance of that. For any directory that includes that version number, if it includes a component named "lib" rename it to "lib32." The README.aix.txt file includes some instructions for doing this, interestingly enough, and I'd been using those, but unfortunately their shortcut doesn't get every single instance of this. And a more straightforward 1,$s/lib/lib32/g would catch instances that should not changed because they are not Oracle directories.
- make, make test, make install, and life is good.
--Donald E. Knuth
This seems to cover it all (Score:2)
J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers
Instant client (Score:2)
Another observation: use Oracle's instant client, and put it in a directory that doesn't look anything like the lib/lib32 confusion, and you'll also get around this much easier. Unfortunately, instant client appears to require setting LD_LIBRARY_PATH.
J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers
Re:Instant client (Score:2)
In order to compile Oracle.so such that LD_LIBRARY_PATH is not required, rerun the gcc line that created Oracle.so and add "-lnnz10" to the end. Oracle created libclntsh.so such that it requires LD_LIBRARY_PATH in order to find libnnz10. Adding this option tells the linker to go ahead and link libnnz10 directly into Oracle.so, which enables the runtime linker to find it without LD_LIBRARY_PATH telling it where to look.
Sigh...
J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers