Installing DBD::mysql in Mac OSX 10.4.10

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • menzies
    New Member
    • Jul 2007
    • 1
    #1

    Installing DBD::mysql in Mac OSX 10.4.10

    Hi, I"m new to this forum, but I have been trying all day to install DBD::mysql onto my Intel MacBook. I've read lots of forums pages and none have gotten me to a successful 'make test' or a successful 'sudo make install.' Before every attempt I even do a sudo make distclean to make sure I haven't gotten things mucked up from a prior attempt.

    OS: Mac OS X 10.4.10
    MySQL: v5.0.41 for Mac OSX-i686
    DBI: v1.58 (installed fine using CPAN)
    Perl: v5.8.6

    I started by trying to use CPAN, but got plenty of errors, so I downloaded the source and got errors with make performing a regular install. I read these websites:

    http://www.truerwords.net/articles/osx/install_dbd_mysql.html

    http://jayallen.org/journey/2006/04/dbd-mysql-build-problems-on-mac-book-pro


    ...and adjusted my 'sudo Makefile.PL' step ---> 'sudo perl Makefile.PL --cflags="-I/usr/local/mysql/include -Os -arch i386 -fno-common" --libs="-L/usr/local/mysql/lib -lmysqlclient -lz -lm"

    Using this, running 'Makefile.PL' and 'make' work fine, but then I get really ugly output when I run 'make test'. Here is my ugly output:

    Code:
    ~/Perl/src/DBD-mysql-4.005 menzies$ make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.............ok 3/5install_driver(mysql) failed: Can't load '/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: /usr/local/mysql/lib/mysql/libmysqlclient.15.dylib
  Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/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
t/00base.............dubious                                                 
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
        Failed 2/5 tests, 60.00% okay
t/10connect..........install_driver(mysql) failed: Can't load '/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: /usr/local/mysql/lib/mysql/libmysqlclient.15.dylib
  Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/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/10connect.t line 25
# Looks like your test died before it could output anything.
t/10connect..........dubious                                                 
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-2
        Failed 2/2 tests, 0.00% okay
t/20createdrop.......install_driver(mysql) failed: Can't load '/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: /usr/local/mysql/lib/mysql/libmysqlclient.15.dylib
  Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/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 21
# Looks like your test died before it could output anything.
t/20createdrop.......dubious                                                 
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-4
        Failed 4/4 tests, 0.00% okay
t/30insertfetch......install_driver(mysql) failed: Can't load '/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: /usr/local/mysql/lib/mysql/libmysqlclient.15.dylib
  Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/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 21
# Looks like your test died before it could output anything.
t/30insertfetch......dubious                                                 
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-9
        Failed 9/9 tests, 0.00% okay
t/35limit............install_driver(mysql) failed: Can't load '/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: /usr/local/mysql/lib/mysql/libmysqlclient.15.dylib
  Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/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 24
# Looks like your test died before it could output anything.
t/35limit............dubious                                                 
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-111
        Failed 111/111 tests, 0.00% okay
t/35prepare..........install_driver(mysql) failed: Can't load '/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: /usr/local/mysql/lib/mysql/libmysqlclient.15.dylib
  Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/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 25
# Looks like your test died before it could output anything.
t/35prepare..........dubious                                                 
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-49
        Failed 49/49 tests, 0.00% okay
t/40bindparam........install_driver(mysql) failed: Can't load '/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: /usr/local/mysql/lib/mysql/libmysqlclient.15.dylib
  Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/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 57
t/40bindparam........dubious                                                 
        Test returned status 255 (wstat 65280, 0xff00)
t/40bindparam2.......install_driver(mysql) failed: Can't load '/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: /usr/local/mysql/lib/mysql/libmysqlclient.15.dylib
  Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/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
t/40bindparam2.......dubious                                                 
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-13

 <snip>

        Failed 9/9 tests, 0.00% okay
t/utf8...............install_driver(mysql) failed: Can't load '/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: /usr/local/mysql/lib/mysql/libmysqlclient.15.dylib
  Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/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/utf8.t line 49
t/utf8...............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/10connect.t        255 65280     2    4 200.00%  1-2
t/20createdrop.t     255 65280     4    8 200.00%  1-4
t/30insertfetch.t    255 65280     9   18 200.00%  1-9
t/35limit.t          255 65280   111  222 200.00%  1-111
t/35prepare.t        255 65280    49   98 200.00%  1-49
t/40bindparam.t      255 65280    ??   ??       %  ??
t/40bindparam2.t     255 65280    13   26 200.00%  1-13
t/40blobs.t          255 65280    11   22 200.00%  1-11
t/40catalog.t        255 65280    ??   ??       %  ??
t/40listfields.t     255 65280    19   38 200.00%  1-19
t/40nulls.t          255 65280    11   22 200.00%  1-11
t/40numrows.t        255 65280    25   50 200.00%  1-25
t/41bindparam.t      255 65280    11   22 200.00%  1-11
t/41blobs_prepare.t  255 65280    24   48 200.00%  1-24
t/42bindparam.t      255 65280    11   22 200.00%  1-11
t/50chopblanks.t     255 65280    35   70 200.00%  1-35
t/50commit.t         255 65280    30   60 200.00%  1-30
t/75supported_sql.t  255 65280    16   32 200.00%  1-16
t/80procs.t          255 65280    ??   ??       %  ??
t/insertid.t         255 65280    16   32 200.00%  1-16
t/multi_statement.t  255 65280     7   14 200.00%  1-7
t/param_values.t     255 65280     8   16 200.00%  1-8
t/prepare_noerror.t  255 65280    ??   ??       %  ??
t/texecute.t         255 65280     9   18 200.00%  1-9
t/utf8.t             255 65280    ??   ??       %  ??
2 tests skipped.
Failed 26/28 test scripts, 7.14% okay. 423/426 subtests failed, 0.70% okay.
make: *** [test_dynamic] Error 2

    HELP MEEEEEE!!!! =)
    Tags: None
    • thomasde
      New Member
      • Jul 2007
      • 1
      #2
      I had that same problem - the key is here:

      t/80procs........ ....install_dri ver(mysql) failed: Can't load '/Users/thomas/Downloads/fresh/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/thomas/Downloads/fresh/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: /usr/local/mysql/lib/mysql/libmysqlclient. 15.dylib
      Referenced from: /Users/thomas/Downloads/fresh/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
      Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLoader.pm line 230.

      the mysql.bundle references /usr/local/mysql/lib/mysql/libmysqlclient. 15.dylib which is wrong. I solved it my creating a symlink:

      ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql

      - Thomas;

        Comment

        • mondongo
          New Member
          • Aug 2007
          • 1
          #3
          I had the same problem, and this fixed it. Thanks a lot!

            Comment

            • numberwhun
              Recognized Expert Moderator Specialist
              • May 2007
              • 3467
              #4
              Originally posted by thomasde
              I had that same problem - the key is here:

              t/80procs........ ....install_dri ver(mysql) failed: Can't load '/Users/thomas/Downloads/fresh/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/thomas/Downloads/fresh/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: /usr/local/mysql/lib/mysql/libmysqlclient. 15.dylib
              Referenced from: /Users/thomas/Downloads/fresh/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
              Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLoader.pm line 230.

              the mysql.bundle references /usr/local/mysql/lib/mysql/libmysqlclient. 15.dylib which is wrong. I solved it my creating a symlink:

              ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql

              - Thomas;
              Sorry, not to be nit-picky, but please don't top post. Otherwise:

              ?
              about
              talking
              are
              you
              what
              know
              we
              will
              how

              Also, its ok to eliminate the text of the quote that isn't needed to cut down the size of the post, especially when there is that much text.


              Other than than, good solution!

              Regards,

              Jeff

                Comment

                Previous template Next
                Working...