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 '

[Stephane Fromholtz]

no no

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

not perl Configure...
no problem :)

[Stephane Fromholtz]

So I compiled perl 5.8.0 and DBI without problem, but still the same error with DBD::Oracle :



chmod 755 blib/arch/auto/DBD/Oracle/Oracle.sl
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/base......./usr/lib/dld.sl: Can't open shared library: /hpx/work/ee/8.1.7.4/hpx32/src_0424/lib//libwtc8.sl
/usr/lib/dld.sl: No such file or directory
Failed to load Oracle extension and/or shared libraries:
install_driver(Oracle) failed: Can't load '/tmp/DBD/DBD-Oracle-1.12/blib/arch/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: No such file or directory at /usr/local/lib/perl5/5.8.0/PA-RISC2.0/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/base.t line 19
The remaining tests will probably also fail with the same error.

*** Please read the README and README.help files for help. ***


This /usr/lib/dld.sl causes some problems..

[Stephane Fromholtz]

The file libwtc8.sl asked is in facts in :

/oracle/lib/libwtc8.sl
/oracle/lib64/libwtc8.sl

Perhaps if I try to recompile perl and add these libraries paths ?

[H.Merijn Brand (procura]

Yeah, I know. For the moment I've done:

l1:/ 102 > ls -lR hpx
lrwxrwxrwx 1 root sys 12 Jul 15 13:37 hpx -> project/hpux
l1:/ 103 > ls -lR project/hpux
project/hpux:
total 0
lrwxrwxrwx 1 merijn softwr 3 Jul 15 13:38 8.1.7.4 -> 817
drwxrwxrwx 2 merijn softwr 96 Jul 15 13:39 817
lrwxrwxrwx 1 merijn softwr 1 Jul 15 13:37 ee -> .
lrwxrwxrwx 1 merijn softwr 1 Jul 15 13:37 work -> .

project/hpux/817:
total 0
lrwxrwxrwx 1 merijn softwr 1 Jul 15 13:38 hpx32 -> .
lrwxrwxrwx 1 merijn softwr 24 Jul 15 13:32 src -> ../../../pro/oracle/v817
lrwxrwxrwx 1 merijn softwr 3 Jul 15 13:38 src_000811 -> src
lrwxrwxrwx 1 merijn softwr 3 Jul 15 13:39 src_0424 -> src
lrwxrwxrwx 1 merijn softwr 3 Jul 15 13:38 src_final -> src
l1:/ 104 >

Well, you get the drift. This works, but there will be a better way I guess. Open for any other real nice solution ...

[Stephane Fromholtz]

Does not work,


t/base......./usr/lib/dld.sl: Can't open shared library: /hpx/work/ee/8.1.7.4/hpx32/src_0424/lib//libwtc8.sl
/usr/lib/dld.sl: No such file or directory


but there is a //libwtc8.sl perhaps this is causing problem.

There is something with this /usr/lib/dld.sl but I don't know what.

[H.Merijn Brand (procura · Accepted solution]

Are you sure you did the linking correctly?

l1:/u/usr/merijn 101 > ls /hpx/work/ee/8.1.7.4/hpx32/src_0424/lib
aurora_client.jar libgslavl8.a libocijdbc8.sl libwwg8.a
aurora_server.jar libgslber_s8.a libocijdbc8_g.sl libxml8.a
classgen.jar libgsldb8.a libordim8.a libxmlg8.a
clntsh.map libgslr8.a libordim8.sl libzx8.a
clntst.lis libgslsg8.a libordsdo8.a mts.jar
full_orb.jar libgslssb8.a libordts8.a naect.o
http_client.jar libgslssf8.a libordvir8.a naect.o.bak
http_server.jar libgx8.a libordvir8.sl naectr.o
jdev-rt.zip libjip8.sl libordvirt8.a naedhs.o
jndi.jar libjox8.sl libowm2.sl naedhs.o.bak
lclasses11.zip libldapclnt8.a libplc8.a naedhsd.o
lclasses12.zip liblsm.sl libplp8.a naeet.o
ldflags libmm.a libpls8.a naeet.o.bak
ldflagsO libn8.a libpsa8.a naeetr.o
libJNLSLib3.sl libnavshr.sl libqsmashr.sl nautab.o
libJNLSTool.sl libnbeq8.a libserver8.a nigcon.o
libVdbJdbcExt.sl libncrypt8.a libsgsl_s8.a nigtab.o
libVxxxStackTrace.sl libnent8.a libskgxp8.a nnfgt.o
libWizOSD.sl libnhost8.a libskgxpd.a ntcontab.o
libagent8.a libnjni8.sl libslax8.a nvdb_odbc.sl
libagtsh.sl libnjssl8.sl libslpm.a oraclexsql.jar
libagtsh.sl.1.0 libnl8.a libsql8.a osntabst.o
libclient8.a libnldap8.a libsqlplus.a s0main.o
libclntsh.sl libnls8.a libsvrmgrl.a scorept.o
libclntsh.sl.8.0 libnoname8.a libtrace8.a servlet.jar
libclntst8.a libnro8.a libtracefe8.a smalmain.o
libcommon8.a libnsgr8.a libtracepls8.a sscoreed.o
libcore8.a libnsslb8.a libtracepls8.sl sysliblist
libcorejava.sl libntcp8.a libtracept8.a vbjapp.jar
libctx8.a libntcps8.a libvdg.sl vbjgk.jar
libctxc8.a libntns8.a libvppdc.sl vbjorb.jar
libctxs8.a libnus8.a libvsn8.a vbjtools.jar
libdbicx8.a libnvbaseshr.sl libwtc8.a xmlcomp.jar
libdsbtsh8.sl libnzjs8.a libwtc8.sl xmlparserv2.jar
libgeneric8.a libobk.sl libwtcserver8.a xmlplsql.jar
l1:/u/usr/merijn 102 >



# cd /
# mkdir hpx
# cd hpx
# mkdir work
# cd work
# mkdir ee
# cd ee
# mkdir 817
# ln -s 817 8.1.7.4
# cd 817
# ln -s . hpx32
# ln -s /oracle src
# ln -s src src_0424

should work

[Stephane Fromholtz]

Yes it works !
Some errors during the make test but I think it's Ok. If I change my ORACLE_SID and make test I complains about Oracle not available.

When putting back the ORACLE_SID correctly, the make test passes (some errors) and the make install installs everything.

Now I'll try to install DBD::ODBC...

[Stephane Fromholtz]

Ok the only parameter I don't know anything about is ODBCDIR

I set the following variables :

DBI_DSN=dbi:ODBC:SID
DBI_PASS=tiger
DBI_USER=scott

But I don't know where to put the ODBCDIR...

Configuring DBD::ODBC ...

>>> Remember to actually *READ* the README file!
And re-read it if you have any problems.

Using DBI 1.29 installed in /usr/local/lib/perl5/site_perl/5.8.0/PA-RISC2.0/auto/DBI

The DBD::ODBC module needs to link with an ODBC 'Driver Manager'.
(The Driver Manager, in turn, needs one or more database specific ODBC drivers.
The DBD::ODBC module does _not_ include any ODBC drivers!)

You need to indicate where your ODBC Driver Manager is installed.
You can do this ether by setting the ODBCHOME environment variable
or by runing 'perl Makefile.PL -o odbcdir'.

If you do not have an ODBC Driver Manager you can try building
the free iODBC Driver Manager in the iodbcsrc directory.

[Stephane Fromholtz]

mmmmm seems good :

I tried with '/usr/local/lib/perl5/site_perl/5.8.0/PA-RISC2.0/auto/DBD' :



export ODBCHOME='/usr/local/lib/perl5/site_perl/5.8.0/PA-RISC2.0/auto/DBD'
shait001:/tmp/DBD/DBD-ODBC-0.43#perl Makefile.PL

Configuring DBD::ODBC ...

>>> Remember to actually *READ* the README file!
And re-read it if you have any problems.

Using DBI 1.29 installed in /usr/local/lib/perl5/site_perl/5.8.0/PA-RISC2.0/auto/DBI
Using ODBC in /usr/local/lib/perl5/site_perl/5.8.0/PA-RISC2.0/auto/DBD

Umm, this looks like a udbc type of driver manager.

Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -ludbc
Using DBI 1.29 installed in /usr/local/lib/perl5/site_perl/5.8.0/PA-RISC2.0/auto/DBI
Writing Makefile for DBD::ODBC

The DBD::ODBC tests will use these values for the database connection:
DBI_DSN=dbi:ODBC:SID e.g. dbi:ODBC:demo
DBI_USER=scott
DBI_PASS=tiger

shait001:/tmp/DBD/DBD-ODBC-0.43#

[Stephane Fromholtz]

oops...


cc -c -I. -I/usr/local/lib/perl5/site_perl/5.8.0/PA-RISC2.0/auto/DBI -I/usr/local/lib/perl5/site_perl/5.8.0/PA-RISC2.0/auto/DBD/include -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 +O2 +Onolimit -DVERSION=\"0.43\" -DXS_VERSION=\"0.43\" +Z "-I/usr/local/lib/perl5/5.8.0/PA-RISC2.0/CORE" ODBC.c
cpp: "dbdodbc.h", line 6: error 4036: Can't open include file 'libudbc.h'.
*** Error exit code 1

Stop.

[H.Merijn Brand (procura]

>> cc -c -I. -I/usr/local/lib/perl5/site_perl/5.8.0/PA-RISC2.0/auto/DBI -I/usr/ local/lib/perl5/site_perl/5.8.0/PA-RISC2.0/auto/DBD/include -Ae - D_HPUX_SOURCE -Wl,+vnocompatwarnings -I/usr/local/include - D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 +O2 +Onolimit - DVERSION=\"0.43\" -DXS_VERSION=\"0.43\" +Z "-I/usr/local/lib/perl5/ 5.8.0/PA-RISC2.0/CORE" ODBC.c
cpp: "dbdodbc.h", line 6: error 4036: Can't open include file 'libudbc.h'.
*** Error exit code 1

Does not ring a bell.

# find / -name libudbc.h
?? [ don't do this with NFS partitions active ]

I only use ODBC on M$windoze, and that passes ( I see you use 0.43 :) You like newest versions)

You can try comp.perl.modules newsgroup, or the author

[Stephane Fromholtz]

With

# find / -name libudbc.h

I don't have this library on my server at all. What can I do to compile and install DBD::ODBC successfuly ?

[H.Merijn Brand (procura]

I cannot build one for you, because of:

--8<---
lep l1:/pro/3gl/CPAN/DBD/DBD-ODBC-0.45_5 106 > perl Makefile.PL

Configuring DBD::ODBC ...

>>> Remember to actually *READ* the README file!
And re-read it if you have any problems.

Using DBI 1.28 installed in /pro/lib/perl5/site_perl/5.6.1/PA-RISC2.0/auto/DBI

The DBD::ODBC module needs to link with an ODBC 'Driver Manager'.
(The Driver Manager, in turn, needs one or more database specific ODBC drivers.
The DBD::ODBC module does _not_ include any ODBC drivers!)

You need to indicate where your ODBC Driver Manager is installed.
You can do this ether by setting the ODBCHOME environment variable
or by runing 'perl Makefile.PL -o odbcdir'.

If you do not have an ODBC Driver Manager you can try building
the free iODBC Driver Manager in the iodbcsrc directory.

Makefile.PL aborted.
Exit 2
lep l1:/pro/3gl/CPAN/DBD/DBD-ODBC-0.45_5 107 >
-->8---

If I were to have an ODBC manager, it is very likely that it is not the same as yours. Chances are that the 'perl Makefile.PL' command has either detected the wrong version of the ODBC manager you want, or misconfigured the found manager for whatever reason.

I managed to build it on Win32/Cygwin, and ODBC said it detected the M$ version, which seemed very plausible :)

[CIS Unix (Keith Daley)]

I take it that HP support the Perl DBI module on HP servers ???

[H.Merijn Brand (procura]

No, why should they?