By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,091 Members | 1,555 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,091 IT Pros & Developers. It's quick & easy.

Installing DBD::mysql in Mac OSX 10.4.10

P: 1
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/o...dbd_mysql.html
http://jayallen.org/journey/2006/04/...n-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:

Expand|Select|Wrap|Line Numbers
  1. ~/Perl/src/DBD-mysql-4.005 menzies$ make test
  2. PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
  3. 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
  4.   Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  5.   Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLoader.pm line 230.
  6.  at (eval 3) line 3
  7. Compilation failed in require at (eval 3) line 3.
  8. Perhaps a required shared library or dll isn't installed where expected
  9.  at t/00base.t line 38
  10. t/00base.............dubious                                                 
  11.         Test returned status 255 (wstat 65280, 0xff00)
  12. DIED. FAILED tests 4-5
  13.         Failed 2/5 tests, 60.00% okay
  14. 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
  15.   Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  16.   Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLoader.pm line 230.
  17.  at (eval 3) line 3
  18. Compilation failed in require at (eval 3) line 3.
  19. Perhaps a required shared library or dll isn't installed where expected
  20.  at t/10connect.t line 25
  21. # Looks like your test died before it could output anything.
  22. t/10connect..........dubious                                                 
  23.         Test returned status 255 (wstat 65280, 0xff00)
  24. DIED. FAILED tests 1-2
  25.         Failed 2/2 tests, 0.00% okay
  26. 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
  27.   Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  28.   Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLoader.pm line 230.
  29.  at (eval 3) line 3
  30. Compilation failed in require at (eval 3) line 3.
  31. Perhaps a required shared library or dll isn't installed where expected
  32.  at t/20createdrop.t line 21
  33. # Looks like your test died before it could output anything.
  34. t/20createdrop.......dubious                                                 
  35.         Test returned status 255 (wstat 65280, 0xff00)
  36. DIED. FAILED tests 1-4
  37.         Failed 4/4 tests, 0.00% okay
  38. 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
  39.   Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  40.   Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLoader.pm line 230.
  41.  at (eval 3) line 3
  42. Compilation failed in require at (eval 3) line 3.
  43. Perhaps a required shared library or dll isn't installed where expected
  44.  at t/30insertfetch.t line 21
  45. # Looks like your test died before it could output anything.
  46. t/30insertfetch......dubious                                                 
  47.         Test returned status 255 (wstat 65280, 0xff00)
  48. DIED. FAILED tests 1-9
  49.         Failed 9/9 tests, 0.00% okay
  50. 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
  51.   Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  52.   Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLoader.pm line 230.
  53.  at (eval 3) line 3
  54. Compilation failed in require at (eval 3) line 3.
  55. Perhaps a required shared library or dll isn't installed where expected
  56.  at t/35limit.t line 24
  57. # Looks like your test died before it could output anything.
  58. t/35limit............dubious                                                 
  59.         Test returned status 255 (wstat 65280, 0xff00)
  60. DIED. FAILED tests 1-111
  61.         Failed 111/111 tests, 0.00% okay
  62. 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
  63.   Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  64.   Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLoader.pm line 230.
  65.  at (eval 3) line 3
  66. Compilation failed in require at (eval 3) line 3.
  67. Perhaps a required shared library or dll isn't installed where expected
  68.  at t/35prepare.t line 25
  69. # Looks like your test died before it could output anything.
  70. t/35prepare..........dubious                                                 
  71.         Test returned status 255 (wstat 65280, 0xff00)
  72. DIED. FAILED tests 1-49
  73.         Failed 49/49 tests, 0.00% okay
  74. 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
  75.   Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  76.   Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLoader.pm line 230.
  77.  at (eval 5) line 3
  78. Compilation failed in require at (eval 5) line 3.
  79. Perhaps a required shared library or dll isn't installed where expected
  80.  at t/40bindparam.t line 57
  81. t/40bindparam........dubious                                                 
  82.         Test returned status 255 (wstat 65280, 0xff00)
  83. 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
  84.   Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  85.   Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLoader.pm line 230.
  86.  at (eval 5) line 3
  87. Compilation failed in require at (eval 5) line 3.
  88. Perhaps a required shared library or dll isn't installed where expected
  89.  at t/40bindparam2.t line 64
  90. t/40bindparam2.......dubious                                                 
  91.         Test returned status 255 (wstat 65280, 0xff00)
  92. DIED. FAILED tests 1-13
  93.  
  94.  <snip>
  95.  
  96.         Failed 9/9 tests, 0.00% okay
  97. 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
  98.   Referenced from: /Users/menzies/Perl/src/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle
  99.   Reason: image not found at /System/Library/Perl/5.8.6/darwin-thread-multi-2level/DynaLoader.pm line 230.
  100.  at (eval 3) line 3
  101. Compilation failed in require at (eval 3) line 3.
  102. Perhaps a required shared library or dll isn't installed where expected
  103.  at t/utf8.t line 49
  104. t/utf8...............dubious                                                 
  105.         Test returned status 255 (wstat 65280, 0xff00)
  106. Failed Test         Stat Wstat Total Fail  Failed  List of Failed
  107. -------------------------------------------------------------------------------
  108. t/00base.t           255 65280     5    4  80.00%  4-5
  109. t/10connect.t        255 65280     2    4 200.00%  1-2
  110. t/20createdrop.t     255 65280     4    8 200.00%  1-4
  111. t/30insertfetch.t    255 65280     9   18 200.00%  1-9
  112. t/35limit.t          255 65280   111  222 200.00%  1-111
  113. t/35prepare.t        255 65280    49   98 200.00%  1-49
  114. t/40bindparam.t      255 65280    ??   ??       %  ??
  115. t/40bindparam2.t     255 65280    13   26 200.00%  1-13
  116. t/40blobs.t          255 65280    11   22 200.00%  1-11
  117. t/40catalog.t        255 65280    ??   ??       %  ??
  118. t/40listfields.t     255 65280    19   38 200.00%  1-19
  119. t/40nulls.t          255 65280    11   22 200.00%  1-11
  120. t/40numrows.t        255 65280    25   50 200.00%  1-25
  121. t/41bindparam.t      255 65280    11   22 200.00%  1-11
  122. t/41blobs_prepare.t  255 65280    24   48 200.00%  1-24
  123. t/42bindparam.t      255 65280    11   22 200.00%  1-11
  124. t/50chopblanks.t     255 65280    35   70 200.00%  1-35
  125. t/50commit.t         255 65280    30   60 200.00%  1-30
  126. t/75supported_sql.t  255 65280    16   32 200.00%  1-16
  127. t/80procs.t          255 65280    ??   ??       %  ??
  128. t/insertid.t         255 65280    16   32 200.00%  1-16
  129. t/multi_statement.t  255 65280     7   14 200.00%  1-7
  130. t/param_values.t     255 65280     8   16 200.00%  1-8
  131. t/prepare_noerror.t  255 65280    ??   ??       %  ??
  132. t/texecute.t         255 65280     9   18 200.00%  1-9
  133. t/utf8.t             255 65280    ??   ??       %  ??
  134. 2 tests skipped.
  135. Failed 26/28 test scripts, 7.14% okay. 423/426 subtests failed, 0.70% okay.
  136. make: *** [test_dynamic] Error 2
  137.  

HELP MEEEEEE!!!! =)
Jul 12 '07 #1
Share this Question
Share on Google+
3 Replies


P: 1
I had that same problem - the key is here:

t/80procs............install_driver(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;
Jul 23 '07 #2

P: 1
I had the same problem, and this fixed it. Thanks a lot!
Aug 7 '07 #3

numberwhun
Expert Mod 2.5K+
P: 3,503
I had that same problem - the key is here:

t/80procs............install_driver(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
Aug 7 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.