RE: :mysql install problem on HP-UX 11.11

It looks like a 32 bit/64 bit mismatch. Try compiling mysql client for 32 bit and then make DBD

I had this problem 1 year back and had suppiled a HOW TO DOC to this newsgroup to get it working

Send me an email if you need it

Thanks
Madhu



-----Original Message-----
From: Dawn Sun [mailto:[email protected]]
Sent: Friday, September 17, 2004 9:32 AM
To: [email protected]
Subject: DBD::mysql install problem on HP-UX 11.11


Hi Folks,

I am having a problem to install DBD::mysql(2.9003_1) on a HP-UX11.11. The make stopped when tried to compile:

tmp/DBD-mysql-2.9003_1-># perl Makefile.PL
I will use the following settings for compiling and testing:

  cflags        (mysql_config) = -I/usr/local/mysql/include
  libs          (mysql_config) = -L/usr/local/mysql/lib -lmysqlclient -lnsl -lm
  nocatchstderr (default     ) = 0
  nofoundrows   (default     ) = 0
  ssl           (guessed     ) = 0
  testdb        (default     ) = test
  testhost      (default     ) =
  testpassword  (default     ) =
  testuser      (default     ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Using DBI 1.43 (for perl 5.008 on PA-RISC1.1-thread-multi) installed in /opt/perl/lib/site_perl/5.8.0/PA-RISC1.1-thread-multi/auto/DBI
Writing Makefile for DBD::mysql
tmp/DBD-mysql-2.9003_1-># make
        gcc -c  -I/opt/perl/lib/site_perl/5.8.0/PA-RISC1.1-thread-multi/auto/DBI -I/usr/local/mysql/include  -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -fPIC -mpa-risc-1-1
 -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O    -DVERSION=\"2.9003_1\"  -DXS_VERSION=\"2.9003_1\" -fPIC "-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE"
dbdimp.c
        gcc -c  -I/opt/perl/lib/site_perl/5.8.0/PA-RISC1.1-thread-multi/auto/DBI -I/usr/local/mysql/include  -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -fPIC -mpa-risc-1-1
 -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O    -DVERSION=\"2.9003_1\"  -DXS_VERSION=\"2.9003_1\" -fPIC "-I/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/CORE"
mysql.c
Running Mkbootstrap for DBD::mysql ()
        chmod 644 mysql.bs
        rm -f blib/arch/auto/DBD/mysql/mysql.sl
        LD_RUN_PATH="/usr/local/mysql/lib:/lib" /opt/perl/bin/perl myld gcc  -shared -static-libgcc -fPIC dbdimp.o  mysql.o  -o blib/arch/auto/DBD/mysql/mysql.sl   -L/usr/local/mysql/lib -lmysqlclient -lnsl -lm
/usr/ccs/bin/ld: /usr/local/mysql/lib/libmysqlclient.a: Not a valid library (invalid magic
number). Possibly a 64-bit PA archive library (Mismatched ABI).
collect2: ld returned 1 exit status
*** Error exit code 1

Stop.

I didn't install the mysql on the server, I run
/home/mysql/4.0.18-># ./bin/mysql --version
./bin/mysql Ver 12.22 Distrib 4.0.18, for hp-hpux11.11 (hppa2.0w) 

Is this telling the mysql on the server is a wrong version? The HPUX is HP-UX11.11 9000/800. 

Thanks in advance,

Dawn


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]