LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 10-13-2006, 03:10 PM   #1
amchargue
LQ Newbie
 
Registered: Oct 2006
Posts: 9

Rep: Reputation: 0
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
 
Old 04-10-2008, 11:36 PM   #2
jstar
LQ Newbie
 
Registered: Apr 2008
Posts: 1

Rep: Reputation: 0
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!
 
Old 09-10-2008, 12:10 AM   #3
jbiz
LQ Newbie
 
Registered: Sep 2008
Posts: 3

Rep: Reputation: 0
Solved?

Did anyone ever solve this issue? I'm still facing it. Thanks.
 
Old 09-10-2008, 01:01 AM   #4
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.5, Centos 5.10
Posts: 16,311

Rep: Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040Reputation: 2040
Try www.perlmonks.org
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bugzilla - MySQL - perl - DBD::mysql install problem Runningonair Linux - Software 8 10-12-2007 01:42 AM
bugzilla error! DBD mysql user access denial pudhiyavan Linux - Software 1 01-16-2006 05:33 PM
Error compiling perl-DBD-MySQL after upgrading to MySQL 4.1 pitaro920 Linux - Software 1 01-16-2006 05:28 PM
DBD::mysql install problem GNUsavior Fedora 0 12-11-2005 08:33 PM
perl-DBD-MySQL installation problem kartheekpn Linux - Software 3 09-23-2005 04:01 AM


All times are GMT -5. The time now is 05:21 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration