Perl Script and Postgres DB running via Apache Web Server

From: Carla J Breuker <carlajb(at)juno(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Perl Script and Postgres DB running via Apache Web Server
Date: 2000-02-27 23:40:42
Message-ID: 20000227.164045.-425475.0.CarlaJB@juno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hi...

I have the following Perl Script (with Postgres code):

#!/usr/bin/perl -w
use Pg;

print "<HTML><P>This is a test</HTML"

$conn = Pg::connectdb("dbname=test");
$conn->exec("insert into test_table values ('Carla', '90')");

This Script will run from the command line, and inserts values into the
existing DB and table.
When it is run via the web browser, nothing happens (browser hangs).

The script is in the /usr/local/httpd/cgi-bin directory, owned by a user
(not root), and has 755 permissions.

We have exhaustively searched perl, cgi, postgres, and apache
documentation both printed and web-based,
and cannot determine how to correct this problem.

We suspect that it may be a permissions / execution rights for the httpd,
but we are stumped.

Any help will be greatly appreciated.

Thanks,
-Carla and Chris :)
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.

Browse pgsql-interfaces by date

  From Date Subject
Next Message Byron Nikolaidis 2000-02-27 23:45:03 ODBC Driver changes for unix...
Previous Message Guillaume Rousse 2000-02-27 23:27:55 Just to be sure...