i try my best to install DBD::mySQL from cpan for my plesk server. It still doesn't work..

In the cpan, i tried "install DBD::mysql::Install" and also "install DBD::mysql"

After each install, i check the perl diver, DBD::mySQL still doesn't appear.

What's wrong?

It's hard to say what's wrong. It could be a number of things. Did you try "force install DBD::mysql"? Did you notice any errors when you tried to install the module using CPAN?

Removing previously used /root/.cpan/build/DBD-mysql-2.1017

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 line 169.
readline() on closed filehandle PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle 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


i did do "perl Makefile.PL --cflags=-I/usr/local/psa/mysql" before and enter cpan and do "install DBD::mysql". Another friend say there's a version conflict. How do i go about update my perl inside cpan?

Greetings:

Things to try (in this order):

1. Make sure mySQL is properly installed and working.

2.

perl -MCPAN -e shell

install Bundle::DBI
force install DBD::mysql



Thank you.

Bundle::DBI had being install.

I got the error when i did "force install DBD::mysql"


Removing previously used /root/.cpan/build/DBD-mysql-2.1017

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 line 169.
readline() on closed filehandle PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle 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

Greetings:

It sounds like either mySQL is not installed properly (or installed, but it cannot find the library files (such as in /usr/local/mysql/lib -- location can vary based on how the installation was done).

You may also want to check the Makefile.PL especially around lines 169 to 171 for clues.

Thank you.

mysql is for plesk is at /usr/local/psa/mysql/

i know the place of mysql. where do i go about configure it and point it correctly.