473,854 Members | 1,775 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Install DBD::mysql failed

Hello mysql gurus,

I am trying to run perl on mysql database on Red Hat box. I want to install
DBI and DBD:mysql using CPAN:

perl -MCPAN -e shell
cpan>install DBI

The above succeeded, but
cpan>install DBD::mysql

gave me with a lot but same errors:
----------------------------------------------------------------------------
--
cpan> install DBD::mysql
Running install for module DBD::mysql
Running make for R/RU/RUDY/DBD-mysql-2.9003.tar.gz
Fetching with LWP:
ftp://ftp.perl.org/pub/CPAN/authors/...-2.9003.tar.gz
Fetching with LWP:
ftp://ftp.perl.org/pub/CPAN/authors/...RUDY/CHECKSUMS
Checksum for
/root/.cpan/sources/authors/id/R/RU/RUDY/DBD-mysql-2.9003.tar.gz ok
DBD-mysql-2.9003/
DBD-mysql-2.9003/t/
DBD-mysql-2.9003/t/mysql2.t
DBD-mysql-2.9003/t/akmisc.t
DBD-mysql-2.9003/t/60leaks.t
DBD-mysql-2.9003/t/10dsnlist.t
DBD-mysql-2.9003/t/ak-dbd.t
DBD-mysql-2.9003/t/50chopblanks.t
DBD-mysql-2.9003/t/mysql.t
DBD-mysql-2.9003/t/lib.pl
DBD-mysql-2.9003/t/40blobs.t
DBD-mysql-2.9003/t/40nulls.t
DBD-mysql-2.9003/t/insertid.t
DBD-mysql-2.9003/t/40listfields.t
DBD-mysql-2.9003/t/40bindparam.t
DBD-mysql-2.9003/t/mysql.dbtest
DBD-mysql-2.9003/t/dbdadmin.t
DBD-mysql-2.9003/t/20createdrop.t
DBD-mysql-2.9003/t/00base.t
DBD-mysql-2.9003/t/30insertfetch.t
DBD-mysql-2.9003/t/40numrows.t
DBD-mysql-2.9003/t/50commit.t
DBD-mysql-2.9003/t/mysql.mtest
DBD-mysql-2.9003/MANIFEST
DBD-mysql-2.9003/myld
DBD-mysql-2.9003/dbdimp.c
DBD-mysql-2.9003/lib/
DBD-mysql-2.9003/lib/DBD/
DBD-mysql-2.9003/lib/DBD/mysql/
DBD-mysql-2.9003/lib/DBD/mysql/GetInfo.pm
DBD-mysql-2.9003/lib/DBD/mysql/INSTALL.pod
DBD-mysql-2.9003/lib/DBD/mysql.pm
DBD-mysql-2.9003/lib/Mysql/
DBD-mysql-2.9003/lib/Mysql/Statement.pm
DBD-mysql-2.9003/lib/Bundle/
DBD-mysql-2.9003/lib/Bundle/DBD/
DBD-mysql-2.9003/lib/Bundle/DBD/mysql.pm
DBD-mysql-2.9003/lib/Mysql.pm
DBD-mysql-2.9003/dbdimp.h
DBD-mysql-2.9003/mysql.xs
DBD-mysql-2.9003/MANIFEST.SKIP
DBD-mysql-2.9003/README
DBD-mysql-2.9003/INSTALL.html
DBD-mysql-2.9003/Makefile.PL
DBD-mysql-2.9003/ChangeLog
DBD-mysql-2.9003/constants.h
DBD-mysql-2.9003/TODO

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

Can't exec "mysql_conf ig": No such file or directory at Makefile.PL line
174.
readline() on closed filehandle PIPE at Makefile.PL line 176.
Can't exec "mysql_conf ig": No such file or directory at Makefile.PL line
174.
readline() on closed filehandle PIPE at Makefile.PL line 176.
.....

I will use the following settings for compiling and testing:

cflags (guessed) = -I/usr/local/mysql/include
libs (guessed) = -L/usr/local/mysql/lib -lmysqlclient -lz -lgz
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
Unsuccessful stat on filename containing newline at
/usr/lib/perl5/5.8.0/ExtUtils/Liblis
t/Kid.pm line 97.
....
Note (probably harmless): No library found for -lgz
Multiple copies of Driver.xst found in:
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread
-multi/auto/DBI
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBI at Mak
efile.PL line 295
Using DBI 1.38 installed in
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/
DBI
Writing Makefile for DBD::mysql
Makefile:89: *** missing separator. Stop.
/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

cpan>

----------------------------------------------------------------------------
-----

I checked DBD-mysql-2.9003/Makefile.PL, the line 174 is:

open(PIPE, "mysql_conf ig" --$param |");

What is this mysql_config file and where I can find it?

Thanks a lot for the help.

--
Allen Guan

Jul 19 '05 #1
2 7857
It's me again.

I found one problem with installing DBD::mysql.I did not install mysql
shared libraries. After downloaded the shared libraries RPM from
www.mysql.com and installed them, I tried again and the errors are reduced
considerably.

cpan>install DBD::mysql

Unsuccessful stat on filename containing newline at
/usr/lib/perl5/5.8.0/ExtUtils/Liblis t/Kid.pm line 97.
Multiple copies of Driver.xst found
in:/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/usr/lib/p
erl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBI at Makefile.PL line
295
Using DBI 1.38 installed in
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI
Writing Makefile for DBD::mysql
Makefile:89: *** missing separator. Stop.
/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
Can anybbody helps here? I am using RedHat 9.

Thanks a bunch!

Allen Guan

Jul 19 '05 #2
It's me again.

I found one problem with installing DBD::mysql.I did not install mysql
shared libraries. After downloaded the shared libraries RPM from
www.mysql.com and installed them, I tried again and the errors are reduced
considerably.

cpan>install DBD::mysql

Unsuccessful stat on filename containing newline at
/usr/lib/perl5/5.8.0/ExtUtils/Liblis t/Kid.pm line 97.
Multiple copies of Driver.xst found
in:/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/usr/lib/p
erl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBI at Makefile.PL line
295
Using DBI 1.38 installed in
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI
Writing Makefile for DBD::mysql
Makefile:89: *** missing separator. Stop.
/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
Can anybbody helps here? I am using RedHat 9.

Thanks a bunch!

Allen Guan

Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
3323
by: Randell D. | last post by:
Folks, I have installed MySQL v4 (client, server and development rpm's). I've tried and failed to use the recommended mysqladmin to set a root password after the installation (I have another post open on the MySQL newsgroup about this). I'm attempting an alternative solution and using webmin (www.webmin.com) to create/manage access to my databases. Webmin reports "Warning: The Perl module DBD::mysql is not installed on your system, so...
0
1810
by: Madhu Nair | last post by:
I am getting errors while compiling DBD-mysql 2.9002 on HP-UX 11.00 I have perl 5.8 downloaded from HP depot installed at /opt/perl Mysql 4.0.13 compiled myself with gcc with Mysql recommended options and working fine I am getting this error ..... Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs
0
1471
by: Yun Guan | last post by:
Hello mysql gurus, I am trying to run perl on mysql database on Red Hat box. I want to install DBI and DBD:mysql using CPAN: perl -MCPAN -e shell cpan>install DBI The above succeeded, but cpan>install DBD::mysql
0
9018
by: packrat | last post by:
I am attempting to build a Bugzilla server on OS X. All of this is new to me, working with the Perl, MySQL, and Bugzilla, so I have been banging my head often. Software error: When I run the bugzilla 'checksetup.pl' file, I get the following: -------------------------------------------------------------------
1
2629
by: Yun Guan | last post by:
Hello, I have problems installing DBD:mysql on Red Hat Linux 9, either from CPAN, or mannual install. The error is the same, something related to this Kid.pm file under perl. Should I reinstall Perl? Perl came with Red Hat Linux 9 installation. Please help. 1.) from CPAN: perl -MCPAN -e shell
0
1667
by: vetolimits | last post by:
Hi everyone, Machine info: Fedora Core 3, MySQL-server-4.1.9, and perl-DBD-MySQL-2.9003-5 When I try to use mysqlhotcopy command to backup database, following error occurs :(& install_driver(mysql) failed: DBD::mysql object version 2.9003 does not match bootstrap parameter 2.0419 at
3
7018
by: Nick | last post by:
hi, all I have a red hat 9 and looks like it had mysql 3.2.54 installed before, but, actually not, i can not find the install folder and I can not uninstall it. So I am trying to install/upgrade to 4.1, but, still can not get it work. Here is what I did: # rpm -Uvh MySQL-server-standard-4.1.14-0.rhel4.i386.rpm warning: MySQL-server-standard-4.1.14-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
0
3471
by: pvannie | last post by:
Hello there, I've been trying to install DBD::mysql on Mac OS X Server 10.3 for 2 days, but it still raises error. So I'm going to send this message to ask for help. Any help will be much appreciated. Here is what I've tried to install the DBD::mysql module: 1> Download DBD-mysql-2.9003 and un-zip it 2> cd to DBD-mysql-2.9003 directory
1
2315
by: pvannie | last post by:
Hello there, I've been trying to install DBD::mysql on Mac OS X Server 10.3 for 2 days, but it still raises error. So I'm going to send this message to ask for help. Any help will be much appreciated. Here is what I've tried to install the DBD::mysql module: 1> Download DBD-mysql-2.9003 and un-zip it 2> cd to DBD-mysql-2.9003 directory
1
5404
by: theschaef | last post by:
Hi there. I am using perl to connect to a database and then pull the rows off of the table one by one to manipulate the data. If I use a smaller table (~8 MB), I wait for around 20 seconds but then the table values are read just fine. However if I use a larger table (~30 MB), I wait for a while and then I get the message: DBD::mysql::st execute failed: Lost connection to MySQL server during query I have tried searching for the...
0
9899
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9750
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11024
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10672
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10740
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9510
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5738
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5937
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4149
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.