Operating System - HP-UX
1752360 Members
6742 Online
108787 Solutions
New Discussion юеВ

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

 
SOLVED
Go to solution

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

no no

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

not perl Configure...
no problem :)

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

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..

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

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
Honored Contributor

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

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 ...
Enjoy, Have FUN! H.Merijn

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

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
Honored Contributor
Solution

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

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
Enjoy, Have FUN! H.Merijn

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

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...

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

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.


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

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#


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

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.