Original Message
Subject: Re: [GENERAL] CGI program cannot access database
Date: Fri, 08 Oct 2004 10:34:12 +0400
From: Maarten Boekhold [EMAIL PROTECTED]
To: Samik Raychaudhuri [EMAIL PROTECTED]
References: [EMAIL PROTECTED]
Samik Raychaudhuri wrote:
Hello,
I am trying to run
* Samik Raychaudhuri [EMAIL PROTECTED] [2004-10-07 21:12:31 -0500]:
I am trying to run a perl CGI program for accessing a database. The
program runs fine from command prompt, producing expected
output. But it gives errors while running as CGI.
Has this ever worked?
On Fri, Oct 08, 2004 at 08:17:07AM -0700, Steven Klassen wrote:
* Samik Raychaudhuri [EMAIL PROTECTED] [2004-10-07 21:12:31 -0500]:
$dbh=DBI-connect(dbi:Pg:dbname='samik';host='abc.org';port=5432,samik,);
It seems that machine can't resolve abc.org (although I can). The
format of your
Hello,
Thanks very much for the replies. Please find follow-ups inline.
On 10/8/2004 11:05 AM, Michael Fuhr wrote:
On Fri, Oct 08, 2004 at 08:17:07AM -0700, Steven Klassen wrote:
* Samik Raychaudhuri [EMAIL PROTECTED] [2004-10-07 21:12:31 -0500]:
On 10/8/2004 10:17 AM, Steven Klassen wrote:
$dbh=DBI-connect(dbi:Pg:dbname='samik';host='abc.org';port=5432,samik,);
It seems that machine can't resolve abc.org (although I can). The
format of your connect string is a little unorthodox, but it seems to
work in general.
Thanks very much
* Samik Raychaudhuri [EMAIL PROTECTED] [2004-10-08 11:37:49 -0500]:
Thanks very much for your reply. Why do you say that the connect
string is a little unorthodox? I just followed the standard DBI
documentation.
Just not used to seeing the semi-colons in the DSN. Usually the
dbname, host, and
Hello,
Yes I am trying to run this under Cygwin. My apache server is running
locally, but the postgresql server is running remote at freesql.org.
I tried to search for the thread in postgresql-cygwin, but couldn't find
it. The only thread I came up with is this one:
I solved the problem, getting hints from Maarten. This is for posterity.
I looked at this thread:
http://www.cygwin.com/ml/cygwin/2004-09/msg01159.html
This thread (as well as Maarten) suggests to set/pass SYSTEMROOT
environment variable in Apache. I didn't know how to do that, googling
helped.
I still couldn't configure apache not to remove the variable from the
environ. Can you please let me know how to do that?
Regards.
-Samik
On 10/8/2004 1:34 AM, Maarten Boekhold wrote:
Are you trying to run this under cygwin? If so, there's a very recent
thread on the cygwin mailing list about
On Fri, Oct 08, 2004 at 11:35:34AM -0500, Samik Raychaudhuri wrote:
On 10/8/2004 11:05 AM, Michael Fuhr wrote:
failed: could not create socket: Operation not permitted
I wonder of packet filters are preventing the PostgreSQL connection
from working, and possibly causing DNS problems as
On Fri, Oct 08, 2004 at 10:09:13AM -0700, Steven Klassen wrote:
* Samik Raychaudhuri [EMAIL PROTECTED] [2004-10-08 11:37:49 -0500]:
Thanks very much for your reply. Why do you say that the connect
string is a little unorthodox? I just followed the standard DBI
documentation.
Just not
Hello,
I am trying to run a perl CGI program for accessing a database. The
program runs fine from command prompt, producing expected output. But it
gives errors while running as CGI.
- Program -
use DBI;
use DBD::Pg;
print Content-type: text/plain\n\n;
12 matches
Mail list logo