Re: [cx-oracle-users] 4.1.2 install: Ubuntu Linux, Oracle 10.1.0.3 instant client problems

[Marcus E. <i...@eg...>]

cpoetzel wrote:
> Anthony,
> Thanks for the response.
> I was able to get a connection and response when using a script as 
> myself with cx_Oracle.
> 
> However, when I try to run the same script from the web server, I get 
> the same error.
> [Tue Feb 07 14:42:56 2006] [error] [client 146.137.1.33] ORA-12154: 
> TNS:could not resolve the connect identifier specified
> 
> I passed the web server the same env variables I have
> 
> Variable    Value
> LD_LIBRARY_PATH    /usr/lib/oracle/10.1.0.3/client/lib
> TNS_ADMIN    /usr/lib/oracle/10.1.0.3/client
> PATH    /usr/local/bin:/usr/bin:/bin
> PWD    /etc/apache2
> LANG    C
> SHLVL    1
> ORACLE_HOME    /usr/lib/oracle/10.1.0.3/client
> _    /usr/sbin/apache2
> 
> 
> Is there a way have a python program print out what tnsadmin.ora is 
> looking for when called from the web server?
> There are only a handfull of python scripts that use cx_Oracle through 
> the web and if I have to statically set the env for TNS_ADMIN
> I can live with that. I just don’t know how.
> 
> Thanks,
> Chris Poetzel
> 

How are you executing that script? If you are using suEXEC you should be 
aware, that suEXEC itself passes only environment variables listed in 
the safe environment list (declared at compiletime of suexec). And this 
list ist _very_ short.

It's just a shot in the dark, but maybe it helps.

Kind Regards,
Marcus