Skip Menu |
 

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 70785
Status: resolved
Priority: 0/
Queue: DBD-Oracle

People
Owner: Nobody in particular
Requestors: HMBRAND [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: Critical
Broken in: 1.30
Fixed in: (no value)



Subject: [PATCH] Doesn't build (with Instant Client) when ORACLE_HOME is a symbolic link
Download (untitled) / with headers
text/plain 4.5k
Just passing *all* the information, hoping that might better explain the problem ... $ cpan DBD::Oracle : : CPAN: File::Temp loaded ok (v0.22) CPAN: Parse::CPAN::Meta loaded ok (v1.4401) CPAN: CPAN::Meta loaded ok (v2.112150) CPAN: Module::CoreList loaded ok (v2.55) CPAN.pm: Building P/PY/PYTHIAN/DBD-Oracle-1.30.tar.gz Using DBI 1.616 (for perl 5.014001 on i686-linux-64int-ld) installed in /pro/lib/perl5/site_perl/5.14.1/i686-linux-64int-ld/auto/DBI/ Configuring DBD::Oracle for perl 5.014001 on linux (i686-linux-64int-ld) Remember to actually *READ* the README file! Especially if you have any problems. Installing on a linux, Ver#2.6 Using Oracle in /pro/oracle/v11.2 DEFINE _SQLPLUS_RELEASE = "1102000200" (CHAR) Oracle version 11.2.0.2 (11.2) Unable to locate an oracle.mk or other suitable *.mk file in your Oracle installation. (I looked in /pro/oracle/v11.2/rdbms/demo/demo_xe.mk /pro/oracle/v11.2/rdbms/ demo/demo_rdbms32.mk under /pro/oracle/v11.2) The oracle.mk (or demo_rdbms.mk) file is part of the Oracle RDBMS product. You need to build DBD::Oracle on a system which has one of these Oracle components installed. (Other *.mk files such as the env_*.mk files will not work.) Alternatively you can use Oracle Instant Client. In the unlikely event that a suitable *.mk file is installed somewhere non-standard you can specify where it is using the -m option: perl Makefile.PL -m /path/to/your.mk See the appropriate README file for your OS for more information and some alternatives. at Makefile.PL line 1111. Warning: No success on command[/pro/bin/perl Makefile.PL] PYTHIAN/DBD-Oracle-1.30.tar.gz /pro/bin/perl Makefile.PL -- NOT OK Running make test Make had some problems, won't test Running make install Make had some problems, won't install Could not read metadata file. Falling back to other methods to determine prerequisites $ perl -MV=DBD::Oracle DBD::Oracle /pro/lib/perl5/site_perl/5.14.1/i686-linux-64int-ld/DBD/ Oracle.pm: 1.28 $ rpm -qa | grep -i oracle oracle-instantclient11.2-tools-11.2.0.2.0-1.i386 oracle-instantclient11.2-basic-11.2.0.2.0-1.i386 oracle-instantclient11.2-jdbc-11.2.0.2.0-1.i386 mono-data-oracle-2.8.2-0.2.3.i586 oracle-instantclient11.2-devel-11.2.0.2.0-1.i386 oracle-instantclient11.2-odbc-11.2.0.2.0-1.i386 oracle-instantclient11.2-precomp-11.2.0.2.0-1.i386 oracle-instantclient11.2-sqlplus-11.2.0.2.0-1.i386 $ ls -l /pro/oracle total 0 lrwxrwxrwx 1 merijn users 27 Sep 6 2010 v11 -> /usr/lib/oracle/11.2/ client lrwxrwxrwx 1 merijn users 3 Sep 15 2010 v11.2 -> v11 $ ls -l v11/ total 8 lrwxrwxrwx 1 root root 13 Sep 7 14:14 admin -> network/admin drwxr-xr-x 2 root root 4096 Sep 7 13:58 bin drwxr-xr-x 3 root root 4096 Sep 7 13:58 lib lrwxrwxrwx 1 root root 10 Sep 7 14:13 network -> ../network $ echo $LD_LIBRARY_PATH/ /pro/oracle/v11.2/lib/ $ echo $ORACLE_HOME /pro/oracle/v11.2 Even when I unset $ORACLE_HOME, Makefile.PL is friendly enough to put it back to what it was: Trying to find an ORACLE_HOME Your LD_LIBRARY_PATH env var is set to '/pro/oracle/v11.2/lib' Found /pro/oracle/v11.2 WARNING: Setting ORACLE_HOME env var to /pro/oracle/v11.2 for you. WARNING: If these tests fail you may have to set ORACLE_HOME yourself! Installing on a linux, Ver#2.6 Using Oracle in /pro/oracle/v11.2 DEFINE _SQLPLUS_RELEASE = "1102000200" (CHAR) Oracle version 11.2.0.2 (11.2) If I set $ORACLE_HOME to the *real* path, build passes, hence the working fix (also attached): --8<--- --- a/Makefile.PL 2011-08-26 17:25:36.000000000 +0200 +++ b/Makefile.PL 2011-09-07 15:03:07.691000109 +0200 +0200 @@ -135,7 +135,7 @@ Remember to actually *READ* the README f my $ORACLE_ENV = ($os eq 'VMS') ? 'ORA_ROOT' : 'ORACLE_HOME'; my $OH = $ENV{$ORACLE_ENV} || ''; -$OH = win32_oracle_home($OH) if ($os eq 'MSWin32') or ($os =~ /cygwin/ i); +$OH = win32_oracle_home($OH) if ($os eq 'MSWin32') or ($os =~ /cygwin/ i); $OH = unixify $OH if $os eq 'VMS'; $OH =~ s:/$::; @@ -153,6 +153,7 @@ if (!$OH) { print "WARNING: If these tests fail you may have to set ORACLE_HOME yourself!\n"; sleep 5; } +-l $OH and $OH = Cwd::abs_path ($OH); # Oracle really dislikes symbolic links die qq{ The $ORACLE_ENV environment variable value ($OH) is not valid. It must be set to hold the path to an Oracle installation directory -->8--- After that, almost all tests pass \o/ It might be important to know that my database is 11.2/US7ASCII: t/58object.t ............ 1/65 t/58object.t ............ Dubious, test returned 4 (wstat 1024, 0x400) Failed 4/65 subtests
Subject: Makefile.PL.diff
Download Makefile.PL.diff
text/x-diff 832b
--- a/Makefile.PL 2011-08-26 17:25:36.000000000 +0200 +++ b/Makefile.PL 2011-09-07 15:03:07.691000109 +0200 @@ -135,7 +135,7 @@ Remember to actually *READ* the README f my $ORACLE_ENV = ($os eq 'VMS') ? 'ORA_ROOT' : 'ORACLE_HOME'; my $OH = $ENV{$ORACLE_ENV} || ''; -$OH = win32_oracle_home($OH) if ($os eq 'MSWin32') or ($os =~ /cygwin/i); +$OH = win32_oracle_home($OH) if ($os eq 'MSWin32') or ($os =~ /cygwin/i); $OH = unixify $OH if $os eq 'VMS'; $OH =~ s:/$::; @@ -153,6 +153,7 @@ if (!$OH) { print "WARNING: If these tests fail you may have to set ORACLE_HOME yourself!\n"; sleep 5; } +-l $OH and $OH = Cwd::abs_path ($OH); # Oracle really dislikes symbolic links die qq{ The $ORACLE_ENV environment variable value ($OH) is not valid. It must be set to hold the path to an Oracle installation directory
Applied Tux's patch to trunk and tested. Martin -- Martin J. Evans Wetherby, UK
Patch also absorbed into the github repo. Will be part of next release (v1.31_0). Thanks to all!
part of v1.32


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.