Help compiling perl DB modules

[Jeff Schussele]

I'm having trouble compiling a couple of perl DB modules. Info as follows

OS => 11.11
perl => 5.6.1
compiler => gcc_64 3.1
DB => mysql 2.23.56 64bit (Statically linked libs)
module1 => DBI-1.40
module2 => DBD-mysql-2.9003

DBI compile completes Makefile & make OK but fails ~48% of the tests & ~17% of the subtests of the make test. It does complete the make install w/o any error indication.

DBD fails the Makefile quickly with the following error message:

Warning: prerequisite DBI failed to load: Can't load '/opt/perl/lib/site_perl/5.
6.1/PA-RISC1.1-thread-multi/auto/DBI/DBI.sl' for module DBI: Exec format error a
t /opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi/DynaLoader.pm line 206.
at /opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi/DBI.pm line 252
BEGIN failed--compilation aborted at /opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-t
hread-multi/DBI.pm line 252.
Compilation failed in require at (eval 4) line 3.

I've tried compiling both manually & through the CPAN module & get the same results.
The make binary I run is out of /usr/ccs/bin & shows

# what make
make:
doname.c $Date: 2002/07/02 08:54:21 $Revision: r11.11/1 PATCH_11.11 (PH
CO_27280)
files.c $Date: 2002/07/02 08:54:21 $Revision: r11.11/1 PATCH_11.11 (PHC
O_27280)
rules.c $Date: 2002/10/06 23:26:23 $Revision: r11.11/2 PATCH_11.11 (PHC
O_27755)
$Revision: @(#) all CUP11.11_BL2002_1008_3 PATCH_11.11 PHCO_27755
Tue Oct 8 06:55:10 PDT 2002 $

Things I'm not sure of are what my SHLIB_PATH & LD_PATH settings should be.

Has anybody attempted to compile these module for 11.11?
Let me know if you need any further info
Any help will be greatly appreciated.

Thanks,
Jeff

[H.Merijn Brand (procura · Accepted solution]

I _think_ your perl is 32bit. ANd thus the DBI.sl that is built for this perl is also 32bit.

Given that you want to link to 64bit objects, the complaints are reasonable.

You need a 64bit perl to link to 64bit MySQL

Enjoy, Have FUN! H.Merijn [ Who does not use MySQL (anymore) ]

[Jeff Schussele]

Hi Merijn,

I checked & the perl loaded is B.5.6.1.C
I see on my depot I have B.5.6.1.E and am assuming that's 32-bit as well.

I can't seem to find - or at least I don't see - a 64-bit ver on software.hp.com.

Do you know if they have one?
If so, where on their site.
If not, where would I get one?

Thx,
Jeff

[H.Merijn Brand (procura]

Not on HP :) But *I* have all kind of flavours readily available. Bet you've never been there (yet)

My HP ITRC site pages can be found at

Singapore https://www.beepz.com/personal/merijn/
Rotterdam http://www.cmve.net/~merijn/
Seattle http://ww.hpux.ws/merijn/

Enjoy, have FUN! H.Merijn

[Pete Randall]

Jeff,

Excuse the interruption, but I have to know!!


Merijn,

Does SEP have a branch office in Seattle or is this actually supposed to be Chicago?



Pete

[H.Merijn Brand (procura]

How should I know? :) :)

This is what a visual tracert showed me, and SEP never complained. Whatever it is, it's both USA and thus closest mirror to the USA members.

Enjoy, Have FUN! H.Merijn

[Jeff Schussele]

Hi Merijn,

Ok - I've pulled down 5.8.3 for 11.11/64 - mainly because you've already loaded it with DBI 1.40.

Will install & try the DBD again.
I'll let you know how it goes.

Thanks again for your valuable assistance.

Rgds,
Jeff

[Jeff Schussele]

Merijn, you're the perl mongering man!
Worked like a champ.
I guess it's always easier with the right tool ;^))

Thanks again my friend,
Jeff