If you have enviroment variables problem?. try to run ".profile" at the
begining of your script (if you are using UNIX) or try to insert them at the
beginin of your script.
example in Perl:
$ENV{"ORACLE_HOME"} = "/ora/ora01/app/oracle/product";
$ENV{"ORA_NLS33"} =
"/ora/ora01/app/oracle/product/ocommon/nls/admin/data";
$ENV{"LD_LIBRARY_PATH"} = "/ora/ora01/app/oracle/product/lib";
$ENV{"ORAENV_ASK"} = "NO";
$ENV{"ORACLE_BASE"} = "/ora/ora01/app/oracle";
$ENV{"ORACLE_SID"} = "dbnet2";
$ENV{"TWO_TASK"} = "dbnet2";
$ENV{"ORACLE_OWNER"} = "oracle";
-----Original Message-----
From: Michael A Chase [mailto:mchase@;ix.netcom.com]
Sent: Wednesday, November 06, 2002 1:12 AM
To: dbi-users; Armand Brisson
Subject: Re: Script Running well as Root user but not as Apache user ?
On Wed, 06 Nov 2002 14:19:18 +0800 Armand Brisson
<[EMAIL PROTECTED]> wrote:
> I already have set httpd.conf with the environment variable.
>
> Problem occurs even if i just run the script as apache or other users
> work only in root or oracle users
>
> Michael A Chase wrote:
>
>> http://xmlproj.com/fom-serve/cache/20.html
>> http://xmlproj.com/fom-serve/cache/5.html
>> http://xmlproj.com/fom-serve/cache/96.html
>>
>> Setting LD_LIBRARY_PATH after perl has started probably has no effect.
>> It needs to be set in the webserver's environment.
Then check the file permissions in $ORACLE_HOME/lib and those of the DBI
and DBD::Oracle files.
The URIs above point to a lot of things that should be checked, not just
environment variables, though those are the most common problem.
A comparison of the environment variables set for root, oracle, and a user
that fails might be useful as well.
Please keep this on list, I am not the sole source of all wisdom.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
..
