[Zope] Zope + Zap + ZOracleDA

[Michel Pelletier]

Laurent Chane-Chuen-Kee wrote:
> 
> Hello all,
> 
> I am trying to connect Zope to an oracle database. All 3 packages compiled
> successfully. Zope+Medusa is able to initialize ZOracleDA. But when I try Zope
> with Zap, ZOracleDA is reported broken with the following traceback:
> 
> ----------------------
> 
> Traceback (innermost last):
> ImportError: libclntsh.so.8.0: cannot open shared object file: No such file or
> directory
> 
> ----------------------
> 
> Can somebody point out what I missed during the configuration?

<guess>

You must still use medusa (ZServer, in this case) even if you want to
use PCGI (which is what Zap uses).  ZServer listens to many protocols,
like HTTP, FTP, and PCGI.  If you don't use medusa, PCGI will try to
fire up Zope the OLD way, and it will probably work but it's not the
right way.  The problem is, now your process environment has the wrong
LD_LIBRARY_PATH (and a whole slew of other problems related to running
Zope the old way, like no concurrency) and cannot find your Oracle
dynamic libraries.

Run ZServer first.  Then Zap.  Then it should work.

-Michel