10.3: DBD::mysql install trouble and fix

Oct 27, '03 02:11:00AM

Contributed by: Anonymous

It seems with every release, DBD::mysql does not install be it via CPAN or manual compile. Panther ships with perl 5.8.1 RC3, multi-threads enabled. Previous hints posted on how to upgrade from Jaguar's perl version of 5.6 to 5.8.0 warned that multi-threading was not supported by DBD::mysql, and further searching showed that multi-threading was supported if you were to revert gcc to 2.95 for the compile. None of these hints will help with Panther...

I started searching some email archives and came up with a few posting the same errors I was experiencing but no solutions. So I started hacking away by following all past tips on compiling DBD::mysql for OSX 10.2 and perl 5.8.0 with no success. I then remembered installing Bundle::Msql at one point on a different system and decided to try that ... success!

Read on for more on the situation, and official word from Apple on a solution...

Bundle::Msql installs the DBD::mysql package but seems to do it differently than DBD::mysql itself. I sent my success scenario to the macosx@perl.org list (list archive) and received an interesting reply that may very well apply to more than just DBD::mysql:

On 10/15/03 5:58 PM, "Edward Moy" wrote:

We recently discovered the DBD::mysql problem as well. The patch is to edit /System -> Library -> Perl -> 5.8.1 -> darwin-thread-multi-2level -> Config.pm, replacing:
ld='MACOSX_DEPLOYMENT_TARGET=10.3 cc'
with
ld='env MACOSX_DEPLOYMENT_TARGET=10.3 cc'
Unfortunately, this change is too late to get into Panther.
---------------------------------------------------------------
Edward Moy
Apple
I have now tested this under perl installed by Panther and it seems to solve the problem ... one thing to note is that I read elsewhere that fink updates @INC and that some packages installed by fink may cause conflicts; specifically noted was Storable.

This hint is nowhere near a nicely detailed outline of how to make things work, but the emails posted to the macosx@perl.org list should shed some light...

Comments (20)


Mac OS X Hints
http://hints.macworld.com/article.php?story=20031015212910375