Re^5: Getting DBD-mysql to work with Mac OS X Lion

[luis.roca]

Sorry to hear you're still having trouble. Could you please post the code that is failing? Specifically what does your #! line look like at the top? Did you install the DBD module in the Macports /opt directory? Other than that I would say to load the library it's asking for through Macports or, even before that, do a search to see if and where the current version is on your machine.

[bmckenzie]

Here's the script:

#!/usr/bin/perl

use strict;
use warnings;

use CGI;
use CGI::Carp qw(fatalsToBrowser set_message);

# set my module lib
use FindBin qw($Bin);
use lib "$Bin/perl_lib";
use Util::Std;
use Util::Std qw/:IO/;
use Date::DT_Util;
use CGI::Application;
use DBI;
use DBD::MySQL;
print "Content-type: text/html\n\n";
print "Hello, World";

As noted, works fine if I comment out DBD::MySQL. The latter is where the CPAN installer put it: "(System) Library/Perl/5.12/darwin-thread-multi-2level/auto/DBD/". I noticed in the path, the file name is all lower case, where my script calls for "MySQL". However, changing this has no effect. I get the same error.

I don't see any DynaLoader.pm in that Library where DBD::MySQL seems to be looking for it. When I went to install DynaLoader, it failed, and the CPAN installer said I'd need to force install. "force install DynaLoader" resulted in a lot of scary questions related to changing or rebuilding the C Compiler for Perl 5.8 (I've got 5.12.3 on the computer). So I bailed out. Ugh.

Bruce

[Anonymous Monk]

What is this "DBD::MySQL" and where did you get it?

The DBD-mysql distribution only comes with DBD::mysql

Case matters

As for DynaLoader, it comes with perl, you don't need to install it

See Re^5: Getting DBD-mysql to work with Mac OS X Lion and answer it

[bmckenzie]

Strangely, in this instance case does not appear to matter -- I wrote that line of code "use DBD::MySQL" years ago -- and, for some reason, it has always worked -- on Windows and on Linux. The script fails in the same way if it is "DBD::mysql" or if I don't load DBD::mysql directly, but instead do DBI->connect("DBI:mysql:data . . .

My problem is not that the module isn't found, it's that DBD::mysql doesn't know where to find (or otherwise can't load) libmysqlclient.18.dylib. I don't know either! The closest I can get with Spotlight is /opt/local/lib/mysql5/libmysqlclient.16.dylib

[luis.roca]

Outside of the responses regarding Dynaloader and DBD::mysql, note that your shebang line is likely still calling the system Perl.
Replace it with: #!/opt/local/bin/perl to call the version installed using MacPorts