Fixing perl environment problem on os x 10.7

When upgrading from 10.6 to 10.7 some of my perl modules seemed to break (namely DBD::mysql). I tried to re-install via cpan and couldn't do it. Couldn't even do a force install.

Fortunately, there are alot of perl mods available through the fink package manager. I ran:

sudo fink install dbd-mysql-pm5123

and it installed the module no problem. Great. I could then execute my perl programs from the command line. Problem is, the path where fink puts the perl mods is not available to cron. So, I had to specify the additional perl library paths in the crontab itself. I added this to the top of my crontab:

PERL5LIB=/sw/lib/perl5/5.12.3/darwin-thread-multi-2level:/sw/lib/perl5/5.12.3:/sw/lib/perl5/darwin-thread-multi-2level:/sw/lib/perl5:/sw/lib/perl5/darwin:$PERL5LIB
LC_ALL=C

Source: Peter's Mac OS X Notes