Problem installing DBD::MySQL 2.9004

H

Hal Vaughan

I have a Libranet (Debian based) Linux system. I tried installing MySQL and
DBD::mysql through apt-get, but it didn't work (I also used apt-get to get
all the packages, then install DBD::mysql separately, still no luck). I
finally decided to download the latest version of MySQL from mysql.com and
install it. I had to create the directory /usr/include/mysql and copy all
the header files to it.

I've been trying to install DBD::mysql for several hours. I have been
reading the directions, but I still can't find (including through Google --
but I tend to always search on the wrong terms, so Google search links are
helpful -- especially if you can let me know the terms that brought up the
right answer) anything that helps me get this module installed.

I do "perl Makefile.PL" and "make" and everything is fine. I've posted the
output from "make test" at the end of the post, due to it's length. I read
in the instructions that this might be a problem with the linker and added
the line:

-L/usr/lib/gcc-lib/i386-linux/3.2.3/libgcc.a -lgcc

at the end of the line in Makefile that starts with "CFLAGS = ", but it made
absolutely no difference.

So what can I do to install this? I'd prefer to get it working with the
later version of MySQL, but if I have to wipe that and go with apt-get
packages, I can do that. At this point, I ma very frustrated because it's
not working with the "official" package and it doesn't work with the
Debian .deb files (they don't include mysql_config, and it always complains
about not finding that).

Any help is appreciated.

Hal
---------------------------------
Output from "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/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
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
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/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
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
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/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
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
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/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
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
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40bindparam......install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
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
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-28
Failed 28/28 tests, 0.00% okay
t/40blobs..........install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
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
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/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
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
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/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
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
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/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
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
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-25
Failed 25/25 tests, 0.00% okay
t/50chopblanks.....install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
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
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/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
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
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/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
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
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/local/lib/perl/5.8.2/DBI.pm line 1011.
Use of uninitialized value in subroutine entry
at /usr/local/lib/perl/5.8.2/DBI.pm line 1011.
Can't locate object method "connect" via package "Mysql"
at /root/DBD-mysql-2.9004/blib/lib/Mysql.pm line 71.
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/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
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
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/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
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
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/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
at /root/DBD-mysql-2.9004/blib/lib/Mysql.pm line 13
Compilation failed in require at /root/DBD-mysql-2.9004/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.
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/local/lib/perl/5.8.2/DBI.pm line 1011.
Use of uninitialized value in subroutine entry
at /usr/local/lib/perl/5.8.2/DBI.pm line 1011.
Can't locate object method "connect" via package "Mysql"
at /root/DBD-mysql-2.9004/blib/lib/Mysql.pm line 71.
dubious
Test returned status 255 (wstat 65280, 0xff00)
Failed 17/18 test scripts, 5.56% okay. 727/730 subtests failed, 0.41% okay.
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/00base.t 255 65280 5 4 80.00% 4-5
t/10dsnlist.t 255 65280 9 18 200.00% 1-9
t/20createdrop.t 255 65280 5 10 200.00% 1-5
t/30insertfetch.t 255 65280 11 22 200.00% 1-11
t/40bindparam.t 255 65280 28 56 200.00% 1-28
t/40blobs.t 255 65280 11 22 200.00% 1-11
t/40listfields.t 255 65280 18 36 200.00% 1-18
t/40nulls.t 255 65280 11 22 200.00% 1-11
t/40numrows.t 255 65280 25 50 200.00% 1-25
t/50chopblanks.t 255 65280 35 70 200.00% 1-35
t/50commit.t 255 65280 30 60 200.00% 1-30
t/ak-dbd.t 255 65280 90 180 200.00% 1-90
t/akmisc.t 255 65280 351 702 200.00% 1-351
t/dbdadmin.t 255 65280 21 42 200.00% 1-21
t/insertid.t 255 65280 12 24 200.00% 1-12
t/mysql.t 255 65280 68 136 200.00% 1-68
t/mysql2.t 255 65280 ?? ?? % ??
1 test skipped.
make: *** [test_dynamic] Error 255
 
Z

Zebee Johnstone

In comp.lang.perl.misc on Sun, 29 Aug 2004 04:14:13 -0400
Hal Vaughan said:
I have a Libranet (Debian based) Linux system. I tried installing MySQL and
DBD::mysql through apt-get, but it didn't work (I also used apt-get to get
all the packages, then install DBD::mysql separately, still no luck). I
finally decided to download the latest version of MySQL from mysql.com and
install it. I had to create the directory /usr/include/mysql and copy all
the header files to it.
Click to expand...

From memory, you will also need stuff in lib

I have used /usr/local/include/mysql and /usr/local/lib/mysql, as well
as /usr/local/mysql/lib and /usr/local/mysql/include.

my lib dir has :
libdbug.a libmyisammrg.a libmysqlclient.so.12 libnisam.a
libheap.a libmysqlclient.a libmysqlclient.so.12.0.0 libvio.a
libmerge.a libmysqlclient.la libmystrings.a
libmyisam.a libmysqlclient.so libmysys.a

your errors do look a bit like the DBD module cant find libraries.



Zebee
 
H

Hal Vaughan

Zebee said:
In comp.lang.perl.misc on Sun, 29 Aug 2004 04:14:13 -0400


From memory, you will also need stuff in lib

I have used /usr/local/include/mysql and /usr/local/lib/mysql, as well
as /usr/local/mysql/lib and /usr/local/mysql/include.

my lib dir has :
libdbug.a libmyisammrg.a libmysqlclient.so.12 libnisam.a
libheap.a libmysqlclient.a libmysqlclient.so.12.0.0 libvio.a
libmerge.a libmysqlclient.la libmystrings.a
libmyisam.a libmysqlclient.so libmysys.a

your errors do look a bit like the DBD module cant find libraries.
Click to expand...

That did it. Just did "cp /usr/local/mysql/lib/* /usr/lib/" and it worked
fine after that.

Wonder why they don't suggest that in the install docs, instead of
suggesting all the compiler links? I might suggest it to the maintainer.

Thanks!

Hal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble installing DBD-Oracle-1.23 on Cygwin 2
Not able to install 'Msql-Mysql-modules' 0
Proper Technique for DBD::mysql install 0
problem installing DBD/mysql.pm 2
question on "make test" 5
Problem installing DBD::mysql 10
Module install problem DBD::Unify 4
DB Module installation issue in Perl 0

Members online

Total: 27 (members: 2, guests: 25)
Robots: 443

Forum statistics

Threads
473,767
Messages
2,569,572
Members
45,046
Latest member
Gavizuho

Latest Threads

Top