Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces

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.

	-Carla and Chris :)
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group