Perl Script and Postgres DB running via Apache Web Server - Mailing list pgsql-interfaces

From Carla J Breuker
Subject Perl Script and Postgres DB running via Apache Web Server
Date
Msg-id 20000227.164045.-425475.0.CarlaJB@juno.com
Whole thread Raw
List pgsql-interfaces
Hi...

I have the following Perl Script (with Postgres code):
#!/usr/bin/perl -wuse 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.


pgsql-interfaces by date:

Previous
From: Byron Nikolaidis
Date:
Subject: new driver
Next
From: "Sirish Kumar"
Date:
Subject: ecpg runtime problem