in reply to Re^2: DBD::Mysql not working properly in mac OS X
in thread DBD::Mysql not working properly in mac OS X

in location /System/Library/perl
i see 2 version, 5.10 and 5.12.
  • Comment on Re^3: DBD::Mysql not working properly in mac OS X

Replies are listed 'Best First'.
Re^4: DBD::Mysql not working properly in mac OS X
by tangent (Parson) on Nov 04, 2013 at 17:22 UTC
    I am assuming that your script does work when called from the terminal, but you get an error when you call it from the browser.

    If that is the case then try changing the first line of your script to: 

    #!/usr/bin/perl5.12.4

    [download]
    Also, to see any errors, add these lines directly after the first line: 
    use CGI::Carp('fatalsToBrowser');
print "Content-type:text/html\n\n";

    [download]
[reply]
[d/l]
[select]
      below is the error when i used use::Carp 
      install_driver(mysql) failed: Can't load '/Library/Perl/5.12/darwin-th
+read-multi-2level/auto/DBD/mysql/mysql.bundle' for module DBD::mysql:
+ dlopen(/Library/Perl/5.12/darwin-thread-multi-2level/auto/DBD/mysql/
+mysql.bundle, 1): Library not loaded: libmysqlclient.18.dylib
  Referenced from: /Library/Perl/5.12/darwin-thread-multi-2level/auto/
+DBD/mysql/mysql.bundle
  Reason: image not found at /System/Library/Perl/5.12/darwin-thread-m
+ulti-2level/DynaLoader.pm line 204.
 at (eval 10) line 3
Compilation failed in require at (eval 10) line 3.
Perhaps a required shared library or dll isn't installed where expecte
+d
 at /Library/WebServer/CGI-Executables/hello.pl line 22

      [download]
      I tried #!/usr/bin/perl5.12.4 failed with html error 500
[reply]
[d/l]
        I think your script is running with perl 5.10 when called from the browser, and that your mySQL is compiled against perl 5.12. To see if this is the case, create the following script and compare the results you get when called from the browser and when called from the terminal. 
        #!/usr/bin/perl
print "Content-type: text/html\n\n";
my $command = `perl -v`;
print "$command\n";

        [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom