Bug #31199 DBD:MySql install
Submitted: 26 Sep 2007 2:29 Modified: 27 Sep 2007 4:07
Reporter: Tony GUAN Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connectors: DBD::mysql ( Perl ) Severity:S3 (Non-critical)
Version:4.005 OS:Linux (RatHat EL4)
Assigned to: CPU Architecture:Any
Tags: MySQL

[26 Sep 2007 2:29] Tony GUAN
Description:
I would like to install DBD:Mysql in EL4, and can not pass the "make test", the error as below

PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.............install_driver(mysql) failed: Can't load '/usr/local/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.15: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
 at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/00base.t line 38
t/00base.............dubious                                                 
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
        Failed 2/5 tests, 60.00% okay

******** same error with another test ******
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/utf8.t line 49
t/utf8...............dubious                                                 
Failed 26/28 test scripts, 7.14% okay. 423/426 subtests failed, 0.70% okay.
make: *** [test_dynamic] Error 255
[root@dev DBD-mysql-4.005]# 

mysql version : mysql-5.0.41-linux-i686

How to repeat:
unset LANG

 perl Makefile.PL --libs="-L/usr/local/lib -L/usr/local/mysql/lib -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv"

make 

make test
[26 Sep 2007 4:01] Valeriy Kravchuk
Thank you for a problem report. Please, set LD_LIBRARY_PATH before running make test:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/mysql/lib
make test

and check if it makes any difference.
[26 Sep 2007 19:56] Tony GUAN
Greate

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/mysql/lib

perl Makefile.PL --testuser="root" --testpassword="abc" --testdb="test" and --testhost=127.0.0.1

make

make test

every pass were passed

Thank  you so much
[27 Sep 2007 4:07] Valeriy Kravchuk
So, this problem was NOT a result of any bug in MySQL's code.