Re: CGI-script and Ingres

Craig R. McClanahan (crm@perpetua.dat.com)
Mon, 27 Nov 1995 07:45:48 +0800


Date: Mon, 27 Nov 1995 07:45:48 +0800
From: crm@perpetua.dat.com (Craig R. McClanahan)
Message-Id: <9511271545.AA17606@perpetua.dat.com>
To: svesj@svenska.gu.se
Cc: www-html@w3.org
In-Reply-To: <Pine.HPP.3.91.951127152609.7874A-100000@logos.svenska.gu.se> (message from Sofie Johansson Kokkinakis on Mon, 27 Nov 1995 15:35:38 +0100 (MET))
Subject: Re: CGI-script and Ingres

>>>>> "Sofie" == Sofie Johansson Kokkinakis <svesj@svenska.gu.se> writes:

    Sofie> I am writing CGI-scripts in Perl and with the purpose of
    Sofie> creating an=20 interface in which it will be possible to do
    Sofie> a search in a database=20 created in Ingres.

    Sofie> I have managed to write a working Perl-script to call a
    Sofie> C-program which=20 contains embedded sql search routines,
    Sofie> and it works fine.=20 But when I try to call the
    Sofie> Perl-script from a "form" I recieve an error=20 message:

    Sofie> "ERlookup: Error accessing message text: For unknown
    Sofie> reasons. Check=20 messages files in the
    Sofie> installation. Internal error. Report this problem to your
    Sofie> technical=20 representative. INGRES ERROR: 9961473"

This sounds like the kind of message Ingres will give you when your
Ingres related environment variables and/or PATH are not set up correctly.
I had some similar grief getting programs that talked to Oracle to work,
until I realized that the HTTPD server (I use CERN's, but I suspect it's
true for others as well) does not execute the .login/.cshrc (c-shell users)
or .profile (Bourne shell users) of the username under which the script is
run.  Because I was setting up my environment variables there, they weren't
getting initialized properly.

Try making sure that the login under which your server runs (and, therefore,
under which it executes CGI scripts) has all of the correct environmental
variables set *before* you start the HTTPD server itself.  Then, any process
started to run a CGI script should inherit the correct settings.

----------
Craig R. McClanahan                     EMAIL:  crm@dat.com
DAT Services                            Phone:  503-526-6405
Beaverton, OR, USA                      Fax:    503-526-6442