perl and mysql issue

[Jim Goh <gchien5k@xxxxxxxxx>]

Hi,

 

I have perl 5.6.1 and mysql 5.0.24 installed and the following perl script works fine from command line, but not working when I run from the IE browser:

 

#!/usr/local/bin/perl

use DBI;
use CGI qw(:standard);
use CGI::Carp 'fatalsToBrowser';
use strict;

 

print header;
print start_html;

my $docID;
my $docfile = "test.doc";
my $docdesc = "this is test";
my $last_update;
my $dbh = DBI->connect("dbi:mysql:dbname", "username", "password" )
        or &dienice("Can't connect to database: $DBI::errstr");

my $sth = $dbh->prepare("insert into test_tbl values(?,?,?,?)") or &dbdie;
$sth->execute($docID, $last_update, $docfile, $docdesc) or &dbdie;

print end_html;

and here is the error i got from browser after ran it:

 

Software error:

install_driver(mysql) failed: Can't load '/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: perl: fatal: libmysqlclient.so.15: open failed: No such file or directory at /usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206.   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 expected   at /usr/local/apache2/cgi-bin/testdb.pl line 15

Thanks all for your help!

---

Any questions?  Get answers on any topic at Yahoo! Answers. Try it now.