Re: DBD:Oracle compilation failure

On 19/03/12 22:56, J.V. wrote:
> I am trying to compile DBD Oracle under cygwin and I get the following error message: (any ideas?)
>
> What is broke?
>
> I'm on cygwin / Window 7
>
> ---
> Using DBI 1.618 (for perl 5.010001 on i686-cygwin-thread-multi-64int) installed in /usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBI/
>
> Configuring DBD::Oracle for perl 5.010001 on cygwin (i686-cygwin-thread-multi-64int)
>
> Remember to actually *READ* the README file! Especially if you have any problems.
>
> Installing on a cygwin, Ver#1.7
> Using Oracle in c:/apps/oracle/oracle11g/product/11.2.0/dbhome_1
> DEFINE _SQLPLUS_RELEASE = "1102000100" (CHAR)
> Oracle version 11.2.0.1 (11.2)
> Found OCI directory
> Using OCI directory 'OCI'
>
> client_version=11.2
>
>
> DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DORA_OCI_102 -DORA_OCI_112
>
>
> Checking for functioning wait.ph
>
>
> System: perl5.010001 cygwin_nt-5.1 reini 1.7.5(0.22553) 2010-04-12 19:07 i686 cygwin
> Compiler: gcc-4 -O3 -DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -g3 -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include
> Linker: /usr/bin/ld
> Sysliblist:
>
>
> WARNING: If you have problems you may need to rebuild perl with -Uusemymalloc.
> LD_RUN_PATH=c:/apps/oracle/oracle11g/product/11.2.0/dbhome_1/lib:c:/apps/oracle/oracle11g/product/11.2.0/dbhome_1/rdbms/lib
> Using DBD::Oracle 1.42.
> Using DBD::Oracle 1.42.
> Using DBI 1.618 (for perl 5.010001 on i686-cygwin-thread-multi-64int) installed in /usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBI/
> Writing Makefile for DBD::Oracle
>
> *** If you have problems...
> read all the log printed above, and the README and README.help.txt files.
> (Of course, you have read README by now anyway, haven't you?)
>
> Skip blib/lib/DBD/Oracle.pm (unchanged)
> Skip blib/lib/oraperl.ph (unchanged)
> Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
> Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
> Skip blib/lib/Oraperl.pm (unchanged)
> Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
> Skip blib/lib/DBD/Oracle/Troubleshooting.pm (unchanged)
> Skip blib/lib/DBD/Oracle/Object.pm (unchanged)
> Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
> Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged)
> gcc-4 -c -Ic:/apps/oracle/oracle11g/product/11.2.0/dbhome_1/OCI/include -Ic:/apps/oracle/oracle11g/product/11.2.0/dbhome_1/rdbms/demo -I/usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBI -DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -g3 -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -DUSEIMPORTLIB -O3 -DVERSION=\"1.42\" -DXS_VERSION=\"1.42\" "-I/usr/lib/perl5/5.10/i686-cygwin/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DORA_OCI_102 -DORA_OCI_112 Oracle.c
> gcc-4 -c -Ic:/apps/oracle/oracle11g/product/11.2.0/dbhome_1/OCI/include -Ic:/apps/oracle/oracle11g/product/11.2.0/dbhome_1/rdbms/demo -I/usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBI -DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -g3 -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -DUSEIMPORTLIB -O3 -DVERSION=\"1.42\" -DXS_VERSION=\"1.42\" "-I/usr/lib/perl5/5.10/i686-cygwin/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DORA_OCI_102 -DORA_OCI_112 dbdimp.c
> dbdimp.c: In function ‘dbd_rebind_ph_char’:
> dbdimp.c:2587:20: warning: cast from pointer to integer of different size
> dbdimp.c: In function ‘dbd_rebind_ph_xml’:
> dbdimp.c:2785:17: warning: cast to pointer from integer of different size
> gcc-4 -c -Ic:/apps/oracle/oracle11g/product/11.2.0/dbhome_1/OCI/include -Ic:/apps/oracle/oracle11g/product/11.2.0/dbhome_1/rdbms/demo -I/usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBI -DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -g3 -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -DUSEIMPORTLIB -O3 -DVERSION=\"1.42\" -DXS_VERSION=\"1.42\" "-I/usr/lib/perl5/5.10/i686-cygwin/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DORA_OCI_102 -DORA_OCI_112 oci8.c
> oci8.c: In function ‘ora_blob_read_mb_piece’:
> oci8.c:1786:4: warning: format ‘%lu’ expects type ‘long unsigned int’, but argument 6 has type ‘ub4’
> rm -f blib/arch/auto/DBD/Oracle/Oracle.dll
> LD_RUN_PATH="c:/apps/oracle/oracle11g/product/11.2.0/dbhome_1/lib:c:/apps/oracle/oracle11g/product/11.2.0/dbhome_1/rdbms/lib" g++-4 --shared -Wl,--enable-auto-import -Wl,--export-all-symbols -Wl,--stack,8388608 -Wl,--enable-auto-image-base -L/usr/local/lib -fstack-protector Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.dll \
> /usr/lib/perl5/5.10/i686-cygwin/CORE/cygperl5_10.dll -L/c/downloads/ora2pg/DBD-Oracle-1.42 -loci \
>
> chmod 755 blib/arch/auto/DBD/Oracle/Oracle.dll
> test -s Oracle.bs && cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs && \
> chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
> Makefile:517: recipe for target `blib/arch/auto/DBD/Oracle/Oracle.dll' failed
> make: [blib/arch/auto/DBD/Oracle/Oracle.dll] Error 1 (ignored)
> Manifying blib/man3/DBD.Oracle.Troubleshooting.3pm
> Manifying blib/man3/DBD.Oracle.3pm
> Manifying blib/man3/DBD.Oracle.Object.3pm
> Manifying blib/man3/DBD.Oraperl.3pm
> Manifying blib/man3/DBD.Oracle.GetInfo.3pm
> PERL_DL_NONLAZY=1 /usr/bin/perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
> t/000-report-versions.t ... Test::More version 0.94 required--this is only version 0.92 at t/000-report-versions.t line 4.

That is a bug. DBD::Oracle says it needs Test::More 0.90 and that script requires 0.94. Yanick did you really need 0.94? You could report this on rt.cpan.org.

> BEGIN failed--compilation aborted at t/000-report-versions.t line 4.
> t/000-report-versions.t ... Dubious, test returned 255 (wstat 65280, 0xff00)
> No subtests run
> t/00versions.t ............ Can't load '/c/downloads/ora2pg/DBD-Oracle-1.42/blib/arch/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: No such file or directory at /usr/lib/perl5/5.10/i686-cygwin/DynaLoader.pm line 200.
> at t/00versions.t line 10
> Compilation failed in require at t/00versions.t line 10.
> BEGIN failed--compilation aborted at t/00versions.t line 10.
> # Looks like your test exited with 2 before it could output anything.
> t/00versions.t ............ Dubious, test returned 2 (wstat 512, 0x200)
> Failed 2/2 subtests
> t/01base.t ................ 1/6
> # Failed test 'install_driver'
> # at t/01base.t line 21.
> Failed to load Oracle extension and/or shared libraries:
> install_driver(Oracle) failed: Can't load '/c/downloads/ora2pg/DBD-Oracle-1.42/blib/arch/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: No such file or directory at /usr/lib/perl5/5.10/i686-cygwin/DynaLoader.pm line 200.
> at (eval 8) line 3

Not sure about that one as I don't have Oracle on Windows or Cygwin - does that file exist?

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com