dbd::mysql install troubles

Hi List,

Im having problems getting DBD::mysql working with perl 5.8.0

I can get it to make and install but it always fails on make test.

Here is the output:

make test
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
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) 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
t/10dsnlist..........install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/10dsnlist.t line 45
t/10dsnlist..........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/20createdrop.......install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/20createdrop.t line 45
t/20createdrop.......dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-5
Failed 5/5 tests, 0.00% okay
t/30insertfetch......install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/30insertfetch.t line 48
t/30insertfetch......dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/35limit............install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/35limit.t line 50
t/35limit............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-113
Failed 113/113 tests, 0.00% okay
t/40bindparam........install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
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/40bindparam.t line 64
t/40bindparam........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-27
Failed 27/27 tests, 0.00% okay
t/40blobs............install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40blobs.t line 68
t/40blobs............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40listfields.......install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40listfields.t line 57
t/40listfields.......dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-18
Failed 18/18 tests, 0.00% okay
t/40nulls............install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40nulls.t line 50
t/40nulls............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40numrows..........install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40numrows.t line 59
t/40numrows..........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-25
Failed 25/25 tests, 0.00% okay
t/41blobs_prepare....install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/41blobs_prepare.t line 71
t/41blobs_prepare....dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-24
Failed 24/24 tests, 0.00% okay
t/50chopblanks.......install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/50chopblanks.t line 57
t/50chopblanks.......dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-35
Failed 35/35 tests, 0.00% okay
t/50commit...........install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/50commit.t line 64
t/50commit...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-30
Failed 30/30 tests, 0.00% okay
t/60leaks............skipped
all skipped: $ENV{SLOW_TESTS} is not set or Proc::ProcessTable not installed
t/ak-dbd.............install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/ak-dbd.t line 59
t/ak-dbd.............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-90
Failed 90/90 tests, 0.00% okay
t/akmisc.............Had to create DBD::mysql::dr::imp_data_size
unexpectedly at
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBI.pm line 1167.
Can't locate object method "connect" via package "Mysql" at
/root/.cpan/build/DBD-mysql-3.0002/blib/lib/Mysql.pm line 71.
t/akmisc.............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-351
Failed 351/351 tests, 0.00% okay
t/dbdadmin...........install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/dbdadmin.t line 74
t/dbdadmin...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-21
Failed 21/21 tests, 0.00% okay
t/insertid...........install_driver(mysql) failed: Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/insertid.t line 13
t/insertid...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-12
Failed 12/12 tests, 0.00% okay
t/mysql..............Can't load
'/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/root/.cpan/build/DBD-mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at /root/.cpan/build/DBD-mysql-3.0002/blib/lib/Mysql.pm line 13
Compilation failed in require at
/root/.cpan/build/DBD-mysql-3.0002/blib/lib/Mysql.pm
line 13.
Compilation failed in require at t/mysql.t line 34.
BEGIN failed--compilation aborted at t/mysql.t line 34.
t/mysql..............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-68
Failed 68/68 tests, 0.00% okay
t/mysql2.............Had to create DBD::mysql::dr::imp_data_size
unexpectedly at
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBI.pm line 1167.
Use of uninitialized value in subroutine entry at
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBI.pm line 1167.
Can't locate object method "connect" via package "Mysql" at
/root/.cpan/build/DBD-mysql-3.0002/blib/lib/Mysql.pm line 71.
t/mysql2.............dubious
Test returned status 255 (wstat 65280, 0xff00)
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/00base.t 255 65280 5 2 40.00% 4-5
t/10dsnlist.t 255 65280 9 9 100.00% 1-9
t/20createdrop.t 255 65280 5 5 100.00% 1-5
t/30insertfetch.t 255 65280 11 11 100.00% 1-11
t/35limit.t 255 65280 113 113 100.00% 1-113
t/40bindparam.t 255 65280 27 27 100.00% 1-27
t/40blobs.t 255 65280 11 11 100.00% 1-11
t/40listfields.t 255 65280 18 18 100.00% 1-18
t/40nulls.t 255 65280 11 11 100.00% 1-11
t/40numrows.t 255 65280 25 25 100.00% 1-25
t/41blobs_prepare.t 255 65280 24 24 100.00% 1-24
t/50chopblanks.t 255 65280 35 35 100.00% 1-35
t/50commit.t 255 65280 30 30 100.00% 1-30
t/ak-dbd.t 255 65280 90 90 100.00% 1-90
t/akmisc.t 255 65280 351 351 100.00% 1-351
t/dbdadmin.t 255 65280 21 21 100.00% 1-21
t/insertid.t 255 65280 12 12 100.00% 1-12
t/mysql.t 255 65280 68 68 100.00% 1-68
t/mysql2.t 255 65280 ?? ?? % ??
1 test skipped.
Failed 19/20 test scripts, 5.00% okay. 863/866 subtests failed, 0.35% okay.
make: *** [test_dynamic] Error 2


Many Thanks

Rachel