perl 5.6.1, DBI, DBD problems - Old Thread - Do Not Reply!

[Stephane Fromholtz]

I am trying to install a working perl, with modules DBI (as Bundle), DBD::Oracle and DBD::ODBC. After having problems with the .depot of perl shipped with HP-UX (11.11), I removed it because it was compiled using ithreads.

Now I install perl like described in http://search.cpan.org/doc/TIMB/DBD-Oracle-1.12/README.hpux and my make test and make install are successfull.

But when I try :

perl -MCPAN -e 'install Bundle::DBI'


I get the following :

/usr/lib/dld.sl: Unresolved symbol: perl_get_sv (code) from /usr/local/lib/perl5/5.6.1/PA-RISC2.0/auto/Storable/Storable.sl
Abort(coredump)

What is the problem ?

My perl -V :

Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
Platform:
osname=hpux, osvers=11.11, archname=PA-RISC2.0
uname='hp-ux hostname b.11.11 u 9000800 700967651 unlimited-user license '
config_args='-Ubincompat5005 -Uusemymalloc'
hint=previous, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
Compiler:
cc='cc', ccflags ='-D_HPUX_SOURCE -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae',
optimize='-O',
cppflags='-D_HPUX_SOURCE -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae'
ccversion='', gccversion='', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=8, usemymalloc=n, prototype=define
Linker and Libraries:
ld='ld', ldflags =' -Wl,+vnocompatwarnings -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
libs=-lcl -lc -lnsl -lnm -lndbm -ldld -lm -lc -lndir -lcrypt -lsec -liconv
perllibs=-lcl -lc -lnsl -lnm -ldld -lm -lc -lndir -lcrypt -lsec -liconv
libc=/lib/libc.sl, so=sl, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=undef, ccdlflags='-Wl,-E -Wl,-B,deferred '
cccdlflags='+Z', lddlflags='-b +vnocompatwarnings -L/usr/local/lib'


Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under hpux
Compiled at Jul 18 2002 17:16:02
@INC:
/usr/local/lib/perl5/5.6.1/PA-RISC2.0
/usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/PA-RISC2.0
/usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl
.

[H.Merijn Brand (procura]

Please visit https://www.beepz.com/personal/merijn to find all you need. Please ask if not clear. Bye have to run now

[Stephane Fromholtz]

Thanks for the quick answer, I'll have a look and post here If I have problems.

[Stephane Fromholtz]

Sorry it didn't help me

There must be something wrong with the libraries, I've seen another post where the compliation of perl is detailed, and it doesn't work.

[H.Merijn Brand (procura]

What did you use from that page? How did it not help you? I'd like to make it more useful if I can.

I've just uploaded perl-5.8.0 (released yesterday), built according to the readme's

For perl-5.6.1 you should provide a Policy.sh before you start make, from the latest README:

--8<---
Oracle on HP-UX

Using perl to connect to Oracle databases through DBI and DBD::Oracle
has caused a lot of people many headaches. Read README.hpux in the
DBD::Oracle for much more information. The reason to mention it here
is that Oracle requires a perl built with libcl and libpthread, the
latter even when perl is build without threads. Building perl using
all defaults, but still enabling to build DBD::Oracle later on can be
achieved using

Configure -A prepend:libswanted='cl pthread ' ...

Do not forget the space before the trailing quote.

Also note that this does not (yet) work with all configurations, it is
known to fail with 64bit versions of GCC.
-->8---

HTH

[H.Merijn Brand (procura]

stable is 5.6.1 today, but 5.8.0 this afternoon :)))

Try ftp://ftp.funet.fi/pub/languages/perl/CPAN/src/perl-5.8.0.tar.gz

My question is: do you *need* a 64bit perl for an Oracle DBD to access 64bit values? I guess so. Check how Oracle is installed:

l1:/pro/oracle/v817/bin 104 > file sqlplus
sqlplus: PA-RISC1.1 shared executable dynamically linked -not stripped
l1:/pro/oracle/v817/bin 105 >

For me this is a 32bit install, 64bit installs will show something like
l1:/pro/local/bin 107 > path -alf calc
10341 100777 -rwx 1 merijn 23280 20 Dec 2000 16:43
/pro/bin/calc: ELF-64 executable object file - PA-RISC 2.0 (LP64)
l1:/pro/local/bin 108 >

# Configure -des -A prepend:libswanted='cl pthread ' -Duse64bitall

mind all the spaces!
I've not tried it, cause we have no need for 64bit Oracle

I've tried all tests with 32bit and 64bit for 5.8.0 for HP C-ANSI-C and gcc-3.1.1 and all core tests pass. Don't know about any Oracle issues

[Stephane Fromholtz]

Ok I'll try that version, thanks.

I don't really bother the 32 bits or 64 bits, it was just to say that my Oracle install was 64bits, so if there is something tricky to do..

How can I check that my libraries are installed, and add the missing ones :

perl ./Configure finds :

Checking for optional libraries...
Found -lcl (shared).
Found -lpthread (shared).
No -lsfio.
No -lsocket.
No -lbind.
No -linet.
Found -lnsl (shared).
Found -lnm (shared).
Found -lndbm (shared).
No -lgdbm.
No -ldb.
Found -lmalloc.
No -ldl.
Found -ldld (shared).
No -lsun.
Found -lm (shared).
Found -lc (shared).
No -lcposix.
No -lposix.
Found -lndir.
No -ldir.
Found -lcrypt.
Found -lsec (shared).
No -lucb.
No -lbsd.
No -lx.
Found -liconv (shared).
No -lutil.

[H.Merijn Brand (procura]

The message already states "optional". Chances are *very* low that you miss vital libraries. Just continue and give feedback on both failure and success

[H.Merijn Brand (procura]

re-read your last message.

You realy do: ??

# perl ./Configure

that cannot be. It's a *shell* script.

# sh Configure -des -A prepend:libswanted='cl pthread '