Help | Site Map
Connecting Tech Pros Worldwide
bytes > answers > Perl
Reply
 
LinkBack Thread Tools
  #1  
Old July 12th, 2007, 02:40 AM
Newbie
  
Join Date: Jul 2007
Posts: 1
Default 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/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!!!! =)
Reply
  #2  
Old July 23rd, 2007, 02:50 AM
Newbie
  
Join Date: Jul 2007
Posts: 1
Default
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;
Reply
  #3  
Old August 7th, 2007, 01:21 AM
Newbie
  
Join Date: Aug 2007
Location: Buenos Aires
Age: 32
Posts: 1
Default
I had the same problem, and this fixed it. Thanks a lot!
Reply
  #4  
Old August 7th, 2007, 02:16 PM
numberwhun's Avatar
Forum Leader
  
Join Date: May 2007
Location: New Hampshire
Posts: 2,156
Default
Quote:
Originally Posted by thomasde
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
Reply
Reply

Bookmarks

« Previous Thread | Next Thread »
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles
Quick Browse:
Communities / Archives
XML / CSS | HTML | Javascript | PHP | Perl | Visual Basic | Python | C++ / C | Java | .NET / C# / VB / XML / ASP.net | ASP
PostgreSQL | MS SQL | Oracle | IBM DB2 | MS Access | MySQL

About Bytes | Sitemap | Privacy Policy | Terms of Use
Copyright 1995-2008 Bytes.com. All rights Reserved