Problems installing DBD::mysql

dthacker has asked for the wisdom of the Perl Monks concerning the following question:

I'm attempting an install of the DBD-mysql module off of CPAN. I'm using perl 5.8 (thanks to another unintentional CPAN upgrade). I've loaded DBI successfully and installed mysql successfully. My OS is RH 7.3 If you're so inclined, please take a look at the error listing below.

CPAN.pm: Going to build J/JW/JWIED/DBD-mysql-2.1017.tar.gz

Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 169.
readline() on closed filehandle main::PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 169.
readline() on closed filehandle main::PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 169.
readline() on closed filehandle main::PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 169.
readline() on closed filehandle main::PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 169.
readline() on closed filehandle main::PIPE at Makefile.PL line 171.
Failed to determine directory of mysql.h. Use

  perl Makefile.PL --cflags=-I<dir>

to set this directory. For details see the INSTALL.html file,
section "C Compiler flags" or type

  perl Makefile.PL --help
Running make test
  Make had some problems, maybe interrupted? Won't test
Running make install 
Make had some problems, maybe interrupted? Won't install
[download]

Thanks in Advance!
Dave

Code On!

Comment on Problems installing DBD::mysql Download Code

Replies are listed 'Best First'.
Re: Problems installing DBD::mysql by fuzzyping (Chaplain) on Aug 12, 2002 at 03:06 UTC
The errors are telling you it can't find mysql_config. My version of /usr/bin/mysql_config is provided by the main MySQL rpm. Are you sure you already have MySQL installed? If so, did you compile manually? If that's the case, perhaps there is a configure flag you missed? Regardless, you're missing mysql_config... or, at the very least, it's not in your $PATH. `[jason@lappy jason]$ rpm -qf /usr/bin/mysql_config mysql-3.23.49-3` [download] -fp	[reply] [d/l]
Re: Problems installing DBD::mysql by xylus (Pilgrim) on Aug 12, 2002 at 20:32 UTC
I just recently had that problem myself. Edit Makefile.PL and where it has something similar to "/usr/bin/mysql_config" change it to where your mysql_config is actually located per your mysql install. That should fix it for you. update: Look on line 169 of Makefile.PL `perl -e '$_=$0;split??;chop$_;$;=pop@_;$;++for(0..9060420);$_.=reverse +$;;print'` [download]	[reply] [d/l]