[users@httpd] piped logs and environment variables

[tempo <te...@tempo.dyndns.org>]

Hello,


I'm trying to forward Apache log into an Oracle database, using a "piped log".

But the script used in the pipe (Perl: DBI+Oracle DBD) can't find the ORACLE_HOME variable (exported in all profiles...). Of course, Oracle DBD needs this variable, and my script can't work

I have some knowledge of such problem in CGI scripts (simply use "SetEnv" directive), but this doesn't resolve my issue...

There's no clue on the web about such request...

So, do you know a way for using environment variables into piped log process ?

========
OS is Linux
Apache is 2.0.40
Oracle is 9.2 (ORACLE_HOME="/opt/ora920")
========

Best regards.

Frederic TEMPORELLI



---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org

Re: [users@httpd] CGI Internal Error

[Darrin Hodges <da...@walmac.com.au>]

that could indicate a parse error in the perl scripts, or an error from one of
the perl modules (if your using any).  it can also happen if you havent
prefixed any output from the script with:'

  print "Content-type: text/html\n\n";


i usually put this as the 2nd line line in a script.


also, does the script run from the command line (is there one on a mac?), 
or if the script
is clicked on ?,  the server may not know how to find the perl interpreter.

hope this helps

cheers
darrin

At 05:41 PM 7/05/2003 -0700, Steve Campbell wrote:
>Thanks to Mike and his help most of the day, I hve my cgi being called. I
>aam running Apache on Mac OS X.2
>
>I have cmod'ed my script and when I call it thru the browser, I get this
>error:
>
>Internal Server Error
>The server encountered an internal error or misconfiguration and was unable
>to complete your request.
>
>Please contact the server administrator, [no address given] and inform them
>of the time the error occurred, and anything you might have done that may
>have caused the error.
>
>
>
>
>Anyone have any idea?  The top of my script reads the usual pathway info:
>
>#!/usr/bin/perl
>
>I know that Perl is installed on the server, since I run mysql, etc.
>
>Any help would be appreciated.
>
>Thanks
>Steve
>
>
>
>---------------------------------------------------------------------
>The official User-To-User support forum of the Apache HTTP Server Project.
>See <URL:http://httpd.apache.org/userslist.html> for more info.
>To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>    "   from the digest: users-digest-unsubscribe@httpd.apache.org
>For additional commands, e-mail: users-help@httpd.apache.org


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org

Re: [users@httpd] CGI Internal Error

[Steve Campbell <st...@forerunners.org>]

Thanks to Mike and his help most of the day, I hve my cgi being called. I
aam running Apache on Mac OS X.2

I have cmod'ed my script and when I call it thru the browser, I get this
error:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable
to complete your request.

Please contact the server administrator, [no address given] and inform them
of the time the error occurred, and anything you might have done that may
have caused the error.




Anyone have any idea?  The top of my script reads the usual pathway info:

#!/usr/bin/perl

I know that Perl is installed on the server, since I run mysql, etc.

Any help would be appreciated.

Thanks
Steve



---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org