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
|