[Zope-DB] ZcxOracleDA configuration assistance

[Dan Fairs]

> > > At this point, we're fairly mystified. The file that ZcxOracleDA's
> > > install ultimately complains about is indeed in $ORACLE_HOME,  
> where I
> > > would expect it to be looking. We're still able to manually start
> > > Plone's Python and import cx_Oracle just fine. Does anyone have  
> any
> > > suggestions?
> >
> > Given that it works when you run Python manually but not when you  
> start
> > the cluster the problem is likely to be that your Zope user  
> doesn't have
> > the right permissions to access the library.
>
> Thanks for the response. Plone's documentation says that for the  
> type of install we did, Zope should run as the user "plone" (I  
> verified this with ps). Unfortunately, even if I chown everything in  
> $ORACLE_HOME to user plone and restart the cluster again, the error  
> remains the same.
>


Are the $ORACLE_HOME and $LD_LIBRARY_PATH variables exported for the  
user that Zope is running as? You didn't say whether your test script  
was run as that user or some other user (and hence for whom those  
variables were exported).

Cheers,
Dan

--
Dan Fairs <dan at fezconsulting.com> | http://www.fezconsulting.com/