Phil Gyford

Does the 'cpan' command not work on Panther? Typing:

cpan Bundle::DBI

should do the works for you.

Last time I tried CPAN on my Mac (before Panther I think), it started trying to update the whole of Perl or something. I have thus been put off for life. And although I've also, previously, been put off installing any perl modules by my repeated lack of success, I tried Nick's more manual instructions before his second suggestion of cpan... thankfully it worked.

If you're serious about developing with Perl, install the developer tools. If you don't, things will not work. Always install the developer tools. Really. Not kidding here.

CPAN is much much happier on Panther than it was on Jaguar, where it did have that annoying tendency to go batshit and try to install the whole of Perl 5.8 over 5.6. Learn to love it, and if you can't, learn to love CPANPLUS instead. They really do save you more trouble than you care to think about. (Imagine if DBI relied on a module, and then imagine that module relied on another one.)

It might also be worth noting that some build failures with DBD::MySQL are related to a bug in (pre-release) version of Perl shipped with Panther. I'm not sure if this has been fixed in any of the subsequent point releases, but the instructions for doing it yourself are here:

http://www.macosxhints.com/article.php?story=20031015212910375

Thanks Paul. I think though that any thoughts I may once have had about doing serious Perl development have waned... too much PHP has made Perl seem impossibly difficult and I need Perl rarely enough that the rustiness will probably never disappear. I really just wanted Movable Type to work with MySQL...

There instruction worked after I downloaded the most current version of Xtools, older versions of the developer package may not work for MACOSX 10.3.4 install perl DBI DBD

Manual install on 10.2.8 with Perl 5.6.0 went well.

I had to install Test::Simple 0.49 from CRAN to get rid of Test/More.pm deficiency. From there simply followed above directions, with the exception of NOT ammending the Makefile created by Makefile.PL when installing DBD::mysql - apparently fixed (didn't find the offending line in the Makefile...)

Cheers

A couple of comments. Step 5 should be split into 3 steps.

5. make - to make the libraries, etc.
6. make test - to test the library and mysql, optional
7. sudo make install - the installation will most likely require admin privileges since it will try to install a couple of applications into /urs/bin which it doesn't have the rights to. Not using sudo can cause problems in the long run if other applications relying on DBI think those applications are present.

- Jonas

Phil, thanks very much for this article. I am in pretty much the same boat you were in. Am running Mac OS X Server 10.3.7 on a PowerBook G4/500 and want to get DBD::mysql installed for my Movable Type blog (want to convert from BerkeleyDB to MySQL). Am running Perl 5.8.1 (I think part of the standard Panther Server installation).

I am stuck on the 'perl Makefile.PL' step, however:

$ perl Makefile.PL

*** You are using a perl configured with threading enabled.
*** You should be aware that using multiple threads is
*** not recommended for production environments.

*** Note:
The optional PlRPC-modules (RPC::PlServer etc) are not installed.
If you want to use the DBD::Proxy driver and DBI::ProxyServer
modules, then you'll need to install the RPC::PlServer, RPC::PlClient,
Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you.
You can install them any time after installing the DBI.
You do *not* need these modules for typical DBI usage.

Optional modules are available from any CPAN mirror, in particular
http://search.cpan.org/
http://www.perl.com/CPAN/modules/by-module
http://www.perl.org/CPAN/modules/by-module
ftp://ftp.funet.fi/pub…

Creating DBI::PurePerl test variant: t/zvpp_01basics.t
Creating DBI::PurePerl test variant: t/zvpp_02dbidrv.t
Creating DBI::PurePerl test variant: t/zvpp_03handle.t
Creating DBI::PurePerl test variant: t/zvpp_04mods.t
Creating DBI::PurePerl test variant: t/zvpp_05thrclone.t (use threads)
Creating DBI::PurePerl test variant: t/zvpp_06attrs.t
Creating DBI::PurePerl test variant: t/zvpp_07kids.t
Creating DBI::PurePerl test variant: t/zvpp_08keeperr.t
Creating DBI::PurePerl test variant: t/zvpp_09trace.t
Creating DBI::PurePerl test variant: t/zvpp_10examp.t
Creating DBI::PurePerl test variant: t/zvpp_14utf8.t
Creating DBI::PurePerl test variant: t/zvpp_15array.t
Creating DBI::PurePerl test variant: t/zvpp_20meta.t
Creating DBI::PurePerl test variant: t/zvpp_30subclass.t
Creating DBI::PurePerl test variant: t/zvpp_40profile.t
Creating DBI::PurePerl test variant: t/zvpp_41prof_dump.t
Creating DBI::PurePerl test variant: t/zvpp_42prof_data.t
Creating DBI::PurePerl test variant: t/zvpp_50dbm.t
Creating DBI::PurePerl test variant: t/zvpp_60preparse.t
Creating DBI::PurePerl test variant: t/zvpp_80proxy.t
Checking if your kit is complete...
Looks good

Error: Unable to locate installed Perl libraries or Perl source code.

It is recommended that you install perl in a standard location before
building extensions. Some precompiled versions of perl do not contain
these header files, so you cannot build extensions. In such a case,
please build and install your perl from a fresh perl distribution. It
usually solves this kind of problem.

(You get this message, because MakeMaker could not find "/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h")
# Looks like your test died before it could output anything.

Any suggestions?

Thanks,
Derek

I'm afraid I know next to nothing about this kind of stuff Derek. FWIW, I have had more luck recently installing stuff using cpan than last time I tried (a couple of years previously). Sorry I can't be more help.

Ha!... Not true!... Your article has already been helpful and insightful for me. Thanks for your feedback. Not sure what cpan is but will check it out. I would guess that it is similar to fink. Actually, my problem might be due the fact that I did not install the developer tools so I am going to try that... this was suggested by Seth on his blog here: http://www.truerwords.net/3556. Will see...

Thanks again!

Cheers,
Derek

One big thing on installing Perl Modules on OS X 10.3: Be sure that you install the Developers Tools from the disk included with 10.3. The version of Perl included with 10.3 is incomplete until you install the Developers Tools and the Makefile.PL won't run completely.

These instructions are as valid today as ever. I used this to install these modules on my iNtel iMac with 10.4.5. [I did not think I would need to install DevTools from the DVD. I was wrong.]

Hi Guys,

I have just recieved delivery of a shiney new intel mac book pro, coming from a linux/gentoo/solari background I thought i would try something i didnt have to compile and build for 5 days to get it working,

I am having issues compiling the DBD::Mysql module which i have downloaded from CAPN.

I have already installed the DBI::Bundle which looked ok on install, here is the ourput i am getting.

clarke-wardles-computer-2:~/Desktop/DBD-mysql-4.001 wardlec$ perl Makefile.PL
I will use the following settings for compiling and testing:

cflags (mysql_config) = -I/usr/local/mysql-standard-5.0.27-osx10.4-i686/include -Os -arch i386 -fno-common
embedded (mysql_config) =
libs (mysql_config) = -L/usr/local/mysql-standard-5.0.27-osx10.4-i686/lib -lmysqlclient -lz -lm
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testsocket (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Checking if your kit is complete...
Looks good
Using DBI 1.53 (for perl 5.008006 on darwin-thread-multi-2level) installed in /Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI/
Writing Makefile for DBD::mysql
clarke-wardles-computer-2:~/Desktop/DBD-mysql-4.001 wardlec$ make
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cc -c -I/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI -I/usr/local/mysql-standard-5.0.27-osx10.4-i686/include -Os -arch i386 -fno-common -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -g -pipe -fno-common -DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing -I/usr/local/include -O3 -DVERSION=\"4.001\" -DXS_VERSION=\"4.001\" "-I/System/Library/Perl/5.8.6/darwin-thread-multi-2level/CORE" dbdimp.c
dbdimp.c: In function 'mysql_dr_connect':
dbdimp.c:1677: error: 'ulong' undeclared (first use in this function)
dbdimp.c:1677: error: (Each undeclared identifier is reported only once
dbdimp.c:1677: error: for each function it appears in.)
dbdimp.c:1677: error: parse error before numeric constant
make: *** [dbdimp.o] Error 1

Any help would be appreciated.

Thanks Clarke (Virgin Mac user)

Clarke-

You need to add a line to /usr/local/mysql/include/mysql_com.h . Stick the following at the top of the file:

typedef unsigned long ulong;

I found this tip over at fuel.stuffo.info/blog/…

Once I did that, I got through that error, but I had problems at the linking stage. If you're using a G5, and 64-bit MySQL 5.0 (perhaps other 64-bit versions as well), you will likely get an error like:

/usr/bin/ld: truncated or malformed archive: /usr/local/mysql/lib/libmysqlclient.a (ranlib structures in table of contents extends past the end of the table of contents, can't load from it)

After I reinstalled MySQL 32-bit (using the binaries from MySQL.com), the DBD::mysql package compiled and installed without a problem (in fact, I didn't even have to add that line to mysql_com.h).

Hope this helps...

-phil