hi anthony (and everyone else), i have almost all oracle environment variables correct and visible to root as it starts zope, such as ORACLE_HOME, ORACLE_SID, the oracle bin directory is in the path, and the oracle lib directory is part of LD_LIBRARY_PATH. maybe there's more needed..? sqlplus, using the same logged-in account and the very same connection string works just fine. jens
-----Original Message----- From: anthony@nextTelecom.com [mailto:anthony@nextTelecom.com]On Behalf Of Anthony Baxter Sent: Friday, September 03, 1999 00:09 To: Jens Vagelpohl Cc: Zope@Zope. Org Subject: Re: [Zope] ZOracleDA woes
Have you made sure all the environment variables needed by Oracle are set before you run Zope?
Anthony
"Jens Vagelpohl" wrote hi everyone,
after getting a little help in compiling the darned thing and testing the shared libraries with the DCOracle python test script everything seemed to be OK. Oracle database connections show up as an option to add in the management screen and according to the control panel products page it's available and working as well.
when adding a connection (using the legendary scott/tiger account which is proven to work using the sqlplus tool) zope dies and restarts. if i append the ORACLE_SID to the connection string after an @ nothing happens (the browser keeps waiting for any reply).
as a last attempt i added ORACLE_SID to the global /etc/profile thinking the connection would not know which instance to connect to, but using the username/password connection string zope still restarts.
has anyone seen this behavior or maybe have an idea why it's happening?
i'm using zope 2.0.0 final.
jens