Received: from m9.boston.juno.com (m9.boston.juno.com [205.231.100.195])
	by hub.org (8.9.3/8.9.3) with ESMTP id XAA53567
	for <pgsql-interfaces@postgresql.org>;
	Sun, 27 Feb 2000 23:41:55 -0500 (EST)
	(envelope-from carlajb@juno.com)
Received: from cookie.juno.com by cookie.juno.com for
	<"cS4pPc56dU/ddBHy7GYC2JaJGHH9XWAiS55tNpl0tV30e3tgRUIfHQ==">
Received: (from carlajb@juno.com)
	by m9.boston.juno.com (queuemail) id EZVW6ADU;
	Sun, 27 Feb 2000 23:40:38 EST
To: pgsql-interfaces@postgresql.org
Date: Sun, 27 Feb 2000 16:40:42 -0700
Subject: Perl Script and Postgres DB running via Apache Web Server
Message-ID: <20000227.164045.-425475.0.CarlaJB@juno.com>
X-Mailer: Juno 4.0.5
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Juno-Line-Breaks: 0-11,13-15,17-18,20-22,24-28
X-Juno-Att: 0
X-Juno-RefParts: 0
From: Carla J Breuker <carlajb@juno.com>

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.