problem with instalaion of DBD::mysql

From: Gowthaman Ramasamy (gowtham_at_icgeb.res.in)
Date: 02/27/05

  • Next message: Randal L. Schwartz: "Re: "COPY FROM" Postgresql" 
    To: Perl Beginners <beginners@perl.org>
Date: 27 Feb 2005 17:26:54 +0530

    Dear list,
    i have a problem installing DBD::mysql module.
    My built is FC3 on a P4 machine.
    i installed mysql database via Mysql-serever-5.1.10-0.i386.rpm also via
    a binary version of mysql-standard-4.1.10-pc-linux-gnu-i686.
    both the mysql servers are fine. And i could install DBI modules thru
    CPAN. But i could not install DBD::mysql thru cpan. I tried manually
    too. i have attached the output produced by make and make test. Can some
    one help me out.
    I guess there si some problem with cflags and lib ... But i could not
    sort it out ....
    Many thanks in advance ...
    Sincerely,
    gowtham

    gcc -c -I/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/ -I/usr/local/include/mysql -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m32 -march=i386 -mtune=pentium4 -DVERSION=\"2.9004\" -DXS_VERSION=\"2.9004\" -fPIC "-I/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE" dbdimp.c
    gcc -c -I/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBI/ -I/usr/local/include/mysql -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m32 -march=i386 -mtune=pentium4 -DVERSION=\"2.9004\" -DXS_VERSION=\"2.9004\" -fPIC "-I/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE" mysql.c
    Running Mkbootstrap for DBD::mysql ()
    chmod 644 mysql.bs
    rm -f blib/arch/auto/DBD/mysql/mysql.so
    /usr/bin/perl myld gcc -shared -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/local/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
    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.3pm
    Manifying blib/man3/DBD::mysql::INSTALL.3pm
    Manifying blib/man3/Mysql.3pm
    Manifying blib/man3/Bundle::DBD::mysql.3pm

    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/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
     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 '/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
     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 '/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
     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 '/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
     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 '/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/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/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 '/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
     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 '/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
     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 '/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
     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 '/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
     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 '/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
     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 '/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
     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 '/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
     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/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/DBI.pm line 1165.
    Use of uninitialized value in subroutine entry at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/DBI.pm line 1165.
    Can't locate object method "connect" via package "Mysql" at /usr/local/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 '/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
     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 '/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
     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 '/usr/local/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
     at /usr/local/DBD-mysql-2.9004/blib/lib/Mysql.pm line 13
    Compilation failed in require at /usr/local/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/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/DBI.pm line 1165.
    Use of uninitialized value in subroutine entry at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/DBI.pm line 1165.
    Can't locate object method "connect" via package "Mysql" at /usr/local/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

  • Next message: Randal L. Schwartz: "Re: "COPY FROM" Postgresql"

    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)
    • Trying to install DBD::MySQL on raq3 - Failed 17/18 test scripts, 5.56% okay. 727/730 subtests faile
      ... I'm trying to install DBD-mysql-2.9004. ... Perhaps a required shared library or dll isn't installed where expected ... FAILED tests 4-5 ... t/20createdrop.....install_driverfailed: Can't load ...
      (perl.dbi.users)
    • 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: 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)
    • Re: When were scanf_s functions introduced?
      ... My knowledge of doing complicated MSI setup apps is fairly limited, ... installers, one that is a "full install" (includes everything and will be ... then the amount of space for the CRT ... the CRT dll MSVCR80.dll? ...
      (microsoft.public.platformsdk.security)