DBD::Oracle 1.19 failing to make
am 12.12.2006 19:12:51 von ronneil.camaraHi,
I need some help. The "make" is failing as shown at the bottom of the
email.
My FreeBSD is 4.9 STABLE release. The Oracle that I installed is 8.0.5.=20
---------------------------------------
Below is the output of perl -V
---------------------------------------
Summary of my perl5 (revision 5.0 version 8 subversion 1) configuration:
Platform:
osname=3Dfreebsd, osvers=3D4.9-stable, archname=3Di386-freebsd
uname=3D'freebsd trafmon.wamucrm.com 4.9-stable freebsd 4.9-stable =
#0:
wed oct 29 17:25:54 cst 2003
root@trafmon.wamucrm.com:usrobjusrsrcsysoptimized i386 '
config_args=3D'-sde -Dprefix=3D/usr/local
-Darchlib=3D/usr/local/lib/perl5/5.8.1/mach
-Dprivlib=3D/usr/local/lib/perl5/5.8.1
-Dman3dir=3D/usr/local/lib/perl5/5.8.1/man/man3
-Dsitearch=3D/usr/local/lib/perl5/site_perl/5.8.1/mach
-Dsitelib=3D/usr/local/lib/perl5/site_perl/5.8.1
-Dscriptdir=3D/usr/local/bin -Ui_malloc -Ui_iconv -Uinstallusrbinperl
-Dcc=3Dcc =
-Dccflags=3D-DAPPLLIB_EXP=3D"/usr/local/lib/perl5/5.8.1/BSDP AN"
-Ud_dosuid -Ui_gdbm -Dusethreads=3Dn -Dusemymalloc=3Dy'
hint=3Drecommended, useposix=3Dtrue, d_sigaction=3Ddefine
usethreads=3Dundef use5005threads=3Dundef useithreads=3Dundef
usemultiplicity=3Dundef
useperlio=3Ddefine d_sfio=3Dundef uselargefiles=3Ddefine =
usesocks=3Dundef
use64bitint=3Dundef use64bitall=3Dundef uselongdouble=3Dundef
usemymalloc=3Dy, bincompat5005=3Dundef
Compiler:
cc=3D'cc', ccflags =
=3D'-DAPPLLIB_EXP=3D"/usr/local/lib/perl5/5.8.1/BSDPAN"
-DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -fno-strict-aliasing
-I/usr/local/include',
optimize=3D'-O',
cppflags=3D'-DAPPLLIB_EXP=3D"/usr/local/lib/perl5/5.8.1/BSDP AN"
-DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -fno-strict-aliasing
-I/usr/local/include'
ccversion=3D'', gccversion=3D'2.95.4 20020320 [FreeBSD]',
gccosandvers=3D''
intsize=3D4, longsize=3D4, ptrsize=3D4, doublesize=3D8, =
byteorder=3D1234
d_longlong=3Ddefine, longlongsize=3D8, d_longdbl=3Ddefine, =
longdblsize=3D12
ivtype=3D'long', ivsize=3D4, nvtype=3D'double', nvsize=3D8, =
Off_t=3D'off_t',
lseeksize=3D8
alignbytes=3D4, prototype=3Ddefine
Linker and Libraries:
ld=3D'cc', ldflags =3D'-Wl,-E -L/usr/local/lib'
libpth=3D/usr/lib /usr/local/lib
libs=3D-lm -lcrypt -lutil -lc
perllibs=3D-lm -lcrypt -lutil -lc
libc=3D, so=3Dso, useshrplib=3Dfalse, libperl=3Dlibperl.a
gnulibc_version=3D''
Dynamic Linking:
dlsrc=3Ddl_dlopen.xs, dlext=3Dso, d_dlsymun=3Dundef, ccdlflags=3D' '
cccdlflags=3D'-DPIC -fPIC', lddlflags=3D'-shared -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under freebsd
Compiled at May 4 2006 10:29:09
@INC:
/usr/local/lib/perl5/site_perl/5.8.1/mach
/usr/local/lib/perl5/site_perl/5.8.1
/usr/local/lib/perl5/site_perl
/usr/local/lib/perl5/5.8.1/BSDPAN
/usr/local/lib/perl5/5.8.1/mach
/usr/local/lib/perl5/5.8.1
-------------------------------------------------------
Below is the output of perl Makefile.PL
----------------------------------------------------------
Using DBI 1.53 (for perl 5.008001 on i386-freebsd) installed in
/usr/local/lib/perl5/site_perl/5.8.1/mach/auto/DBI/
Configuring DBD::Oracle for perl 5.008001 on freebsd (i386-freebsd)
Remember to actually *READ* the README file! Especially if you have any
problems.
Using Oracle in /usr/local/oracle/product/8.0.5
Can't find sqlplus. Pity, it would have helped.
8.0.5.0.0 ORACLE Common RDBMS Libraries and Utilities
8.0.5.0.0 ORACLE PL/SQL Libraries
8.0.5.0.0 ORACLE Common Precomp Libraries
8.0.5.0.0 PL/SQL
8.0.5.0.0 Oracle8 Standard (RDBMS)
Oracle version 8.0.5 (8.0)
Found /usr/local/oracle/product/8.0.5/rdbms/demo/demo_rdbms.mk
Using /usr/local/oracle/product/8.0.5/rdbms/demo/demo_rdbms.mk
Your LD_LIBRARY_PATH env var is set to
'/usr/local/oracle/product/8.0.5/lib'
Reading /usr/local/oracle/product/8.0.5/rdbms/demo/demo_rdbms.mk
Reading /usr/local/oracle/product/8.0.5/rdbms/lib/env_rdbms.mk
Deleting $(COMPOBJ)/crti.o from COMPOBJS because
/usr/local/oracle/product/8.0.5/lib/GCC2.7.2.3/crti.o doesn't exist.
Deleting $(COMPOBJ)/crt1.o from COMPOBJS because
/usr/local/oracle/product/8.0.5/lib/GCC2.7.2.3/crt1.o doesn't exist.
Deleting $(COMPOBJ)/crtn.o from COMPOBJS because
/usr/local/oracle/product/8.0.5/lib/GCC2.7.2.3/crtn.o doesn't exist.
Attempting to discover Oracle OCI build rules
cc -O -pipe -c DBD_ORA_OBJ.c
by executing: [make -f
/usr/local/oracle/product/8.0.5/rdbms/demo/demo_rdbms.mk build
ECHODO=3Decho ECHO=3Decho GENCLNTSH=3D'echo genclntsh' CC=3Dtrue =
OPTIMIZE=3D
CCFLAGS=3D EXE=3DDBD_ORA_EXE OBJS=3DDBD_ORA_OBJ.o]
Oracle oci build prolog:
[Building client shared library libclntsh.so ...]
[Call script /usr/local/oracle/product/8.0.5/bin/genclntsh ...]
[genclntsh]
[Built /usr/local/oracle/product/8.0.5/lib/libclntsh.so ...
DONE]
Oracle oci build command:
[true -L/usr/local/oracle/product/8.0.5/lib/
-L/usr/local/oracle/product/8.0.5/rdbms/lib -o DBD_ORA_EXE DBD_ORA_OBJ.o
/usr/local/oracle/product/8.0.5/rdbms/lib/defopt.o
/usr/local/oracle/product/8.0.5/lib/sscoreed.o
/usr/local/oracle/product/8.0.5/lib/libclntsh.so
/usr/local/oracle/product/8.0.5/lib/nautab.o
/usr/local/oracle/product/8.0.5/lib/naeet.o
/usr/local/oracle/product/8.0.5/lib/naect.o
/usr/local/oracle/product/8.0.5/lib/naedhs.o -lnetv2 -lnttcp -lnetwork
-lncr -lclient -lvsn -lcommon -lgeneric -lmm -lnlsrtl3 -lcore4 -lnlsrtl3
-lcore4 -lnlsrtl3 -lnetv2 -lnttcp -lnetwork -lncr -lclient -lvsn
-lcommon -lgeneric -lepc -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3
-lclient -lvsn -lcommon -lgeneric -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4
-lnlsrtl3 -lnsl -lm -ldl -lm -ldl -lnetv2 -lnttcp -lnetwork -lncr
-lnetv2 -lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lncr -lnetv2
-lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lncr -lsql -lsql]
Found header files in /usr/local/oracle/product/8.0.5/plsql/public
/usr/local/oracle/product/8.0.5/rdbms/demo.
Checking for functioning wait.ph
System: perl5.008001 freebsd trafmon.wamucrm.com 4.9-stable freebsd
4.9-stable #0: wed oct 29 17:25:54 cst 2003
root@trafmon.wamucrm.com:usrobjusrsrcsysoptimized i386
Compiler: cc -O -DAPPLLIB_EXP=3D"/usr/local/lib/perl5/5.8.1/BSDPAN"
-DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -fno-strict-aliasing
-I/usr/local/include
Linker: /usr/bin/ld
Sysliblist: -lnsl -lm
Oracle makefiles would have used these definitions but we override them:
CC: cc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) $(QACCFLAGS)
-I/usr/local/oracle/product/8.0.5/rdbms/demo
-I/usr/local/oracle/product/8.0.5/rdbms/public
-I/usr/local/oracle/product/8.0.5/plsql/public
-I/usr/local/oracle/product/8.0.5/network/public $(LPFLAGS) $(USRFLAGS)]
LDFLAGS: -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib
[-L$(LIBHOME) -L/usr/local/oracle/product/8.0.5/rdbms/lib]
Linking with OTHERLDFLAGS =3D -L/usr/local/oracle/product/8.0.5/lib/
-L/usr/local/oracle/product/8.0.5/rdbms/lib
/usr/local/oracle/product/8.0.5/rdbms/lib/defopt.o
/usr/local/oracle/product/8.0.5/lib/sscoreed.o
/usr/local/oracle/product/8.0.5/lib/libclntsh.so
/usr/local/oracle/product/8.0.5/lib/nautab.o
/usr/local/oracle/product/8.0.5/lib/naeet.o
/usr/local/oracle/product/8.0.5/lib/naect.o
/usr/local/oracle/product/8.0.5/lib/naedhs.o -lnetv2 -lnttcp -lnetwork
-lncr -lclient -lvsn -lcommon -lgeneric -lmm -lnlsrtl3 -lcore4 -lnlsrtl3
-lcore4 -lnlsrtl3 -lnetv2 -lnttcp -lnetwork -lncr -lclient -lvsn
-lcommon -lgeneric -lepc -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3
-lclient -lvsn -lcommon -lgeneric -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4
-lnlsrtl3 -lnsl -lm -ldl -lm -ldl -lnetv2 -lnttcp -lnetwork -lncr
-lnetv2 -lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lncr -lnetv2
-lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lncr -lsql -lsql
[from 'build' rule]
WARNING: If you have problems you may need to rebuild perl with
threading enabled.
WARNING: If you have problems you may need to rebuild perl with
-Uusemymalloc.
Checking if your kit is complete...
Looks good
Use of uninitialized value in string ne at
/usr/local/lib/perl5/5.8.1/BSDPAN/ExtUtils/MM_Unix.pm line 44.
LD_RUN_PATH=3D/usr/local/oracle/product/8.0.5/lib:/usr/local /oracle/produ=
c
t/8.0.5/rdbms/lib
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Using DBI 1.53 (for perl 5.008001 on i386-freebsd) installed in
/usr/local/lib/perl5/site_perl/5.8.1/mach/auto/DBI/
Writing Makefile for DBD::Oracle
*** WARNING - YOUR ORACLE INSTALLATION HAS A SECURITY PROBLEM.
Read the README.sec.txt file for more information and patch
details.
This is just a warning. It does not affect DBD::Oracle in any way.
*** 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?)
-------------------------------------------
This is the output of make
-------------------------------------------
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
cp mkta.pl blib/lib/DBD/mkta.pl
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp oraperl.ph blib/lib/oraperl.ph
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
/usr/local/bin/perl -p -e "s/~DRIVER~/Oracle/g"
/usr/local/lib/perl5/site_perl/5.8.1/mach/auto/DBI/Driver.xs t >
Oracle.xsi
/usr/local/bin/perl /usr/local/lib/perl5/5.8.1/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/5.8.1/ExtUtils/typemap -typemap typemap Oracle.xs
> Oracle.xsc && mv Oracle.xsc Oracle.c
cc -c -I/usr/local/oracle/product/8.0.5/plsql/public
-I/usr/local/oracle/product/8.0.5/rdbms/demo
-I/usr/local/oracle/product/8.0.5/rdbms/demo
-I/usr/local/oracle/product/8.0.5/rdbms/public
-I/usr/local/oracle/product/8.0.5/plsql/public
-I/usr/local/oracle/product/8.0.5/network/public
-I/usr/local/lib/perl5/site_perl/5.8.1/mach/auto/DBI
-DAPPLLIB_EXP=3D"/usr/local/lib/perl5/5.8.1/BSDPAN" -DHAS_FPSETMASK
-DHAS_FLOATINGPOINT_H -fno-strict-aliasing -I/usr/local/include -O
-DVERSION=3D\"1.19\" -DXS_VERSION=3D\"1.19\" -DPIC -fPIC
"-I/usr/local/lib/perl5/5.8.1/mach/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DORA_OCI_VERSION=3D\"8.0.5\" Oracle.c
cc -c -I/usr/local/oracle/product/8.0.5/plsql/public
-I/usr/local/oracle/product/8.0.5/rdbms/demo
-I/usr/local/oracle/product/8.0.5/rdbms/demo
-I/usr/local/oracle/product/8.0.5/rdbms/public
-I/usr/local/oracle/product/8.0.5/plsql/public
-I/usr/local/oracle/product/8.0.5/network/public
-I/usr/local/lib/perl5/site_perl/5.8.1/mach/auto/DBI
-DAPPLLIB_EXP=3D"/usr/local/lib/perl5/5.8.1/BSDPAN" -DHAS_FPSETMASK
-DHAS_FLOATINGPOINT_H -fno-strict-aliasing -I/usr/local/include -O
-DVERSION=3D\"1.19\" -DXS_VERSION=3D\"1.19\" -DPIC -fPIC
"-I/usr/local/lib/perl5/5.8.1/mach/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DORA_OCI_VERSION=3D\"8.0.5\" dbdimp.c
dbdimp.c: In function `ora_db_login6':
dbdimp.c:456: warning: unused variable `rsize'
dbdimp.c: In function `dbd_rebind_ph_char':
dbdimp.c:1110: warning: value computed is not used
dbdimp.c: In function `ora_st_execute_array':
dbdimp.c:1985: warning: value computed is not used
dbdimp.c:2016: `OCI_BATCH_ERRORS' undeclared (first use in this
function)
dbdimp.c:2016: (Each undeclared identifier is reported only once
dbdimp.c:2016: for each function it appears in.)
dbdimp.c:2029: `OCI_ATTR_NUM_DML_ERRORS' undeclared (first use in this
function)
dbdimp.c:2049: `OCI_ATTR_DML_ROW_OFFSET' undeclared (first use in this
function)
dbdimp.c:1866: warning: `oci_mode' might be used uninitialized in this
function
*** Error code 1
Stop in /usr/local/src/DBD-Oracle-1.19.
Thanks,
Ronneil