Can't Install DBD::mysql

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lola J. Lee Beno - 14 Jun 2007 00:33 GMT

Trying to install this module but it fails with the following fail
message at the end:

Failed 26/28 test scripts. 423/426 subtests failed.
Files=28, Tests=426, 10 wallclock secs ( 6.13 cusr + 1.20 csys = 7.33 CPU)
Failed 26/28 test programs. 423/426 subtests failed.
make: *** [test_dynamic] Error 255
CAPTTOFU/DBD-mysql-4.005.tar.gz
/usr/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force
Failed during this command:
CAPTTOFU/DBD-mysql-4.005.tar.gz : make_test NO

The first failed test error message is:

PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.............ok 1/5install_driver(mysql) failed: Can't load
'/Users/lolajl/.cpan/build/DBD-mysql-4.005-cC14so/blib/arch/auto/DBD/mysql/mysql.bundle'
for module DBD::mysql:
dlopen(/Users/lolajl/.cpan/build/DBD-mysql-4.005-cC14so/blib/arch/auto/DBD/mysql/mysql.bundle,
2): Library not loaded: /usr/local/mysql/lib/mysql/libmysqlclient.15.dylib
Referenced from:
/Users/lolajl/.cpan/build/DBD-mysql-4.005-cC14so/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

What should i do next?

Signature

Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire
http://www.lolajl.net/resume | Blog at http://www.lolajl.net/blog/
"In rivers, the water that you touch is the last of what has passed
and the first of that which comes; so with present time."
- Leonardo da Vinci (1452-1519)

Reply to this Message

Steve Axthelm - 14 Jun 2007 00:50 GMT

>Trying to install this module but it fails with the following
>fail message at the end:

[snip]

Heh, I just struggled through a DBD::mysql install today ( mine
was a different error and ended up being a bug in MySQL), but I
suspect like me you'll find Sherm's excellent instructions from
a while back helpful:

<http://www.nntp.perl.org/group/perl.macosx/2006/08/msg9977.html>

Specifically, using look to open a sub shell:

look DBD::mysql

so you can run the commands manually.

HTH,

-Steve

Signature

Steve Axthelm
steveax@pobox.com

Reply to this Message

Sherm Pendley - 14 Jun 2007 00:58 GMT

> Library not loaded: /usr/local/mysql/lib/mysql/libmysqlclient.15.dylib
> Referenced from: /Users/lolajl/.cpan/build/DBD-mysql-4.005-cC14so/
> 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

> What should i do next?

The error message is telling you what file is missing - it's the C
client library that should have been installed with MySQL itself.

So, what went awry during the MySQL installation to cause that file
to be missing?

sherm--

Web Hosting by West Virginians, for West Virginians: http://wv-www.net
Cocoa programming in Perl: http://camelbones.sourceforge.net

Reply to this Message

Lola J. Lee Beno - 14 Jun 2007 01:03 GMT

> The error message is telling you what file is missing - it's the C
> client library that should have been installed with MySQL itself.
>
> So, what went awry during the MySQL installation to cause that file to
> be missing?

I installed the 5.0.41 MySQL Community Server (GPL) from mysql.com - the
package version. Install seemed to be going normally.

Signature

Reply to this Message

Chas Owens - 14 Jun 2007 01:09 GMT

> > The error message is telling you what file is missing - it's the C
> > client library that should have been installed with MySQL itself.
[quoted text clipped - 11 lines]
> and the first of that which comes; so with present time."
> - Leonardo da Vinci (1452-1519)

There is a package called "Headers and libraries". You need to
install that as well if you want to compile code that talks to MySQL.

Reply to this Message

Lola J. Lee Beno - 14 Jun 2007 01:41 GMT

> There is a package called "Headers and libraries". You need to
> install that as well if you want to compile code that talks to MySQL.

Where do I get this package?

Signature

Reply to this Message

Chas Owens - 14 Jun 2007 01:46 GMT

> > There is a package called "Headers and libraries". You need to
> > install that as well if you want to compile code that talks to MySQL.
[quoted text clipped - 7 lines]
> and the first of that which comes; so with present time."
> - Leonardo da Vinci (1452-1519)

http://dev.mysql.com/downloads/mysql/5.0.html#downloads

Reply to this Message

Lola J. Lee Beno - 14 Jun 2007 01:59 GMT

>> Where do I get this package?

Umm . . . I don't see Headers and libraries available for OS X, just for
Red Hat, SuSE and Ubuntu Linux. ???

Signature

Reply to this Message

Steve Axthelm - 14 Jun 2007 01:14 GMT

> >The error message is telling you what file is missing - it's
> >the C client library that should have been installed with MySQL itself.
[quoted text clipped - 4 lines]
> I installed the 5.0.41 MySQL Community Server (GPL) from mysql.com -
> the package version. Install seemed to be going normally.

Looks like the path is wrong. It's looking in:

/usr/local/mysql/lib/mysql/

The lib directory should be:

/usr/local/mysql/lib/

-Steve

Signature

Steve Axthelm
steveax@pobox.com

Reply to this Message

Mac Forum / Programming / Perl / June 2007

Can't Install DBD::mysql