[perl] DBD-mysql 모듈 경로지정해서 설치하기

Perl 에서 DBD-mysql 모듈을 설치했을때 
Mysql기본경로가 다를경우 에러가 발생합니다.

perl Makefile.PL 

을 실행했을시에...

Can't exec "mysql_config": 그런 파일이나 디렉토리가 없음 at Makefile.PL line 83.

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": 그런 파일이나 디렉토리가 없음 at Makefile.PL line 478.

Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located

Can't exec "mysql_config": 그런 파일이나 디렉토리가 없음 at Makefile.PL line 478.

Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located

Can't exec "mysql_config": 그런 파일이나 디렉토리가 없음 at Makefile.PL line 478.

Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located

PLEASE NOTE:

For 'make test' to run properly, you must ensure that the

database user 'root' can connect to your MySQL server

and has the proper privileges that these tests require such

as 'drop table', 'create table', 'drop procedure', 'create procedure'

as well as others.

mysql> grant all privileges on test.* to 'root'@'localhost' identified by 's3kr1t';

You can also optionally set the user to run 'make test' with:

perl Makefile.PL --testuser=username

Can't exec "mysql_config": 그런 파일이나 디렉토리가 없음 at Makefile.PL line 478.

Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located

Can't exec "mysql_config": 그런 파일이나 디렉토리가 없음 at Makefile.PL line 478.

Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located

Can't exec "mysql_config": 그런 파일이나 디렉토리가 없음 at Makefile.PL line 478.

Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located

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

라는 에러가 발생하네요.


해결방법으로는..

perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config

라고 --mysql_config에 mysql경로를 미리 알려주면 간단히 해결됩니다~




==============================================================

/usr/bin/ld: cannot find -lz

collect2: ld returned 1 exit status

요런 에러가 나타났을땐 zlib 을 설치해야한다.

http://www.zlib.net/  에가서 tar버전을 다운받은후

아래와같은 과정을 거친다.

tar xvfzp zlib-1.2.6.tar.gz
mv zlib-1.2.6 /usr/local/zlib
cd /usr/local/zlib/
./configure -s
make
./configure
make install
ls -alF libz.so* 치면
    lrwxrwxrwx 1 root root    13  2월 20 13:18 libz.so -> libz.so.1.2.6*

    lrwxrwxrwx 1 root root    13  2월 20 13:18 libz.so.1 -> libz.so.1.2.6*

    -rwxr-xr-x 1 root root 92821  2월 20 13:18 libz.so.1.2.6*
cp libz.so* /usr/local/lib
cd /usr/local/lib
rm -rf libz.so libz.so.1
ln -s libz.so.1.2.6 libz.so
ln -s libz.so.1.2.6 libz.so.1
vi /etc/ld.so.conf  ==> /usr/local/lib 추가하고
ldconfig 

이후 make install시 에러가 나지 않고 설치완료된다!