On Wed, 2004-07-21 at 20:35, Richard Mixon (qwest) wrote:
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.
Yes, but if you look at the log, your build uses .../lib/... paths everywhere. It should use .../lib64/... to pick up the 64 bit versions. Don't know how to teach to the -MCPAN module though. But you can find this somewhere in the docs I guess.. :) BB
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 #