473,246 Members | 1,553 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,246 software developers and data experts.

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!!!! =)
Jul 12 '07 #1
3 8763
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
I had the same problem, and this fixed it. Thanks a lot!
Aug 7 '07 #3
numberwhun
3,509 Expert Mod 2GB
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

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

Similar topics

0
by: Randell D. | last post by:
Folks, I have installed MySQL v4 (client, server and development rpm's). I've tried and failed to use the recommended mysqladmin to set a root password after the installation (I have another post...
1
by: Kerry Shetline | last post by:
I've successfully installed MySQL and the Perl DBI module, but when I try to install DBD::mysql, it keeps failing like this: -------------------- (from the CPAN shell) --------------------- .......
0
by: Madhu Nair | last post by:
I am getting errors while compiling DBD-mysql 2.9002 on HP-UX 11.00 I have perl 5.8 downloaded from HP depot installed at /opt/perl Mysql 4.0.13 compiled myself with gcc with Mysql recommended...
0
by: Yun Guan | last post by:
Hello mysql gurus, I am trying to run perl on mysql database on Red Hat box. I want to install DBI and DBD:mysql using CPAN: perl -MCPAN -e shell cpan>install DBI The above succeeded, but...
0
by: Paul | last post by:
I'm having problems in getting the tests associated with DBD::mysql. When they are executed, I get the following error repeated many times: t/00base...........install_driver(mysql) failed: Can't...
1
by: Alex Hunsley | last post by:
I am trying to install the DBD::mysql perl module. However, it claims I need mysql.h: cpan> install DBD::mysql CPAN: Storable loaded ok Going to read /home/alex/.cpan/Metadata Database was...
0
by: pvannie | last post by:
Hello there, I've been trying to install DBD::mysql on Mac OS X Server 10.3 for 2 days, but it still raises error. So I'm going to send this message to ask for help. Any help will be much...
1
by: pvannie | last post by:
Hello there, I've been trying to install DBD::mysql on Mac OS X Server 10.3 for 2 days, but it still raises error. So I'm going to send this message to ask for help. Any help will be much...
11
by: bthalapathi | last post by:
I have written a script to connect the mysql db #!/usr/bin/perl -w use DBI; #definition of variables $db="MYTEST"; $host="localhost"; $user="root"; $password="rootpass";
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.