I plan to build these Perl modules on another Solaris 8 system where gcc is installed and then move the modules to the production system.
MY QUESTION IS; Is this possible? If so, what gets moved over?
To get things working, I needed to make changes to Config.pm to use ‘–fPIC’ instead of ‘–KPIC’ and ‘–xnone’ instead of '-xO3 -xdepend'
Also had to hand edited the Makefile for DBD::Oracle 1.12 to change all the references to the Oracle libraries from /lib to /lib32 to get "to this point."
Here is the output of perl –V which is identical on both systems except for the changes made to Config.pm on the system with gcc installed;
# perl -V
Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
Platform:
osname=solaris, osvers=2.8, archname=sun4-solaris
uname='sunos localhost 5.8 sun4u sparc sunw,ultra-1 '
hint=previous, useposix=true, d_sigaction=define
usethreads=undef useperlio=undef d_sfio=undef
Compiler:
cc='cc', optimize='-xnone', gccversion=
cppflags=''
ccflags =''
stdchar='char', d_stdstdio=define, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
alignbytes=8, usemymalloc=n, prototype=define
Linker and Libraries:
ld='cc', ldflags =''
libpth=/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lc -lcrypt
libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-R /usr/perl5/5.00503/sun4-solaris/CORE'
cccdlflags='-fPIC', lddlflags='-G'
Characteristics of this binary (from libperl): Built under solaris Compiled at Dec 22 1999 00:00:57 @INC: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .
The built of the DBI 1.30 module went OK.
These are the errors during ‘make test’ for the DBD::Oracle-1.12 module. Most of the errors are “ORA-01950: no privileges on tablespace 'USERS'” or “ORA-00942: table or view does not exist”
Looks like the test account I ask to be set up doesn’t have permission to do those functions.
Script started on Wed Sep 17 10:06:05 2003
# ksh
# pwd /tmp/work/DBD-Oracle-1.12
# echo $ORACLE_USERID alheidgj/********
# echo $TWO_TASK hsrc.world
# echo $ORACLE_HOME /hsrc/oracle/app/oracle/product/9.2
# make test TEST_VERBOSE=1 PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib \ -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503 \ -e 'use Test::Harness qw(&runtests $verbose); $verbose=1; \ runtests @ARGV;' t/*.t
t/base.......1..5 ok 1 ok 2 ok 3 ok 4 ok 5 ok
t/general....1..17 ok 1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 ok 17 ok
t/long.......Unable to create test table (ORA-01950: no privileges on tablespace 'USERS' (DBD ERROR: OCIStmtExecute))
Tests skiped.
1..0
skipped
all skipped: no reason given
t/ph_type....1..53
DBD::Oracle::db do failed: ORA-01950: no privileges on tablespace 'USERS' (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 51.
# failed test 1 at line 51
not ok 1
#
# testing VARCHAR2 (ora_type 1) ...
#
ok 2
ok 3
ok 4
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 78.
# failed test 5 at line 78
not ok 5
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 79.
# failed test 6 at line 79
not ok 6
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 80.
# failed test 7 at line 80
not ok 7
DBD::Oracle::db selectall_hashref failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute/Describe) at t/ph_type.t line 82.
# failed test 8 at line 82
not ok 8
# failed test 9 at line 86
not ok 9
# failed test 10 at line 87
not ok 10
# failed test 11 at line 88
not ok 11
ok 12
Use of uninitialized value at t/ph_type.t line 102.
# failed test 13 at line 107
not ok 13
expected 'trailing' but got undef for VARCHAR2
Use of uninitialized value at t/ph_type.t line 112.
# failed test 14 at line 112
not ok 14
expected 'embedded.nul' but got undef for VARCHAR2
#
# testing STRING (ora_type 5) ...
#
# skipping tests
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
#
# testing CHAR (ora_type 96) ...
#
ok 27
ok 28
ok 29
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 78.
# failed test 30 at line 78
not ok 30
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 79.
# failed test 31 at line 79
not ok 31
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 80.
# failed test 32 at line 80
not ok 32
DBD::Oracle::db selectall_hashref failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute/Describe) at t/ph_type.t line 82.
# failed test 33 at line 82
not ok 33
# failed test 34 at line 86
not ok 34
# failed test 35 at line 87
not ok 35
# failed test 36 at line 88
not ok 36
ok 37
Use of uninitialized value at t/ph_type.t line 102.
# failed test 38 at line 107
not ok 38
expected 'trailing ' but got undef for CHAR
Use of uninitialized value at t/ph_type.t line 112.
# failed test 39 at line 112
not ok 39
expected 'embedded.nul' but got undef for CHAR
#
# testing CHARZ (ora_type 97) ...
#
# skipping tests
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
DBD::Oracle::db do failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) at t/ph_type.t line 118.
# failed test 52 at line 118
not ok 52
ok 53
FAILED tests 1, 5-11, 13-14, 30-36, 38-39, 52
Failed 20/53 tests, 62.26% okay
t/plsql......1..63 ok 1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 ok 17 ok 18 ok 19 ok 20 ok 21 ok 22 ok 23 ok 24 ok 25 ok 26 ok 27 ok 28 ok 29 ok 30 ok 31 ok 32 ok 33 ok 34 ok 35 ok 36 ok 37 ok 38 ok 39 ok 40 ok 41 ok 42 ok 43 ok 44 ok 45 ok 46 ok 47 ok 48 ok 49 ok 50 ok 51 ok 52 ok 53 ok 54 ok 55 ok 56 ok 57 ok 58 ok 59 ok 60 ok 61 ok 62 ok 63 ok
t/reauth.....ORACLE_USERID_2 not defined.
Tests skiped.
1..0
skipped
all skipped: no reason givenFailed Test Stat Wstat Total Fail Failed List of Failed ----------------------------------------------------------------------- t/ph_type.t 53 20 37.74% 1 5-11 13-14 30-36 38-39 52 2 tests skipped. Failed 1/6 test scripts, 83.33% okay. 20/138 subtests failed, 85.51% okay. *** Error code 11 make: Fatal error: Command failed for target `test_dynamic'
# script done on Wed Sep 17 10:08:41 2003
Thanks before hand for any and all help,
Greg
