Installing DBD::mysql in Mac OSX 10.4.10

[menzies]

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:

~/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!!!! =)

[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;

[mondongo]

I had the same problem, and this fixed it. Thanks a lot!

[numberwhun]

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