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

From phawkins@connact.com (Patricia Hawkins)
Subject Re: Perl Script and Postgres DB running via Apache Web Server
Date
Msg-id 1116-Tue29Feb2000000451-0500-phawkins@connact.com
Whole thread Raw
In response to Perl Script and Postgres DB running via Apache Web Server  (Carla J Breuker <carlajb@juno.com>)
List pgsql-admin
One:
su root
su - nobody
Cd to the appropriate directory.  Run the script.  What happens?

Two: (If that didn't help) Do the CGI magic to make the browser
display the environment variables set for the CGI script.  Su to
nobody (as above) and set all the env variables (and I mean all of
them, including HOME) the same as for the browser.

Run the script.  What happens?

Three: If you got a failure, then su to nobody, and set all the env
variables identically to those of the user (or situation) for which
the script works.  Run the script.

Four:  Change them one by one, running the script each time.

Modify algorithm as necessary as illumination strikes.  Take careful
notes.

Be wary of init files in home directories.

>>>>> "p" == pgsql-admin-digest  <owner-pgsql-admin-digest@hub.org> writes:

p> Date: Sun, 27 Feb 2000 17:27:29 -0700
p> From: Carla J Breuker <carlajb@juno.com>
p> Subject: Perl Script and Postgres DB running via Apache Web Server

p> Hi...

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

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

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

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

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

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

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

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

p> Any help will be greatly appreciated.

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

p> ------------------------------

p> End of pgsql-admin-digest V1 #463
p> *********************************


p> ************



pgsql-admin by date:

Previous
From: Carla J Breuker
Date:
Subject: Perl Script and Postgres DB running via Apache Web Server
Next
From: Michael Holopainen
Date:
Subject: HELP, Postgres stops accepting connections from Unix socket