[MacPerl] installing DBD::RAM and DBD::CSV via Macperl and cpan-mac

["Scott R. Godin" <webmaster@webdragon.net>]

install the CPAN shell (which on the Macintosh is the ported cpan-mac-0.40
at the least -- I notice he has an 0.50 now, but I haven't tested that yet
:) from http://www.perl.com/CPAN-local/authors/id/CNANDOR/ )

then run the new CPAN-shell.plx

using that, install Chris Nandor's Storable port -- CPAN can use the
metadata if you update CPAN again (which we'll get to in a minute).

type 'install CNANDOR/Storable-0.6@4-bin-1-Mac.tgz' into the CPAN shell.

Allocate more RAM to CPAN-shell.plx or you'll get an out of memory error,
before doing this --> (you can also 'install CPAN' (*** not! 'install
Bundle::CPAN' which will break things ***) to get to CPAN 1.59 -- it will
detect that Storable is installed when you type 'reload CPAN' after
installing. :) <-- this is a good thing.

HOWEVER, you will need to edit CPAN.pm to remove the warnings (by adding
quotes around 'make', 'description', and 'gzip' in the line numbers
mentioned the first time you run the CPAN shell after updating CPAN.)

NEXT install the DBI modules in THIS ORDER!

install the
  Module                      using this
    DBI            (CNANDOR/DBI-1.08-bin-2-MacOS.tar.gz)
    SQL::Statement (CNANDOR/SQL-Stmnt-0.1012-bin-1-Mac.tgz)
    Text::CSV_XS   (CNANDOR/Text-CSV_XS-0.18-bin-2-Mac.tgz)

( i.e. 'install CNANDOR/DBI-1.08-bin-2-MacOS.tar.gz' *not* 'install DBI' )

modules as found on Chris Nandor's page http://pudge.net/mmp/ (as these
modules contain binaries and MUST be ported to Macintosh) using the CPAN
shell. MAKE SURE THAT YOU INSTALL IN THIS ORDER!!

now, here's the painful part

to install DBD::CSV (first) and DBD::RAM (second) you MUST do the following

start CPAN-shell.plx
enter 'install DBD::CSV'
(it will run and fail. let it.)

re-start the CPAN-shell.plx

enter 'look DBD::CSV' into the CPAN Shell

then switch to the Finder and go to :MacPerl Ÿ:.cpan:build:DBD-CSV-0.1024:
and edit the Makefile.PL with your favorite text editor .. the lines you
want to change are this (@ lines 51 & 52):

    change

foreach $dir (@INC) {
    if (-f "$dir/auto/DBI/DBIXS.h") {
    $DBI_INC_DIR = "-I$dir/auto/DBI";
    last;
    }
}

    to

foreach $dir (@INC) {
    if (-f "$dir:auto:DBI:DBIXS.h") {
    $DBI_INC_DIR = "-I$dir:auto:DBI";
    last;
    }
}

save your changes, and quit your editor.

then switch back to the CPAN shell and re-enter 'install DBD::CSV' again,
and it will work! :D

if you don't do the 'look' first, what happens is that it unpacks the
archive again and overwrites your change to the Makefile.PL (doh). ;)

This works. It's sneaky, but effective.

I hope this information helps any other Mac people looking to use the DBI,
and grant permission to Chris to include this info on his mmp site for
people that wish to install DBI (as long as he's willing to include a kudo
or two to me for figuring it out hehe =8)

of course, I haven't tested whether any of this actually WORKS OR NOT but
the install went ok. *chucklesn0rt* -- further reports of failure, if any,
to follow. If you haven't heard from me in a few days, that means everything
went fine and I'm buried in my DBI book. :D

(Chris, also you might wish to update the MMP page to indicate that the
current version of Tim Bunce's DBI is 1.14, not 1.13.. just FYI. HTH.)


-- 
Scott R. Godin            | e-mail : webmaster@webdragon.net
Laughing Dragon Services  |    web : http://www.webdragon.net/



# ===== Want to unsubscribe from this list?
# ===== Send mail with body "unsubscribe" to macperl-request@macperl.org