[Zope] Oracle connection requirements

[Jens Vagelpohl]

thanks a bundle for your help. i feel kind of stupid now because the actual
error was due to some wrong permissions...... the account acting on behalf
of zope did not have execute/read permission of the database's parent
directory and as such was not able to access the "oracle" executable...

by the way, this is just a prelude. it's class project time again! ;) i did
receive an 'A' for my customer database system on Zope with MySQL last
semester thanks in large part to the help from this list.

as an aside, the project got a large local VAR/consulting firm here in ann
arbor/MI highly interested in Zope. i might end up getting a job there and
being the zope implementer because right now they don't have anyone who does
either zope or python...

jens

Jens Vagelpohl

Systems Administrator
Washtenaw Development Council


> -----Original Message-----
> From: Brian Lloyd [mailto:Brian@digicool.com]
> Sent: Monday, September 06, 1999 12:10
> To: 'jbauer@pobox.com'; Jens Vagelpohl
> Cc: Zope@Zope. Org
> Subject: RE: [Zope] Oracle connection requirements
>
>
> > Jens,
> >
> > The error is generated by pcgi-wrapper, not the ZOracleDA.  Does the
> > error occur only when you use ZOracleDA?  (In other words, does
> > everything work without the module present?)
> >
> > -Jeff Bauer
>
> Jens,
>
> I suspect I know what's going on here - I'd bet that the problem
> is that:
>
>   1. PCGI is failing because Zope is failing to start properly
>
>   2. Zope is probably failing to start properly because is it
>      trying to import the oracle interface module.
>
>   3. This is most likely happening because the C oracle libraries
>      _require_ that a variable such as ORACLE_HOME be set in the
>      environment of the process that tries to use them (you may
>      want to double check the exact name of the environment variable
>      required - I'm going on somewhat fuzzy memory here). When the
>      the Python oracle interface is imported, the oracle C libs do
>      not find the environment variable and cause an immediate exit.
>
> The solution:
>
>   In your PCGI info file (if the process is being started by PCGI) or
>   in the "start" script that runs ZServer (if you run ZServer manually),
>   you need to arrange for the oracle environment variable to be set.
> Note
>   that if your setup is such that PCGI starts your Zope process
> automatically,
>   you just need to add a line such as:
>
>     ORACLE_HOME=/foo/bar
>
>   to your PCGI info file. Otherwise you need to either set it in your
> own
>   environment when starting the process or (better) modify the start
> script
>   to set it when it is run.
>
>
> Hope this helps!
>
> Brian Lloyd        brian@digicool.com
> Software Engineer  540.371.6909
> Digital Creations  http://www.digicool.com
>
>