By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,594 Members | 3,552 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,594 IT Pros & Developers. It's quick & easy.

Install DBD::mysql failed

P: n/a
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_config": No such file or directory at Makefile.PL line
174.
readline() on closed filehandle PIPE at Makefile.PL line 176.
Can't exec "mysql_config": 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_config" --$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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.