DBD::mysql and Can't exec "mysql_config": No such file or directory at Makefile.PL error

I was trying to install ‘DBD-mysql-4.018’ on OpenSuse 11.3 box and have following set of packages installed for MySQL.

-------------------------START----------------------->

linux:/home/Builder/DBD-mysql-4.018 # rpm -qa | grep -i mysql
php5-mysql-5.3.3-0.7.1.i586
libmysqlclient_r16-5.1.46-2.18.i586
mysql-community-server-client-5.1.46-2.18.i586
mysql-community-server-5.1.46-2.18.i586
libmysqlclient16-5.1.46-2.18.i586
libqt4-sql-mysql-4.6.3-1.3.i586
perl-DBD-mysql-4.014-1.10.i586

<------------------------END--------------------------

Interestingly, when I tried to run CLI ‘perl Makefile.PL’, it ran into following set issue…

------------------------START------------------------->

linux:/home/Builder/DBD-mysql-4.018 # perl Makefile.PL
Can't exec "mysql_config": No such file or directory at Makefile.PL line 82.

Cannot find the file 'mysql_config'! Your execution PATH doesn't seem
not contain the path to mysql_config. Resorting to guessed values!
Can't exec "mysql_config": No such file or directory at Makefile.PL line 464.
Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located
Can't exec "mysql_config": No such file or directory at Makefile.PL line 464.
Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located
Can't exec "mysql_config": No such file or directory at Makefile.PL line 464.
Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located

<------------------------END--------------------------

I tried to Google for this issue but couldn’t find exact steps. To resolve this issue, I have installed libmysqlclient-devel-5.1.46-2.18.i586.rpm package on my OpenSuse 11.3 box.

Now same rpm query for MySQL packages results in following output…

------------------------START----------------------->

linux:/home/mandar/Builder/DBD-mysql-4.018 # rpm -qa | grep -i mysql
=php5-mysql-5.3.3-0.7.1.i586
libmysqlcppconn1-1.0.5-6.2.i586
libmysqlclient_r16-5.1.46-2.18.i586
mysql-community-server-client-5.1.46-2.18.i586
mysql-community-server-5.1.46-2.18.i586
libmysqlcppconn-devel-1.0.5-6.2.i586
libmysqlclient-devel-5.1.46-2.18.i586
libmysqlclient16-5.1.46-2.18.i586
libqt4-sql-mysql-4.6.3-1.3.i586
perl-DBD-mysql-4.014-1.10.i586

<-----------------------END---------------------------

This has resolved issue with DBD::mysql module on OpenSuse 11.3

By Mandar Pise

Opinions expressed by techsutram contributors are their own.

No comments:

Post a Comment

    Your valuable comments are welcome. (Moderated)


Instagram