MySql DBI drivers for OSX

[Robert Kulseth]

perl version v5.8.9 built for darwin-2level
mysql Ver 14.14 Distrib 5.5.8, for osx10.6 (i386) using readline 5.1
DBD-mysql-4.018
DBI version 1.615
Mac OS X version 10.6.5

I have been wrestling with installing the DBI Driver for Mac OS X for a few days now. I have never installed it anywhere else. I blindly installed from MacPorts and that failed. I then tried installing from CPAN (perl -MCPAN ...), and then went to compiling it myself. I have read many posts and have tried many fixes. I am currently getting the following error when doing "make test". I checked that the file "libmysqlclient .16.dylib" does in fact exist and that it is is at the following two locations...

/usr/local/mysql/lib/
/usr/local/mysql/lib/mysql/

It looks like it just cant find the library, but I cant figure out where it's trying to find it.
here is the output from "make test"

PERL_DL_NONLAZY=1 /opt/local/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base....................ok 1/6                                           
#   Failed test 'use DBD::mysql;'
#   at t/00base.t line 21.
#     Tried to use 'DBD::mysql'.
#     Error:  Can't load '/Users/peter/DBD/DBD-mysql-4.018/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/peter/DBD/DBD-mysql-4.018/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: libmysqlclient.16.dylib
#   Referenced from: /Users/peter/DBD/DBD-mysql-4.018/blib/arch/auto/DBD/mysql/mysql.bundle
#   Reason: image not found at /opt/local/lib/perl5/5.8.9/darwin-2level/DynaLoader.pm line 230.
#  at (eval 7) line 2
# Compilation failed in require at (eval 7) line 2.
# BEGIN failed--compilation aborted at (eval 7) line 2.
t/00base....................NOK 2/6FAILED--Further testing stopped: Unable to load DBD::mysql
make: *** [test_dynamic] Error 255

[chorny]

First you should report this error to port maintainer, he/she would know more about Mac problems.

By looking at cpantesters reports, I see that there are no similar failures.