Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re^3: DBD::Mysql not working properly in mac OS X

by romy_mathew (Beadle)
on Nov 04, 2013 at 16:57 UTC ( #1061154=note: print w/replies, xml ) Need Help??

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 (Priest) 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:

    Also, to see any errors, add these lines directly after the first line:
    use CGI::Carp('fatalsToBrowser'); print "Content-type:text/html\n\n";
      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/ 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/ line 22
      I tried #!/usr/bin/perl5.12.4 failed with html error 500
        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";

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1061154]
[thezip]: So, we have a small deployment coming up soon for a project. What is the general name for the project management documentation that details the tasks and schedules/ sequences for the execution of the deployment?

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (12)
As of 2017-02-23 17:42 GMT
Find Nodes?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?

    Results (350 votes). Check out past polls.