LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Bugzilla - MySQL - perl - DBD::mysql install problem (https://www.linuxquestions.org/questions/linux-software-2/bugzilla-mysql-perl-dbd-mysql-install-problem-492157/)

amchargue 10-13-2006 03:10 PM

Bugzilla - MySQL - perl - DBD::mysql install problem
 
This is similar to http://www.linuxquestions.org/questi...d.php?t=300334 , but not quite the same.

From ~/.cpan/build/DBD-mysql-3.0007, I do:
perl Makefile.PL --cflags=-I/usr/local/mysql/include --libs=/usr/local/mysql/lib (no errors)
make (no errors)
make test

My make test (output below) ended with : Failed 22/23 test scripts, 4.35% okay. 437/440 subtests failed, 0.68% okay.
make: *** [test_dynamic] Error 2 .
I went ahead and did a make install, that worked. But then when I run my script (happens to be a Bugzilla test script), I get:
perl: relocation error: /usr/local/perl/lib/site_perl/5.8.7/i686-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init

What's up with that?
Andy

===================
make test output :
===================

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/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 4-5
Failed 2/5 tests, 60.00% okay
t/10dsnlist..........install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/10dsnlist.t line 45
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/20createdrop.......install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/20createdrop.t line 45
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-5
Failed 5/5 tests, 0.00% okay
t/30insertfetch......install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/30insertfetch.t line 48
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/35limit............install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/35limit.t line 50
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-113
Failed 113/113 tests, 0.00% okay
t/35prepare..........install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/35prepare.t line 37
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-30
Failed 30/30 tests, 0.00% okay
t/40bindparam........install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40bindparam.t line 64
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-28
Failed 28/28 tests, 0.00% okay
t/40bindparam2.......install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40bindparam2.t line 64
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-13
Failed 13/13 tests, 0.00% okay
t/40blobs............install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/40blobs.t line 64
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40listfields.......install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/40listfields.t line 57
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-18
Failed 18/18 tests, 0.00% okay
t/40nulls............install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/40nulls.t line 50
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40numrows..........install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/40numrows.t line 59
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-25
Failed 25/25 tests, 0.00% okay
t/41bindparam........install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/41bindparam.t line 37
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/41blobs_prepare....install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/41blobs_prepare.t line 71
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-24
Failed 24/24 tests, 0.00% okay
t/42bindparam........install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/42bindparam.t line 37
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/50chopblanks.......install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/50chopblanks.t line 57
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-35
Failed 35/35 tests, 0.00% okay
t/50commit...........install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/50commit.t line 64
dubious
Test returned status 2 (wstat 512, 0x200)
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/dbdadmin...........install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/dbdadmin.t line 74
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-21
Failed 21/21 tests, 0.00% okay
t/insertid...........install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/insertid.t line 13
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-12
Failed 12/12 tests, 0.00% okay
t/param_values.......install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/param_values.t line 16
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-8
Failed 8/8 tests, 0.00% okay
t/prepare_noerror....install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/prepare_noerror.t line 22
dubious
Test returned status 2 (wstat 512, 0x200)
t/texecute...........install_driver(mysql) failed: Can't load '/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: mysql_stmt_free_result at /usr/local/perl/lib/5.8.7/i686-linux/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/texecute.t line 17
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/00base.t 2 512 5 4 80.00% 4-5
t/10dsnlist.t 2 512 9 18 200.00% 1-9
t/20createdrop.t 2 512 5 10 200.00% 1-5
t/30insertfetch.t 2 512 11 22 200.00% 1-11
t/35limit.t 2 512 113 226 200.00% 1-113
t/35prepare.t 2 512 30 60 200.00% 1-30
t/40bindparam.t 2 512 28 56 200.00% 1-28
t/40bindparam2.t 2 512 13 26 200.00% 1-13
t/40blobs.t 2 512 11 22 200.00% 1-11
t/40listfields.t 2 512 18 36 200.00% 1-18
t/40nulls.t 2 512 11 22 200.00% 1-11
t/40numrows.t 2 512 25 50 200.00% 1-25
t/41bindparam.t 2 512 11 22 200.00% 1-11
t/41blobs_prepare.t 2 512 24 48 200.00% 1-24
t/42bindparam.t 2 512 11 22 200.00% 1-11
t/50chopblanks.t 2 512 35 70 200.00% 1-35
t/50commit.t 2 512 30 60 200.00% 1-30
t/dbdadmin.t 2 512 21 42 200.00% 1-21
t/insertid.t 2 512 12 24 200.00% 1-12
t/param_values.t 2 512 8 16 200.00% 1-8
t/prepare_noerror.t 2 512 ?? ?? % ??
t/texecute.t 2 512 9 18 200.00% 1-9
1 test skipped.
Failed 22/23 test scripts, 4.35% okay. 437/440 subtests failed, 0.68% okay.
make: *** [test_dynamic] Error 2

jstar 04-10-2008 11:36 PM

Hey Andy,
Did you ever find a solution to your Bugzilla/DBD::mysql install? I am getting the same error:

checking for DBD-mysql (v2.9003) ok: found v4.006
/usr/bin/perl: relocation error: /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/auto/DBD/mysql/mysql.so: undefined symbol: mysql_server_init

Any help would be greatly appreciated. Thanks!

jbiz 09-10-2008 12:10 AM

Solved?
 
Did anyone ever solve this issue? I'm still facing it. Thanks.

chrism01 09-10-2008 01:01 AM

Try www.perlmonks.org


All times are GMT -5. The time now is 04:06 PM.