Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : Problems to connect to MySQL via Perl



Threaded Mode | Print  

 Problems to connect to MySQL via Perl, We get an error when we are trying to connect to a MySQL database (0 Replies, Read 41860 times)
funny987
Group: Member
Post Group: Newbie
Posts: 1
Status:
Hello,

we have a problem to connect from a cgi file to a MySQL database.

(With AMPPS 3.2 on a MAC OS X 10.10.4 Yosemite)

Our small test script is the following:

Code

#!/Applications/AMPPS/perl/bin/perl -w

use strict;
use DBI;
use CGI::Carp qw(fatalsToBrowser);
use Digest::MD5 qw(md5_hex);
use CGI;

my $query=new CGI ;

my $dbh=DBNEW();
$dbh->disconnect ();

##########
sub DBNEW 
##########
{
    my $dsn = "DBI:mysql:database-name:database-host";
    my $dbh="";

    # Connect
    unless ( $dbh = DBI -> connect ("$dsn", "db-user", "dbpass" , {RaiseError=>1,PrintError=>0} ) ) {
        die "no connect: $DBI::errstr";   
    }
       
    return ( $dbh );
}


And when we start this script in a browser, we get the following error notice:

Code

Software error:

install_driver(mysql) failed: Can't load '/Applications/AMPPS/perl/lib/site_perl/5.20.2/darwin-2level/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Applications/AMPPS/perl/lib/site_perl/5.20.2/darwin-2level/auto/DBD/mysql/mysql.bundle, 1): Library not loaded: libmysqlclient.18.dylib
  Referenced from: /Applications/AMPPS/perl/lib/site_perl/5.20.2/darwin-2level/auto/DBD/mysql/mysql.bundle
  Reason: image not found at /Applications/AMPPS/perl/lib/5.20.2/darwin-2level/DynaLoader.pm line 197.
at (eval 7) line 3.
Compilation failed in require at (eval 7) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /Applications/AMPPS/www/cgi-bin/test.cgi line 35.


Can you maybe see, what we are doing wrong? How can we solve the problem?

Thank you!

Funny

IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 19, 2024, 2:26 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.022