Building DBD-Oracle on MacOS 10.8 with instantclient_11_2

Hello,

I would like to provide some feedback which may be useful for build of DBD-Oracle.


I basically wanted to avoid using DYLD_LIBRARY_PATH  because the OS complains whenever an suid command is executed, such as ps(1).

So I did a bit of RTFM and googling   that I would like to share, as it maye be useful for others too :-)



1. I patched the shared libs and the executables using a small variation of the script found at this location
     http://blog.caseylucas.com/2013/03/03/oracle-sqlplus-and-instant-client-on-mac-osx-without-dyld_library_path/
     My change is basically using @loader_path for the dylibs and @executable_path for the actual executables.


2.  Added the 2 symlinks as usual:

 ./libclntsh.dylib -> libclntsh.dylib.11.1
 ./libocci.dylib -> libocci.dylib.11.1


3.  Make sure that instantclient_11_2 is in my PATH  (basically I should be able to launch sqlplus ) and build as usual:
	perl Makefile.PL   && make

4. I noticed that the produced bundle fails to load the libclnt.dylib  and checking with otool -L revealed that the LD_RUN_PATH and -R options are not honored on OS/X 10.8

$ perl -w -Mblib -MDBD::Oracle -le 1
Can't load '/Users/phil/X1/DBD-Oracle-1.58/blib/arch/auto/DBD/Oracle/Oracle.bundle' for module DBD::Oracle: dlopen(/Users/phil/X1/DBD-Oracle-1.58/blib/arch/auto/DBD/Oracle/Oracle.bundle, 1): Library not loaded: libclntsh.dylib.11.1
  Referenced from: /Users/phil/X1/DBD-Oracle-1.58/blib/arch/auto/DBD/Oracle/Oracle.bundle
  Reason: image not found at /usr/local/ActivePerl-5.16/lib/DynaLoader.pm line 195.
 at -e line 0.
Compilation failed in require.
BEGIN failed--compilation aborted.


So, I used otool and checked the bundle:

$ otool -L /Users/phil/X1/DBD-Oracle-1.58/blib/arch/auto/DBD/Oracle/Oracle.bundle
/Users/phil/X1/DBD-Oracle-1.58/blib/arch/auto/DBD/Oracle/Oracle.bundle:
	libclntsh.dylib.11.1 (compatibility version 0.0.0, current version 0.0.0)
	/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 169.3.0)

Modifying the bundle before installation :

install_name_tool \
	-change libclntsh.dylib.11.1 @rpath/libclntsh.dylib.11.1 \
	-add_rpath /usr/local/instantclient_11_2 \
	blib/arch/auto/DBD/Oracle/Oracle.bundle

And now it works :-)

$ env PERL_DL_NON_LAZY=1 perl -w -M5.016  -MDBI -Mblib -MDBD::Oracle -le "DBI->connect('dbi:Oracle:host=localhost;port=1521;sid=orcl;', 'system', 'oracle') && say 'it works'";
it works

This leaves me under the (bad) impression that LD_RUN_PATH is ignored on Mountain Lion (10.8.3) ?
If this is the case, maybe some changes required in MakeMaker...

But anyway, thanks to install_name_tool  I have a working DBD::Oracle that doesn't require DYLD_LIBRARY_PATH  !


I hope this information may be useful -- eventually as an addition to this document http://search.cpan.org/dist/DBD-Oracle/lib/DBD/Oracle/Troubleshooting/Macos.pod

Best regards,
/Philippe.


#======== Patch script looks like this now: =============

#!/bin/sh
# script to change the dynamic lib paths and ids for oracle instant client
# exes and libs

# proces all the executable files in this directory
for exe in sqlplus adrci genezi uidrvci
do
    echo adjusting executable $exe
    baseexe=`basename $exe`
    otool -L $exe | awk '/oracle/ {print $1}' | while read lib
    do
        echo adjusting lib $lib
        baselib=`basename $lib`
        if [ "$baseexe" = "$baselib" ]
        then
            echo changing id to $baselib for $exe
            install_name_tool -id $baselib $exe
        else
            echo changing path id for $lib in $exe
            install_name_tool -change $lib @executable_path/$baselib $exe
        fi
    done
done

for exe in *dylib* 
do
    echo adjusting executable $exe
    baseexe=`basename $exe`
    otool -L $exe | awk '/oracle/ {print $1}' | while read lib
    do
        echo adjusting lib $lib
        baselib=`basename $lib`
        if [ "$baseexe" = "$baselib" ]
        then
            echo changing id to $baselib for $exe
            install_name_tool -id $baselib $exe
        else
            echo changing path id for $lib in $exe
            install_name_tool -change $lib @loader_path/$baselib $exe
        fi
    done
done

#----------------------------------------------------------