Problem compiling DBD::MySQL on HP-UX 11.00

[Contract Support]

Ack! No solution here but I am having the exact same problem. It looks to me like there's a library compatibility problem since the compile bombs at the linker step. I've even tried changing LD_RUN_PATH to include /usr/lib/pa20_64 before /lib and still get the same result.

At this point, I have compiled perl 5.8 and mysql 4.0 from scratch using the ANSI C product and C++ running on HP-UX 11.00 recently patched.

[Contract Support]

Eureka!

Perl is normally installed as a 32-bit binary/libraries (you have to explicitly compile it as 64-bit) and it was conflicting with the 64-bit libraries of mysql (that's why the linker step would fail). Chances are you were able to get around it by adding +DA2.0W to the Makefile or mysql_config which would actually link the libraries but they were still having a compatibility problem resulting in the exec format error messages.

Here's the settings I used:

For perl:
1. ./Configure -Ubincompat5005 -Duse64bitall
2. Add the libraries: -lcl -lpthread
before the other libraries.
3. Add "+z +e" to ccflags

I also compiled mysql from scratch:
CC=cc CXX=aCC CFLAGS=+DD64 CXXFLAGS=+DD64 ./configure --prefix=/opt/mysql --with-extra-charsets=complex --enable-thread-safe-client --enable-local-infile --disable-shared

Then I compiled and installed the DBI and DBD with the normal installation instructions.

- Tony