Mac Forum / Programming / Perl / October 2006

Thanks for the suggestions.

The reason I've done it this way is because I have a set of perl  
scripts and web apps that require a Perl environment that is  
identical across several machines, including my PowerBook and a few  
Linux servers. Sounds like the best approach is just to make my  
scripts/apps use /usr/local/bin/perl on all of my machines.

Just for the sake of curiousity, I'd be interested in knowing what  
Tiger's perl install includes beyond what is part of the core  
perl-5.8.6. Anybody have a list somewhere?

Thanks,

    Ray

I just installed 5.8.8 in /usr/local. It went very smoothly and Perl 5.8.8 seems to work fine.

Except that it can't see the packages in /System/Library/Perl/5.8.6 that I use all the time. Stuff like
  Date::Format
  Date::Parse
  LWP
  ...

I tried the 5.8.8 script
  #!/usr/local/bin/perl -w
  use strict;
  use lib "/System/Library/Perl/5.8.6";
  for (@INC) {
     print "$_\n";
  }
  #use Date::Format;

It shows @INC as
  /System/Library/Perl/5.8.6
  /Volumes/VTN Docs/ My Perl/Tests
  /usr/local/lib/perl5/5.8.8/darwin-2level
  /usr/local/lib/perl5/5.8.8
  /usr/local/lib/perl5/site_perl/5.8.8/darwin-2level
  /usr/local/lib/perl5/site_perl/5.8.8
  /usr/local/lib/perl5/site_perl
  .
Since Date/Format.pm is in /System/Library/Perl/5.8.6/,
I figured that I could use it by uncommenting the
  #use Date::Format;
line. No way. Perl 5.8.8 still can't use Date::Format:
  Can't locate Date/Format.pm in @INC ...

As you can see not much of a systems person. I haven't any idea how to straighten this problem out. I think I'll take Sherm Pendleys's advice and stick with 5.8.6.

Regards,

Vic

Presumably, your Perl app does something like ...

    $host = 'localhost';
    $dsn = "DBI:mysql:database=$database;host=$hostname";
    $dbh = DBI->connect($dsn, $user, $password);

... to connect to the MySQL database. When run from your wife's  
computer, you'll have to change the 'localhost' to the IP address of  
the computer where the MySQL database resides. You'll need to make  
sure your MySQL permissions are set up to allow this. You may want to  
try connecting to the database using the 'mysql' command line tool  
first. Once you can do that successfully, then make the appropriate  
mods to the connection parameters in your app.

       Ray

MySQL client libraries use TCP/IP - they neither know nor care about  
the physical network layer. So you'd do this the same way you'd  
connect to any other "remote server" - just supply the host name (or  
IP address) as part of the dsn.

my $dsn = "DBI:mysql:database=foo;host=192.168.1.101";
my $dbh = DBI->connect($dsn, $user, $password);

If that's not working, some things to check:

    • Are the MySQL client libs and DBD::mysql installed on the client?
    • Is $user authorized to connect from another host?
    • Is MySQL itself configured to allow such connections in general?

sherm--

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

    Ethernet address.

Good Luck.

Gregg