Problem installing perl DBD::mysql for mtop

21 Jul 2004

      Hello,

I am trying to get the MySQL performance monitoring tool "mtop" running
on my dual Opteron system under SLES 8 for AMD64. Before my server load
gets too high, I want to be able to start tuning performance.

However I get errors when trying to install the perl DBD::mysql package.
I need some help/ideas.

BACKGROUND (to understand my environment)
I must admit five months ago when I setup this server it was my first
time with SLES (of any type). I had upgrade a number of packages beyond
what was available as standard SLES8 for AMD64 packages, including:
 - MySQL 4.0.18
 - Apache 2.0.xx
 - Jakarta Tomcat 5.0.19
 - Postfix 2.0.14 (my HOWTO for cyrus-imap, mysql and amavis-new asked
for later version than SLES8)
 - Mail-SpamAssassin-2.63
 - PHP 4.3.3 for MyAdmin (PHP MySQL web interface)
 - perl-5.8.1-43.x86_64.rpm
In spite of the above, all has worked very reliably and performed better
than expected. So I've been happy given I has to wear multiple hats -
web/Java developer for our website and system administrator :)

ASIDE: The only downside has been having to be careful when applying YOU
updates so that I do not wipe out packages I have compiled  or installed
manually. In hindsite, given my requirements for more recent Tomcat and
MySQL, I should probably gone with SuSE Pro 9.0 for AMD64. Given the
above hacks I have compromised my ability to receive  SLES 8 support, so
that was probably a waste of money. Opinions?

CURRENT PROBLEM DETAILS:

As I wrote above, when I try and install the DBD:mysql package it fails.
Googling has not found the exact error messages, but similar messages
were attributed to having 32-bit perl and a 64-bit MySQL client. However
when I look at the perl version it says it is compiled for 64-bit.

So I am wondering if I am pointing to the wrong MySQL libraries, but not
sure what I am looking for now.

I have included the output from "uname -a" and "perl -v" as well as the
error messages I get when I try and install DBD::mysql. Any help or
suggestions are appreciated.

Thank you - Richard

kingfish:/opt/mtop-0.6.4 # uname -a
Linux kingfish 2.4.21-231-smp #1 SMP Mon Jun 28 14:13:46 UTC 2004 x86_64
unknown
kingfish:/opt/mtop-0.6.4 # perl -v

This is perl, v5.8.0 built for x86_64-linux-thread-multi

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.

kingfish:/opt/mtop-0.6.4 # perl -MCPAN -e 'install DBD::mysql' 2>&1
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
  Database was generated on Tue, 20 Jul 2004 20:15:17 GMT
Running install for module DBD::mysql
Running make for R/RU/RUDY/DBD-mysql-2.9004.tar.gz
CPAN: Digest::MD5 loaded ok
CPAN: Compress::Zlib loaded ok
Checksum for
/root/.cpan/sources/authors/id/R/RU/RUDY/DBD-mysql-2.9004.tar.gz ok
Scanning cache /root/.cpan/build for sizes
DBD-mysql-2.9004/
DBD-mysql-2.9004/t/
DBD-mysql-2.9004/t/mysql2.t
DBD-mysql-2.9004/t/akmisc.t
DBD-mysql-2.9004/t/60leaks.t
DBD-mysql-2.9004/t/10dsnlist.t
DBD-mysql-2.9004/t/ak-dbd.t
DBD-mysql-2.9004/t/50chopblanks.t
DBD-mysql-2.9004/t/mysql.t
DBD-mysql-2.9004/t/lib.pl
DBD-mysql-2.9004/t/40blobs.t
DBD-mysql-2.9004/t/40nulls.t
DBD-mysql-2.9004/t/insertid.t
DBD-mysql-2.9004/t/40listfields.t
DBD-mysql-2.9004/t/40bindparam.t
DBD-mysql-2.9004/t/mysql.dbtest
DBD-mysql-2.9004/t/dbdadmin.t
DBD-mysql-2.9004/t/20createdrop.t
DBD-mysql-2.9004/t/00base.t
DBD-mysql-2.9004/t/30insertfetch.t
DBD-mysql-2.9004/t/40numrows.t
DBD-mysql-2.9004/t/50commit.t
DBD-mysql-2.9004/t/mysql.mtest
DBD-mysql-2.9004/MANIFEST
DBD-mysql-2.9004/myld
DBD-mysql-2.9004/dbdimp.c
DBD-mysql-2.9004/lib/
DBD-mysql-2.9004/lib/DBD/
DBD-mysql-2.9004/lib/DBD/mysql/
DBD-mysql-2.9004/lib/DBD/mysql/GetInfo.pm
DBD-mysql-2.9004/lib/DBD/mysql/INSTALL.pod
DBD-mysql-2.9004/lib/DBD/mysql.pm
DBD-mysql-2.9004/lib/Mysql/
DBD-mysql-2.9004/lib/Mysql/Statement.pm
DBD-mysql-2.9004/lib/Bundle/
DBD-mysql-2.9004/lib/Bundle/DBD/
DBD-mysql-2.9004/lib/Bundle/DBD/mysql.pm
DBD-mysql-2.9004/lib/Mysql.pm
DBD-mysql-2.9004/dbdimp.h
DBD-mysql-2.9004/mysql.xs
DBD-mysql-2.9004/MANIFEST.SKIP
DBD-mysql-2.9004/README
DBD-mysql-2.9004/INSTALL.html
DBD-mysql-2.9004/META.yml
DBD-mysql-2.9004/Makefile.PL
DBD-mysql-2.9004/ChangeLog
DBD-mysql-2.9004/constants.h
DBD-mysql-2.9004/TODO
Removing previously used /root/.cpan/build/DBD-mysql-2.9004

  CPAN.pm: Going to build R/RU/RUDY/DBD-mysql-2.9004.tar.gz

I will use the following settings for compiling and testing:

  cflags        (mysql_config) = -I/usr/include/mysql -g
  libs          (mysql_config)
= -L/usr/lib -lmysqlclient -lz -lcrypt -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'.

Checking if your kit is complete...
Looks good
Using DBI 1.43 (for perl 5.008 on x86_64-linux-thread-multi) installed
in /usr/lib/perl5/site_perl/5.8.0/x86_64-linux-thread-multi/auto/DBI
Writing Makefile for DBD::mysql
cc -c  -I/usr/lib/perl5/site_perl/5.8.0/x86_64-linux-thread-multi/auto/D
BI -I/usr/include/mysql -g -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasi
ng -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 --pipe   -DVERSION=\"2
.9004\" -DXS_VERSION=\"2.9004\" -fPIC
"-I/usr/lib/perl5/5.8.0/x86_64-linux-thread-multi/CORE"   dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g"
/usr/lib/perl5/site_perl/5.8.0/x86_64-linux-thread-multi/auto/DBI/Driver
.xst > mysql.xsi
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
/usr/bin/perl /usr/lib/perl5/5.8.0/ExtUtils/xsubpp  -typemap
/usr/lib/perl5/5.8.0/ExtUtils/typemap  mysql.xs > mysql.xsc && mv
mysql.xsc mysql.c
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Warning: duplicate function definition 'do' detected in mysql.xs, line
196
Warning: duplicate function definition 'rows' detected in mysql.xs, line
294
cc -c  -I/usr/lib/perl5/site_perl/5.8.0/x86_64-linux-thread-multi/auto/D
BI -I/usr/include/mysql -g -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasi
ng -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 --pipe   -DVERSION=\"2
.9004\" -DXS_VERSION=\"2.9004\" -fPIC
"-I/usr/lib/perl5/5.8.0/x86_64-linux-thread-multi/CORE"   mysql.c
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib64:/usr/lib" /usr/bin/perl myld
cc  -shared -L/usr/local/lib64 dbdimp.o mysql.o  -o
blib/arch/auto/DBD/mysql/mysql.so   -L/usr/lib -lmysqlclient -lz -lcrypt
 -lnsl -lm
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /usr/lib/libz.so when searching for -lz
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /usr/lib/libcrypt.so when searching
for -lcrypt
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /usr/lib/libcrypt.a when searching
for -lcrypt
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /usr/lib/libnsl.so when searching
for -lnsl
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /usr/lib/libnsl.a when searching
for -lnsl
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /usr/lib/libm.so when searching for -lm
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /usr/lib/libm.a when searching for -lm
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: skipping incompatible /lib/libc.so.6 when searching for
/lib/libc.so.6
/usr/lib64/gcc-lib/x86_64-suse-linux/3.2.2/../../../../x86_64-suse-linux
/bin/ld: cannot find /lib/libc.so.6
collect2: ld returned 1 exit status
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
chmod: failed to get attributes of `blib/arch/auto/DBD/mysql/mysql.so':
No such file or directory
make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1
  /usr/bin/make -j3 -- NOT OK
Running make test
  Can't test without successful make
Running make install
  make had returned bad status, install seems impossible
kingfish:/opt/mtop-0.6.4 #

Problem installing perl DBD::mysql for mtop

Richard Mixon (qwest)