> -----Original Message-----
> From: Daniel Hutchison [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 17, 2000 3:49 PM
> To: [EMAIL PROTECTED]
> Subject: PerlAuthenHandler and DBI:
>
>
> While the behaviour seems correct from the browser, I am
> getting errors in
> the error_log that may be indicative of some kind of problem:
> Here is the relevant snippet of my httpd.conf:
>
> <PRE>
> # Added for Oracle to work. Dan H. 5-oct-2000
> #####################################################
>
> SetEnv ORACLE_HOME /home/oracle/product/8.1.6
> SetEnv LD_LIBRARY_PATH /home/oracle/product/8.1.6/lib
>
[snip]
> Now, when I browse to the survey directory and enter my username and
> password this line appears in the errors_log:
>
> [datestamp] null: ORACLE_HOME environment variable not set!
SetEnv only takes affect at fixup, making ORACLE_HOME not set during
authentication.
use PerlSetEnv, which sets ORACLE_HOME sooner, in time for authentication.
for what it's worth, IIRC, it is best to make sure ORACLE_HOME is set when
DBD::Oracle is compiled, so if you have a startup.pl script that pre-loads
your modules, it might help to have
BEGIN {
$ENV{'ORACLE_HOME'} = "/home/oracle/product/8.1.6";
}
in there too...
HTH
--Geoff
>
> I've never had this error before, and most of my scripts do
> access oracle,
> always working fine.
> Only in this case has it ever appeared.
>
> Any help would be appreciated, or a pointer to some thorough
> documentation.
> thanks!
> Dan
>
>