Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

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

by romy_mathew (Beadle)
on Nov 04, 2013 at 16:57 UTC ( [id://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.

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
    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/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
      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?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1061154]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others wandering the Monastery: (6)
As of 2024-03-28 19:14 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found