[Fwd: Re: CGI program cannot access database]
-------- Original Message --------
Subject: Re: [GENERAL] CGI program cannot access database
Date: Fri, 08 Oct 2004 10:34:12 +0400
From: Maarten Boekhold <boekhold@emirates.net.ae>
To: Samik Raychaudhuri <samik@freeshell.org>
References: <4165F78F.7070002@freeshell.org>
Samik Raychaudhuri wrote:
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.
Are you trying to run this under cygwin? If so, there's a very recent
thread on the cygwin mailing list about this. Apache clears the
environment before launching a CGI script, but the winsock API requires
the SYSTEMROOT environment variable to be set. You can configure apache
*not* to remove that variable from the environment.
Maarten
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:
http://archives.postgresql.org/pgsql-cygwin/2004-07/msg00060.php
This wasn't much helpful.
Can you please post the link to the thread. That will be very helpful.
Regards,
-Samik
On 10/8/2004 1:34 AM, Maarten Boekhold wrote:
Show quoted text
Are you trying to run this under cygwin? If so, there's a very recent
thread on the cygwin mailing list about this. Apache clears the
environment before launching a CGI script, but the winsock API requires
the SYSTEMROOT environment variable to be set. You can configure apache
*not* to remove that variable from the environment.Maarten
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
Show quoted text
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 this. Apache clears the
environment before launching a CGI script, but the winsock API requires
the SYSTEMROOT environment variable to be set. You can configure apache
*not* to remove that variable from the environment.Maarten
could phppgadmin serve your purpose?
http://phppgadmin.sourceforge.net/
Not exactly... I am looking for a more customized ways to present a
user an option to edit the data. For example, a user will click an
edit link on a certain item (from the main interface) and he'll be
presented with a form that allows him easily to edit this specific
items. Notice, that the user won't see the regular column names or IDs
as he would with any raw database admin system, instead, he'd see the
softer version with easy field names and where IDs are automatically
formed into listboxes.
I found several systems that get close to the idea, but none is
exactly what I'm looking for:
DBForm (http://dbform.sourceforge.net/): Seems quite good, if I will
be able to grasp all its functions as its original form is not exactly
what I need.
NetXTensio (http://www.interaktonline.com/Products/Dreamweaver-Extensions/NeXTensio/Overview/)
- It is a dreamweaver extension... Besides being expensive I couldn't
to get it work properly with PostgreSQL :(.
If someone has another ideas I'd be glad to hear.
------------------------------------------------------------------------------------------------
Laser wrote:
could phppgadmin serve your purpose?
http://phppgadmin.sourceforge.net/
Vitaly wrote:
I'm looking for software that can generate PHP scripts from PostgreSQL
database that will allow for distant users to edit the data.The idea is to let selected users have EASY access to edit the data
they see, I can't possibly give raw access with pgMyAdmin or anything
of sorts, as it is hardly accessible for the average user.For MySQL I know the PHPMaker (http://www.hkvstore.com/phpmaker/) but
I haven't yet found anything of sorts for PostgreSQL.Needed features:
* Ability to add/edit/delete data.
* Ability to mask the columns and show only some of them (for example,
the numerical pk is not needed).
* Ability to work with joins between tables (e.g customer and
customer_type, which means the customer will have a column with a list
box letting the user choose the type).
* Would be really nice if it had some kind of option to save the
changed but not to apply them until someone approves them...Anyone knows some kind of software that does that?
--
ICQ: 1912453
AIM: VitalyB1984
MSN: tmdagent@hotmail.com
Yahoo!: VitalyBe
Import Notes
Resolved by subject fallback