Mailing-List: contact users-help@httpd.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@httpd.apache.org
Received-SPF: pass (herse.apache.org: local policy)
Message-ID: <20061213155218.43715.qmail@web52911.mail.yahoo.com>
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
  b=NjlASH+vy3Wytms0A9DYdkUHsO5KbLmT914l+Aux0zl49drjuSykQ5v1HE457M3MyoPGQULrASxzWwS10in3myOHruI2/YD1x7OKWmY0HmG0H3JZAbH/ed+4gnqDGZzrDC7DpJmUAU5jWamIGY7gz+vPpns3IWkpe1LK/tSMIZM=;
Date: Wed, 13 Dec 2006 07:52:18 -0800 (PST)
From: Jim Goh <gchien5k@yahoo.com>
To: users@httpd.apache.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-509207268-1166025138=:42540"
Content-Transfer-Encoding: 8bit
Subject: [users@httpd] perl and mysql issue

--0-509207268-1166025138=:42540
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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.
--0-509207268-1166025138=:42540
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<div>Hi,</div>  <div>&nbsp;</div>  <div>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:</div>  <div>&nbsp;</div>  <div>#!/usr/local/bin/perl</div>  <div>use DBI;<BR>use CGI qw(:standard);<BR>use CGI::Carp 'fatalsToBrowser';<BR>use strict;</div>  <div>&nbsp;</div>  <div>print header;<BR>print start_html;</div>  <div>my $docID;<BR>my $docfile = "test.doc";<BR>my $docdesc = "this is test";<BR>my $last_update;<BR>my $dbh = DBI-&gt;connect("dbi:mysql:dbname", "username", "password" )<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; or &amp;dienice("Can't connect to database: $DBI::errstr");</div>  <div>my $sth = $dbh-&gt;prepare("insert into test_tbl values(?,?,?,?)") or &amp;dbdie;<BR>$sth-&gt;execute($docID, $last_update, $docfile, $docdesc) or &amp;dbdie;</div>  <div>print end_html;<BR></div>  <div>and here is the error i got from browser after ran it:</div> 
 <div>&nbsp;</div>  <H1>Software error:</H1><PRE>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  </PRE><PRE>Thanks all for your help!</PRE><p>&#32;

<hr size=1>Any questions?  Get answers on any topic at <a href="http://answers.yahoo.com/;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx">Yahoo! Answers</a>. Try it now.
--0-509207268-1166025138=:42540--