> -----Original Message-----
> From: Aleksandr Vladimirskiy [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 1:33 PM
> To: [EMAIL PROTECTED]
> Subject: mod_perl and dbi:Oracle
>
>
> Hi,
>
> I am building a system using apache,mod_perl and oracle. it is in the
> very early stages. right now all i have is a module that prints out a
> simple text string to the browser. for the next step i am trying to
> access an oracle db, but get a message in the error log from
> the module
> that ORACLE_HOME environment variable isn't set. i have tried to set
> this variable in the module itself as well as in the apache
> configuration file (the <Location> that governs my program)
> but without
> success.
there are a few options...
from /etc/profile or the .profile of user nobody (or whoever you run apache
as):
ORACLE_HOME=/u01/app/oracle/product/8.0.5.1; export ORACLE_HOME
from /etc/profile or the .profile of user nobody (or whoever you run apache
as)
from your startup.pl:
BEGIN {
$ENV{'ORACLE_HOME'} = "/u01/app/oracle/product/8.0.5.1";
}
from httpd.conf:
PerlSetEnv ORACLE_HOME /u01/app/oracle/product/8.0.5.1
or any combination of the above :)
DBD::Oracle needs ORACLE_HOME at it's compile time, so setting it from
within your startup.pl and use()ing DBD::Oracle there is probably your best
bet. YMMV.
HTH
--Geoff
>
> Can anyone help?
>
> Alex Vladimirskiy
>
