Trying to install DBD::MySQL on raq3 - Failed 17/18 test scripts, 5.56% okay. 727/730 subtests failed, 0.41% okay

From: Jim Byrne (jim_at_glasgowwestend.co.uk)
Date: 12/24/04

  • Next message: Jim Byrne: "Re: Trying to install DBD::MySQL on raq3: sorted" 
    Date: Fri, 24 Dec 2004 10:04:43 +0000
To: Dbi-Users <dbi-users@perl.org>

    HI,

    I'm trying to install DBD-mysql-2.9004. I run perl Makefile.PL I
    got the error that mysql_config can't be found.

    I have found mysql_config on my system (Raq3, perl v5.6.1 built for
    i586-linux) at /usr/local/mysql/bin/mysql_config - but I don't know how to
    feed this to the Makefile script - or put it in a place where it will find
    it?

    I figured out I could feed in the following configurations on the command
    line:

    perl Makefile.PL --cflags=-I/usr/local/mysql/include/mysql
    --libs=-L/usr/local/mysql/lib/mysql

    It ran and I got the following output:

    "Can't exec "mysql_config": No such file or directory at Makefile.PL line
    174.
    readline() on closed filehandle PIPE at Makefile.PL line 176.
    Can't exec "mysql_config": No such file or directory at Makefile.PL line
    174.
    readline() on closed filehandle PIPE at Makefile.PL line 176.
    Can't exec "mysql_config": No such file or directory at Makefile.PL line
    174.
    readline() on closed filehandle PIPE at Makefile.PL line 176.
    Can't exec "mysql_config": No such file or directory at Makefile.PL line
    174.
    readline() on closed filehandle PIPE at Makefile.PL line 176.
    Can't exec "mysql_config": No such file or directory at Makefile.PL line
    174.
    readline() on closed filehandle PIPE at Makefile.PL line 176.
    Can't exec "mysql_config": No such file or directory at Makefile.PL line
    174.
    readline() on closed filehandle PIPE at Makefile.PL line 176.
    Can't exec "mysql_config": No such file or directory at Makefile.PL line
    174.
    readline() on closed filehandle PIPE at Makefile.PL line 176.
    I will use the following settings for compiling and testing:

      cflags (Users choice) = -I/usr/local/mysql/include/mysql
      libs (Users choice) = -L/usr/local/mysql/lib/mysql
      nocatchstderr (default ) = 0
      nofoundrows (default ) = 0
      ssl (guessed ) = 0
      testdb (default ) = test
      testhost (default ) =
      testpassword (default ) =
      testuser (default ) =

    To change these settings, see 'perl Makefile.PL --help' and
    'perldoc INSTALL'.

    Using DBI 1.46 (for perl 5.006001 on i586-linux) installed in
    /usr/local/lib/perl5/site_perl/5.6.1/i586-linux/auto/DBI/
    Writing Makefile for DBD::mysql"

    I then ran make and got the following output:

    "cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i586-linux/auto/DBI/
    -I/usr/local/mysql/include/mysql -fno-strict-aliasing -D_LARGEFILE_SOURCE
    -D_FILE_OFFSET_B ITS=64 -O2 -DVERSION=\"2.9004\"
    -DXS_VERSION=\"2.9004\" -fpic -I/usr/local/lib/perl5/5.6.1/i586-linux/CORE
    dbdimp.c
    cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i586-linux/auto/DBI/
    -I/usr/local/mysql/include/mysql -fno-strict-aliasing -D_LARGEFILE_SOURCE
    -D_FILE_OFFSET_B ITS=64 -O2 -DVERSION=\"2.9004\"
    -DXS_VERSION=\"2.9004\" -fpic -I/usr/local/lib/perl5/5.6.1/i586-linux/CORE
    mysql.c
    Running Mkbootstrap for DBD::mysql ()
    chmod 644 mysql.bs
    rm -f blib/arch/auto/DBD/mysql/mysql.so
    LD_RUN_PATH="" /usr/bin/perl myld cc -shared -L/usr/local/lib dbdimp.o
    mysql.o -o blib/arch/auto/DBD/mysql/mysql.so
    chmod 755 blib/arch/auto/DBD/mysql/mysql.so
    cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
    chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
    Manifying blib/man3/DBD::mysql::INSTALL.3
    Manifying blib/man3/DBD::mysql.3
    Manifying blib/man3/Bundle::DBD::mysql.3
    Manifying blib/man3/Mysql.3"

    I then ran make test - but got loads of errors:

    "make test
    PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
    -I/usr/local/lib/perl5/5.6.1/i586-linux -I/usr/local/lib/perl5/5.6.1 -e 'use
    Test::Harness qw(&runtes ts $verbose); $verbose=0; runtests @ARGV;'
    t/*.t
    t/00base...........install_driver(mysql) failed: Can't load
    'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    blib/arch/auto/DBD/mysql/mysql.so: un defined symbol:
    net_buffer_length at /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm
    line 206.
     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
    'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    blib/arch/auto/DBD/mysql/mysql.so: un defined symbol:
    net_buffer_length at /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm
    line 206.
     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
    'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    blib/arch/auto/DBD/mysql/mysql.so: un defined symbol:
    net_buffer_length at /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm
    line 206.
     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
    'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    blib/arch/auto/DBD/mysql/mysql.so: un defined symbol:
    net_buffer_length at /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm
    line 206.
     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/40bindparam......install_driver(mysql) failed: Can't load
    'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    blib/arch/auto/DBD/mysql/mysql.so: un defined symbol:
    net_buffer_length at /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm
    line 206.
     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-28
            Failed 28/28 tests, 0.00% okay
    t/40blobs..........install_driver(mysql) failed: Can't load
    'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    blib/arch/auto/DBD/mysql/mysql.so: un defined symbol:
    net_buffer_length at /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm
    line 206.
     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
    'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    blib/arch/auto/DBD/mysql/mysql.so: un defined symbol:
    net_buffer_length at /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm
    line 206.
     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
    'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    blib/arch/auto/DBD/mysql/mysql.so: un defined symbol:
    net_buffer_length at /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm
    line 206.
     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
    'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    blib/arch/auto/DBD/mysql/mysql.so: un defined symbol:
    net_buffer_length at /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm
    line 206.
     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/50chopblanks.....install_driver(mysql) failed: Can't load
    'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    blib/arch/auto/DBD/mysql/mysql.so: un defined symbol:
    net_buffer_length at /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm
    line 206.
     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
    'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    blib/arch/auto/DBD/mysql/mysql.so: un defined symbol:
    net_buffer_length at /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm
    line 206.
     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
    'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    blib/arch/auto/DBD/mysql/mysql.so: un defined symbol:
    net_buffer_length at /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm
    line 206.
     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/local/lib/perl5/site_perl/5.6.1/i586-linux/DBI.pm line 1161.
    Use of uninitialized value in subroutine entry at
    /usr/local/lib/perl5/site_perl/5.6.1/i586-linux/DBI.pm line 1161.
    Can't locate object method "connect" via package "Mysql" (perhaps you forgot
    to load "Mysql"?) at 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
    'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    blib/arch/auto/DBD/mysql/mysql.so: un defined symbol:
    net_buffer_length at /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm
    line 206.
     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
    'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
    blib/arch/auto/DBD/mysql/mysql.so: un defined symbol:
    net_buffer_length at /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm
    line 206.
     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 'blib/arch/auto/DBD/mysql/mysql.so' for module
    DBD::mysql: blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
    net_buffer_len gth at
    /usr/local/lib/perl5/5.6.1/i586-linux/DynaLoader.pm line 206.
     at blib/lib/Mysql.pm line 13
    Compilation failed in require at 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/local/lib/perl5/site_perl/5.6.1/i586-linux/DBI.pm line 1161.
    Use of uninitialized value in subroutine entry at
    /usr/local/lib/perl5/site_perl/5.6.1/i586-linux/DBI.pm line 1161.
    Can't locate object method "connect" via package "Mysql" (perhaps you forgot
    to load "Mysql"?) at 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    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.
Failed 17/18 test scripts, 5.56% okay. 727/730 subtests failed, 0.41% okay.
make: *** [test_dynamic] Error 2
"
I would appreciate any help with this as I've been working on it for days
without success.
Thanks,
Jim
  • Next message: Jim Byrne: "Re: Trying to install DBD::MySQL on raq3: sorted"

    Relevant Pages

    • Attempting to install DBD
      ... I am attempting to install DBD-mysql-2.9003 on a Solaris 2.8 machine. ... ql/mysql.so' for modul. ... Perhaps a required shared library or dll isn't installed where expected ... FAILED tests 4-5 ...
      (perl.dbi.users)
    • problem with instalaion of DBD::mysql
      ... i installed mysql database via Mysql-serever-5.1.10-0.i386.rpm also via ... But i could not install DBD::mysql thru cpan. ... Perhaps a required shared library or dll isn't installed where expected ... FAILED tests 4-5 ...
      (perl.beginners)
    • Problem installing DBD::MySQL 2.9004
      ... I tried installing MySQL and ... all the packages, then install DBD::mysql separately, still no luck). ... Perhaps a required shared library or dll isn't installed where expected ... FAILED tests 4-5 ...
      (comp.lang.perl.misc)
    • RE: KB suggestion - install script
      ... > based on the registry. ... > located the dll, he needs to load the com dll file, we can troubleshooting ... >>install select install for all vs just me. ...
      (microsoft.public.office.developer.com.add_ins)
    • RE: Newbie problem connecting to MS SQL Server
      ... From: Mark Vaughan ... Here is the output from CPAN's 'install DBD::ODBC' command: ... CPAN: Storable loaded ok ... FAILED tests 3-36 ...
      (perl.dbi.users)