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

From Carla J Breuker
Subject Perl Script and Postgres DB running via Apache Web Server
Date
Msg-id 20000227.173459.-498311.0.CarlaJB@juno.com
Whole thread Raw
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Matthew
Date:
Subject: RE: [ADMIN] Creating nobody user so website visitors can update r ecords
Next
From: phawkins@connact.com (Patricia Hawkins)
Date:
Subject: Re: Perl Script and Postgres DB running via Apache Web Server