Execute permission on /home/iw-home/iw-perl/bin/perl ?
Prasanna Gopalakrishna wrote:
> Find an snippent of my script below...
>
> Also, I gave full permission to script(chmod 777 scriptname.pl). Other perl program
>works with 777 though! But while connecting to database it says 'permission denied'
>
> Is anything to do with webserver/database connectivity?
>
> Thanks
>
> -----------------------------------------------
> #!/home/iw-home/iw-perl/bin/perl
> use CGI qw(:standard);
> use DBI;
> use strict;
>
> print "Content-type: text/html\n\n";
> my $dbName = "DBI:Oracle:CSPET101.WORLD";
> my $dbUserName = "userid";
> my $dbPassword = "password";
>
> #Connecting to database
> my ($sql,$dbh,$dataObject);
>
> $dbh = DBI->connect($dbName, $dbUserName, $dbPassword,
> {
> PrintError =>0,
> RaiseError =>0
> }) or print "Can't Connect to the database:\n $DBI::errstr\n";
>
> $sql = "select * from GROUP_TBL";
> $dataObject = $dbh->prepare($sql) or print " $DBI::errstr SQL Error";
> $dataObject->execute() or print "Error Message: Requested table(s) might not exist
>$DBI::errstr\n";
>
> while (my @result_set=$dataObject->fetchrow_array)
> {
> print "@result_set\n";
> }
> -----------------------------------------------
>
> > From: "Sterin, Ilya" <[EMAIL PROTECTED]>
> > Date: 2001/04/24 Tue AM 12:10:57 EDT
> > To: Prasanna Gopalakrishna <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> > Subject: RE: Netscape server/ Oracle/ Perl
> >
> > The web server runs as user www or nobody (usually), so you must first
> > change the excution permissions for the script (chmod 755 script_name.cgi)
> > Also a snippet of your script would be helpful.
> >
> > Ilya Sterin
> >
> > -----Original Message-----
> > From: Prasanna Gopalakrishna [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, April 23, 2001 4:25 PM
> > To: [EMAIL PROTECTED]
> > Subject: Netscape server/ Oracle/ Perl
> > Sensitivity: Confidential
> >
> >
> > Hi all,
> >
> > I'm trying to connect oracle(8.0.3) database via Netscape Enterprise
> > server(3.6) on solaris 5.7
> >
> > I able to connect to database from perl program at unix prompt and not from
> > the web server.
> >
> > Do I need to do anything at perl program or webserver configuration
> >
> > log says 'permission denied'
> >
> > any suggestions?
> >
> > Thanks
> >
> >
> >
> >
--
Mark Vandenbroeck Mobile : +32-495-59.55.62
EMEA Support Information Systems Email : [EMAIL PROTECTED]
AIM : markvdb
