Problem installing DBD::MySQL 2.9004

Discussion in 'Perl Misc' started by Hal Vaughan, Aug 29, 2004.

  1. Hal Vaughan

    Hal Vaughan Guest

    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
    Hal Vaughan, Aug 29, 2004
    #1
    1. Advertising

  2. In comp.lang.perl.misc on Sun, 29 Aug 2004 04:14:13 -0400
    Hal Vaughan <> wrote:
    > 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.


    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
    Zebee Johnstone, Aug 29, 2004
    #2
    1. Advertising

  3. Hal Vaughan

    Hal Vaughan Guest

    Zebee Johnstone wrote:

    > In comp.lang.perl.misc on Sun, 29 Aug 2004 04:14:13 -0400
    > Hal Vaughan <> wrote:
    >> 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.

    >
    > 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.


    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

    >
    >
    > Zebee
    Hal Vaughan, Aug 29, 2004
    #3
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mike Solomon

    DBD::mysqlPP v DBD::mysql

    Mike Solomon, Feb 16, 2004, in forum: Perl Misc
    Replies:
    1
    Views:
    198
    James Willmore
    Feb 16, 2004
  2. Hal Vaughan
    Replies:
    2
    Views:
    125
    Hal Vaughan
    Aug 27, 2004
  3. Jim Cochrane
    Replies:
    0
    Views:
    109
    Jim Cochrane
    Aug 25, 2007
  4. mmccaws2

    problem installing DBD/mysql.pm

    mmccaws2, Nov 7, 2007, in forum: Perl Misc
    Replies:
    2
    Views:
    333
    Ben Morrow
    Nov 7, 2007
  5. Jørn Dahl-Stamnes

    Problem installing DBD::mysql

    Jørn Dahl-Stamnes, Dec 21, 2007, in forum: Perl Misc
    Replies:
    10
    Views:
    254
Loading...

Share This Page