comment on

To debug an issue, I need to install an older DBI and DBD::Oracle.

I thought I'd done everything correctly (using PREFIX after the perl MakeFile.PL call, but when I try to run the app that is using the new libraries (using a BEGIN block to add the custom lib dirs), I get this error:

DBD::Oracle object version 1.74 does not match bootstrap parameter 1.64 at .../DynaLoader.pm line 223

Dumping @INC in DynaLoader, I see that the custom lib dirs aren't in it. A quick scan of similar reports on Google finds me an explanation of how to reinstall a single DBD::Oracle, but how do I fix this so that I can test my app with the old version of DBD::Oracle while leaving the current in place?

Edit: more info...

I installed v1.64 of DBD::Oracle from a tar.gz download from CPAN:

#> perl MakeFile.PL PREFIX=/path/to/local/lib
#>make && make test
[download]

There were test errors. On closer examination, they appeared to just be miscounts of number of tests, so I installed the module:

make install

In looking in the local lib dir, I see that the DBD::Oracle code is there - both DBI.so and DBD/Oracle/Oracle.so

I wrote this test script:

#!/usr/bin/perl
BEGIN {
    use lib '/path/to/local/lib/lib64/perl5';
}

use strict;
use warnings;
use v5.010;
use Data::Dumper 'Dumper';
use DBI;

say Dumper(\@INC,\%INC);
require DBD::Oracle;
[download]

(the use/require DBI/DBD are copied from the app I'm debugging. The output I got was:

$VAR1 = [
          '/path/to/local/lib/perl5lib/lib64/perl5',
          '/usr/local/lib64/perl5',
          '/usr/local/share/perl5',
          '/usr/lib64/perl5/vendor_perl',
          '/usr/share/perl5/vendor_perl',
          '/usr/lib64/perl5',
          '/usr/share/perl5',
          '.'
        ];
$VAR2 = {
          'warnings/register.pm' => '/usr/share/perl5/warnings/registe
+r.pm',
          'XSLoader.pm' => '/usr/lib64/perl5/XSLoader.pm',
          'List/Util.pm' => '/usr/lib64/perl5/List/Util.pm',
          'warnings.pm' => '/usr/share/perl5/warnings.pm',
          'Config_git.pl' => '/usr/lib64/perl5/Config_git.pl',
          'DBI.pm' => '/path/to/local/lib/perl5/DBI.pm',
          'Config.pm' => '/usr/lib64/perl5/Config.pm',
          'Carp.pm' => '/usr/share/perl5/Carp.pm',
          'bytes.pm' => '/usr/share/perl5/bytes.pm',
          'Scalar/Util.pm' => '/usr/lib64/perl5/Scalar/Util.pm',
          'Exporter/Heavy.pm' => '/usr/share/perl5/Exporter/Heavy.pm',
          'strict.pm' => '/usr/share/perl5/strict.pm',
          'Exporter.pm' => '/usr/share/perl5/Exporter.pm',
          'vars.pm' => '/usr/share/perl5/vars.pm',
          'constant.pm' => '/usr/share/perl5/constant.pm',
          'Config_heavy.pl' => '/usr/lib64/perl5/Config_heavy.pl',
          'overload.pm' => '/usr/share/perl5/overload.pm',
          'AutoLoader.pm' => '/usr/share/perl5/AutoLoader.pm',
          'lib.pm' => '/usr/lib64/perl5/lib.pm',
          'DynaLoader.pm' => '/usr/lib64/perl5/DynaLoader.pm',
          'Data/Dumper.pm' => '/usr/lib64/perl5/Data/Dumper.pm',
          'feature.pm' => '/usr/share/perl5/feature.pm'
        };
 
DBD::Oracle object version 1.74 does not match bootstrap parameter 1.6
+4 at /usr/lib64/perl5/DynaLoader.pm line 223.
Compilation failed in require at tmp.pl line 14.
[download]

So, that use lib statement doesn't appear to be being honored by DynaLoader.

Edit 2:

I tried INSTALL_BASE instead of PREFIX and it appears to have worked! Anyone know a deep reason why that should be? The MakeMaker docs don't appear to clarify.

In reply to Trouble getting a local DBD::Oracle to work (Dynaloader!) by cLive ;-)

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


The stupid question is the question not asked
	PerlMonks