LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 11-16-2007, 07:57 AM   #1
sajdutt
LQ Newbie
 
Registered: Nov 2007
Location: Makati, Philippines
Posts: 19

Rep: Reputation: 1
DBD::mysql returns bad status


This is what I get after executing: perl -MCPAN -e 'install "DBD::mysql"'

Checking if your kit is complete...
Looks good
Multiple copies of Driver.xst found in: /usr/lib64/perl5/site_perl/5.8.0/auto/DBI/ /usr/lib64/perl5/vendor_perl/5.8.0/x86_64-linux-thread-multi/auto/DBI/ at Makefile.PL line 739
Using DBI 1.601 (for perl 5.008 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/site_perl/5.8.0/auto/DBI/
Writing Makefile for DBD::mysql
Could not read '/root/.cpan/build/DBD-mysql-4.005-odcXNy/META.yml'. Falling back to other methods to determine prerequisites
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -c -I/usr/lib64/perl5/site_perl/5.8.0/auto/DBI -I/usr/include/mysql -g -pipe -march=i386 -mcpu=i686 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -DVERSION=\"4.005\" -DXS_VERSION=\"4.005\" -fPIC "-I/usr/lib64/perl5/5.8.0/x86_64-linux-thread-multi/CORE" dbdimp.c
cc1: CPU you selected does not support x86-64 instruction set
cc1: CPU you selected does not support x86-64 instruction set
make: *** [dbdimp.o] Error 1
CAPTTOFU/DBD-mysql-4.005.tar.gz
/usr/bin/make -- NOT OK
Warning (usually harmless): 'YAML' not installed, will not store persistent state
Running make test
Can't test without successful make
Running make install
Make had returned bad status, install seems impossible

Any suggestion? I removed password for the user root in mysql [server vs. 5.0.45]
Thanks..
 
Old 11-16-2007, 09:05 AM   #2
forrestt
Senior Member
 
Registered: Mar 2004
Location: Cary, NC, USA
Distribution: Fedora, Kubuntu, RedHat, CentOS, SuSe
Posts: 1,288

Rep: Reputation: 99
It is saying you are trying to use a 64 bit instruction set with a 32 bit cpu. Do you have a 64 bit cpu?

Forrest
 
Old 11-16-2007, 09:09 AM   #3
sajdutt
LQ Newbie
 
Registered: Nov 2007
Location: Makati, Philippines
Posts: 19

Original Poster
Rep: Reputation: 1
cat /proc/cpuinfo gives me:

processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 33
model name : Dual Core AMD Opteron(tm) Processor 265
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
stepping : 2
cpu MHz : 1809.297
cache size : 1024 KB
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow
bogomips : 3604.48
TLB size : 1088 4K pages
clflush size : 64
address sizes : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp

processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 33
model name : Dual Core AMD Opteron(tm) Processor 265
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
stepping : 2
cpu MHz : 1809.297
cache size : 1024 KB
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow
bogomips : 3604.48
TLB size : 1088 4K pages
clflush size : 64
address sizes : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp

processor : 2
vendor_id : AuthenticAMD
cpu family : 15
model : 33
model name : Dual Core AMD Opteron(tm) Processor 265
physical id : 1
siblings : 2
core id : 0
cpu cores : 2
stepping : 2
cpu MHz : 1809.297
cache size : 1024 KB
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow
bogomips : 3604.48
TLB size : 1088 4K pages
clflush size : 64
address sizes : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp

processor : 3
vendor_id : AuthenticAMD
cpu family : 15
model : 33
model name : Dual Core AMD Opteron(tm) Processor 265
physical id : 1
siblings : 2
core id : 1
cpu cores : 2
stepping : 2
cpu MHz : 1809.297
cache size : 1024 KB
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow
bogomips : 3604.48
TLB size : 1088 4K pages
clflush size : 64
address sizes : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp

Last edited by sajdutt; 11-16-2007 at 09:23 AM.
 
Old 11-16-2007, 09:32 AM   #4
bdowns
LQ Newbie
 
Registered: Dec 2004
Location: Ambler, PA
Distribution: Fedora Core 2, RedHat 9, FreeBSD 5.3
Posts: 5

Rep: Reputation: 0
I just tried to install this and it failed but not with the same error. Though I did see in the process this portion here that might be of some use:

I will use the following settings for compiling and testing:

cflags (mysql_config ) = -I/usr/local/include/mysql -m64
embedded (mysql_config ) =
libs (mysql_config ) = -L/usr/local/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
mysql_config (Users choice ) = /usr/local/bin/mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (User's choice) = test
testhost (default ) =
testpassword (default ) =
testsocket (default ) =
testuser (User's choice) = root

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

Maybe you need to check those settings.
 
Old 11-16-2007, 09:35 AM   #5
forrestt
Senior Member
 
Registered: Mar 2004
Location: Cary, NC, USA
Distribution: Fedora, Kubuntu, RedHat, CentOS, SuSe
Posts: 1,288

Rep: Reputation: 99
Ok, somehow the configuration for your cpan is trying to compile your 64 bit code with a i686 cpu and the compiler is telling you the cpu doesn't know how to create the instructions. I'm guessing the part of the compiler command "-mcpu=i686" needs to be changed to "-mcpu=x86-64, but I know this is automatically generated. The info is either coming from Perl, CPAN, or MySQL configuration files. From a quick search on the internet, it seems that it is MySQL. This link seems to suggest that upgrading MySQL will fix it:

http://archives.neohapsis.com/archiv...6-q2/2708.html

HTH

Forrest
 
Old 11-16-2007, 09:41 AM   #6
bdowns
LQ Newbie
 
Registered: Dec 2004
Location: Ambler, PA
Distribution: Fedora Core 2, RedHat 9, FreeBSD 5.3
Posts: 5

Rep: Reputation: 0
If you go to the source dir and issue the compile, and install commands manually, you can also pass the path to the MySQL config to Perl to use:

Code:
perl Makefile.PL --mysql_config="/usr/local/bin/mysql_config"
Perl will then build off of that criteria.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Bugzilla - MySQL - perl - DBD::mysql install problem amchargue Linux - Software 3 09-10-2008 12:01 AM
Bugzilla - MySQL - perl - DBD::mysql install problem Runningonair Linux - Software 8 10-12-2007 12:42 AM
DBD::MySQL + MySQL install problems. Elleroth Linux - Software 4 03-24-2006 06:53 AM
Error compiling perl-DBD-MySQL after upgrading to MySQL 4.1 pitaro920 Linux - Software 1 01-16-2006 04:28 PM
Can't install DBD::mysql or DBD::Pg DogTags Mandriva 2 01-21-2004 07:13 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:24 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration