List:General Discussion« Previous MessageNext Message »
From:Jørn Dahl-Stamnes Date:December 21 2007 10:13am
Subject:Re: Mysql and Perl
View as plain text  
On Monday 25 September 2006 20:09, George Law wrote:
> damn outlook!
>
> fire up perl's CPAN interface:
>
> perl -MCPAN -eshell
>
>
> cpan> i /mysql/
> ...
> Bundle          Bundle::DBD::mysql (C/CA/CAPTTOFU/DBD-mysql-3.0007.tar.gz)
> ...
> cpan> install  Bundle::DBD::mysql

Hello again... I'm back to this problem I had over a year ago. Yesterday I had 
to reinstall my system, since the disk containint the OS crashed. After a few 
hours I was back in businness again - except for the Perl module. My perl 
scripts does not work anymore.

I have tried to install the Bundle::DBD::mysql, but it failes with the same 
error I had last time (see below). Somehow I managed to fix this the last 
time, but I forgot to write down what I did (shame on me).

So... is there any kind soul out there that can give me some hints about how 
to fix this problem?

Output when installing the bundle:
--------------------------------------------------------------
cpan> install Bundle::DBD::mysql
DBI is up to date.
Data::ShowTable is up to date.
Running install for module Mysql
Running make for R/RU/RUDY/DBD-mysql-2.9008.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.9008.tar.gz 
ok
Scanning cache /root/.cpan/build for sizes
DBD-mysql-2.9008/
DBD-mysql-2.9008/t/
DBD-mysql-2.9008/t/60leaks.t
DBD-mysql-2.9008/t/40listfields.t
DBD-mysql-2.9008/t/10dsnlist.t
DBD-mysql-2.9008/t/40numrows.t
DBD-mysql-2.9008/t/30insertfetch.t
DBD-mysql-2.9008/t/00base.t
DBD-mysql-2.9008/t/insertid.t
DBD-mysql-2.9008/t/50commit.t
DBD-mysql-2.9008/t/40nulls.t
DBD-mysql-2.9008/t/dbdadmin.t
DBD-mysql-2.9008/t/lib.pl
DBD-mysql-2.9008/t/20createdrop.t
DBD-mysql-2.9008/t/mysql.dbtest
DBD-mysql-2.9008/t/40bindparam.t
DBD-mysql-2.9008/t/mysql.t
DBD-mysql-2.9008/t/40blobs.t
DBD-mysql-2.9008/t/akmisc.t
DBD-mysql-2.9008/t/50chopblanks.t
DBD-mysql-2.9008/t/ak-dbd.t
DBD-mysql-2.9008/t/mysql2.t
DBD-mysql-2.9008/lib/
DBD-mysql-2.9008/lib/DBD/
DBD-mysql-2.9008/lib/DBD/mysql/
DBD-mysql-2.9008/lib/DBD/mysql/GetInfo.pm
DBD-mysql-2.9008/lib/DBD/mysql/INSTALL.pod
DBD-mysql-2.9008/lib/DBD/mysql.pm
DBD-mysql-2.9008/lib/Bundle/
DBD-mysql-2.9008/lib/Bundle/DBD/
DBD-mysql-2.9008/lib/Bundle/DBD/mysql.pm
DBD-mysql-2.9008/lib/Mysql/
DBD-mysql-2.9008/lib/Mysql/Statement.pm
DBD-mysql-2.9008/lib/Mysql.pm
DBD-mysql-2.9008/TODO
DBD-mysql-2.9008/myld
DBD-mysql-2.9008/constants.h
DBD-mysql-2.9008/dbdimp.c
DBD-mysql-2.9008/dbdimp.h
DBD-mysql-2.9008/README
DBD-mysql-2.9008/MANIFEST.SKIP
DBD-mysql-2.9008/Makefile.PL
DBD-mysql-2.9008/META.yml
DBD-mysql-2.9008/INSTALL.html
DBD-mysql-2.9008/ChangeLog
DBD-mysql-2.9008/MANIFEST
DBD-mysql-2.9008/mysql.xs
Removing previously used /root/.cpan/build/DBD-mysql-2.9008

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

I will use the following settings for compiling and testing:

  cflags        (mysql_config) = -I/usr/include/mysql -g -pipe 
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 
-fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 
-D_LARGEFILE_SOURCE -fno-strict-aliasing
  libs          (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt 
-lnsl -lm -L/usr/lib -lssl -lcrypto
  mysql_config  (guessed     ) = mysql_config
  nocatchstderr (default     ) = 0
  nofoundrows   (default     ) = 0
  ssl           (guessed     ) = 1
  testdb        (default     ) = test
  testhost      (default     ) =
  testpassword  (default     ) =
  testsocket    (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.48 (for perl 5.008006 on x86_64-linux-thread-multi) installed 
in /usr/lib64/perl5/vendor_perl/5.8.6/x86_64-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::mysql
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
gcc -c  
-I/usr/lib64/perl5/vendor_perl/5.8.6/x86_64-linux-thread-multi/auto/DBI/ 
-I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 
-march=i386 -mtune=pentium4 -fasynchronous-unwind-tables -D_GNU_SOURCE 
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing 
-DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -D_REENTRANT 
-D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include 
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe 
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m64 -mtune=nocona   
-DVERSION=\"2.9008\" -DXS_VERSION=\"2.9008\" -fPIC 
"-I/usr/lib64/perl5/5.8.6/x86_64-linux-thread-multi/CORE"   dbdimp.c
dbdimp.c:1: error: CPU you selected does not support x86-64 instruction set
make: *** [dbdimp.o] Error 1
  /usr/bin/make  -- NOT OK
Running make test
  Can't test without successful make
Running make install
  make had returned bad status, install seems impossible
Running install for module DBD::mysql
Running make for R/RU/RUDY/DBD-mysql-2.9008.tar.gz
  Is already unwrapped into directory /root/.cpan/build/DBD-mysql-2.9008
  Has already been processed within this session
Running make test
  Can't test without successful make
Running make install
  make had returned bad status, install seems impossible
Bundle summary: The following items in bundle Bundle::DBD::mysql had
installation problems:
  Mysql DBD::mysql



root@jedi ~]# uname -a
Linux jedi.dahl-stamnes.net 2.6.11-1.1369_FC4 #1 Thu Jun 2 22:56:33 EDT 2005 
x86_64 x86_64 x86_64 GNU/Linux

-- 
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
Thread
Mysql and PerlJørn Dahl-Stamnes25 Sep
  • RE: Mysql and PerlGeorge Law25 Sep
  • RE: Mysql and PerlGeorge Law25 Sep
    • Re: Mysql and PerlJørn Dahl-Stamnes21 Dec
Re: Mysql and PerlJørn Dahl-Stamnes26 Sep