DBI, DBD, and MYSQL on HPUX 11

[Frank_109]

Hello,

Does anyone know if there are any DBI and DBD depot binary installation files available for HP UX 11.x

Also, has anyone successfully installed the DBI and DBD modules on HPUX any version?

I'm running MySql 4.x ,but I am not able to "make" the DBD or the DBI modules.. Getting criptic errors..(partial error listing)

Creating extra DBI::PurePerl test: t/zz_42prof_data_pp.t
Creating extra DBI::PurePerl test: t/zz_60preparse_pp.t
Creating extra DBI::PurePerl test: t/zz_80proxy_pp.t
Checking if your kit is complete...
Looks good
Writing Makefile for DBI

Remember to actually *read* the README file!
Use 'make' to build the software (dmake or nmake on Windows).
Then 'make test' to execute self tests.
Then 'make install' to install the DBI and then delete this working
directory before unpacking and building any DBD::* drivers.

==> Your Makefile has been rebuilt. <==
==> Please rerun the make command. <==
false
*** Error exit code 1

Stop.

Thanks,

Frank

[H.Merijn Brand (procura]

What version of perl are you using? 32 or 64bit?

perl-5.8.0 + DBI available on my ITRC site: http://www.cmve.net/~merijn or https://www.beepz.com/personal/merijn but it's compiled with gcc-3.x (read there). If you have HP C-ANSI-C, consider building yourself, because it's much faster.

Recent DBI's build OK, I've tested (and used) every version since 0.96 :)

And for above message, what happens if you do what you are told to do: rerun 'make'?

IIRC I /did/ use DBD::mysql (or some kind of package for it) which worked, but the database I used it for is not valid anymore. Be sure to have the correct environment though before starting to build the modules. I don't know if the mysql drivers are pur perl or need some interface library.

Enjoy, have FUN! H.Merijn

[Frank_109]

H. Merijn,

Thanks for the suggestion. I went ahead and loaded the compiled version from your site; however, looks like after loading a few required libraries it's still complaining. Note: I did load the pth.sl library(pth-1.4.1 from: http://hpux.cs.utah.edu/hppd/hpux/Gnu/pth-1.4.1/) After loading:

perl-5.8.0-gcc-3.2-10.20-pa11-ora

and trying to run perl from that version I get the following:

/usr/local/GNU/PERL-GCC32-DBI-ORA/bin>./perl -v
/usr/lib/dld.sl: Invalid version for shared library: /usr/lib/libpthread.sl
/usr/lib/dld.sl: Exec format error
Abort(coredump)


any ideas on how to resolve this error. It looks like I may need to acquire the HPUX ANSI C compiler after all.

Any additional info would be appreciated.

Thanks again for your help,

Frank

[H.Merijn Brand (procura]

Bummer, it might be that I compiled that port to pth-1.4.0, or - worse - towards the cma pthread version (see README.hpux) :/

This is what I have now, but that's for sure newer than what you found. I don't use gcc-builds of perl, because cc builds are much faster.

Would you be able to check with 'chatr' which version it needs?

d3:/usr/lib 103 > ll libpthread.*
14467 lrwxrwxrwx 1 root sys 30 Feb 20 2002 libpthread.a -> ../../opt/pth/lib/libpthread.a
14468 lrwxrwxrwx 1 root sys 31 Feb 20 2002 libpthread.la -> ../../opt/pth/lib/libpthread.la
14469 lrwxrwxrwx 1 root sys 31 Feb 20 2002 libpthread.sl -> ../../opt/pth/lib/libpthread.sl
d3:/usr/lib 104 > cd /opt/pth/lib
d3:/opt/pth/lib 105 > ll libpthread.*
6263 -rw-r--r-- 1 root sys 147534 Jan 29 2002 libpthread.a
6264 -rwxr-xr-x 1 root sys 661 Jan 29 2002 libpthread.la
6265 -r-xr-xr-x 1 root sys 119569 Jan 29 2002 libpthread.sl
d3:/opt/pth/lib 106 > swlist pth
# Initializing...
# Contacting target "d3"...
#
# Target: d3:/
#

# pth 1.4.1 pth
pth.pth-RUN
d3:/opt/pth/lib 107 >

However, it looks like I still have it available, and it also still works:

d3:/opt/perl/bin 112 > ll perl
8502 -rwxr-xr-x 2 merijn softwr 1654332 Sep 2 2002 perl
d3:/opt/perl/bin 113 > ./perl -v

This is perl, v5.8.0 built for PA-RISC1.1

Copyright 1987-2002, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'. If you have access to the
Internet, point your browser at http://www.perl.com/, the Perl Home Page.

d3:/opt/perl/bin 114 > chatr perl | grep thread
dynamic /usr/lib/libpthread.sl
d3:/opt/perl/bin 115 >

So you might need to check you (sym)links first.

Enjoy, have FUN! H.Merijn

[Frank_16]

The chatr command gives the following:

/usr/local/GNU/PERL-GCC32-DBI-ORA/bin>chatr ./perl
chatr(warning): dl_header_ext.size != sizeof(dl_header_ext). Please update your version of the linker.
./perl:
shared executable
shared library dynamic path search:
SHLIB_PATH disabled second
embedded path disabled first Not Defined
shared library list:
dynamic /lib/pa1.1/libcl.1
dynamic /usr/lib/libpthread.sl
dynamic /usr/lib/libnsl_s.1
dynamic /usr/lib/libdld.1
dynamic /usr/lib/libc.1
dynamic /usr/lib/libsec.1
shared library binding:
deferred
global hash table disabled
plabel caching disabled
global hash array size:1103
global hash array nbuckets:3
shared vtable support disabled
static branch prediction disabled
executable from stack: D (default)
kernel assisted branch prediction enabled
lazy swap allocation disabled
text segment locking disabled
data segment locking disabled
third quadrant private data space disabled
fourth quadrant private data space disabled
data page size: D (default)
instruction page size: D (default)

Next: checking /usr/lib
:/usr/lib>ll libpthread.*
-r-xr-xr-x 1 bin bin 139264 Aug 31 1999 libpthread.1
-r-xr-xr-x 1 bin bin 222138 Aug 31 1999 libpthread.a
lrwxr-xr-x 1 root sys 21 Jan 14 1979 libpthread.sl -> /usr/lib/libpthread.1

next: checking /opt/pth
:/opt/pth/lib>:/usr/lib>ll libpthread.*
-r-xr-xr-x 1 bin bin 139264 Aug 31 1999 libpthread.1
-r-xr-xr-x 1 bin bin 222138 Aug 31 1999 libpthread.a
lrwxr-xr-x 1 root ksh: :/usr/lib: not found
sysb:/opt/pth/lib>-r-xr-xr-x 1 bin bin 139264 Aug 31 1999 libpthread.1
ksh: -r-xr-xr-x: not found
sysb:/opt/pth/lib>lrwxr-xr-x 1 root sys 21 Jan 14 1979 libpthread.sl -> /usr/lib/libpthread.1
sysb:/opt/pth/lib>-r-xr-xr-x 1 bin bin 222138 Aug 31 1999 libpthread.a
ksh: -r-xr-xr-x: not found
sysb:/opt/pth/lib>lrwxr-xr-x 1 root sys 21 Jan 14 1979 libpthread.sl -> /usr/lib/libpthread.1
ksh: /usr/lib/libpthread.1: cannot create

next: checking swlist pth

sysb:/opt/pth/lib>/usr/sbin/swlist pth
# Initializing...
# Contacting target "sysb"...
#
# Target: sysb:/
#

# pth 1.4.1 pth
pth.pth-RUN

I guess I try copying the libraries over from the /opt/pth/lib to /usr/lib location and see what happens...

Thanks again for all your help,

Frank

[H.Merijn Brand (procura]

Backup those first. I don't wanna break your system. You never know which application depends on that specific version of libpthread :}

Thanks is/are expressied in points. Please assign. I don't care how much, but don't leave them answers unassigned.

Enjoy, have FUN! H.Merijn

[David_337]

Frank,
Did you ever get mysql and the perl DBI to play nice together?
I've been trying to get them going under hp-ux 11.0 for a few days now and I'd like to know if it can be done or is it all an urban legend.
Thanks,
Dave