<tt><font size=2>Dan Fairs <dan@fezconsulting.com> wrote on 08/17/2009
02:31:51 PM:<br><br>> Re: [Zope-DB] ZcxOracleDA configuration assistance</font></tt><br><tt><font size=2>> <br>> > > > At this point, we're fairly mystified. The file that
ZcxOracleDA's<br>> > > > install ultimately complains about is indeed in $ORACLE_HOME,
<br>> > where I<br>> > > > would expect it to be looking. We're still able to
manually start<br>> > > > Plone's Python and import cx_Oracle just fine. Does
anyone have <br>> > any<br>> > > > suggestions?<br>> > ><br>> > > Given that it works when you run Python manually but not
when you <br>> > start<br>> > > the cluster the problem is likely to be that your Zope user
<br>> > doesn't have<br>> > > the right permissions to access the library.<br>> ><br>> > Thanks for the response. Plone's documentation says that for
the <br>> > type of install we did, Zope should run as the user "plone"
(I <br>> > verified this with ps). Unfortunately, even if I chown everything
in <br>> > $ORACLE_HOME to user plone and restart the cluster again, the
error <br>> > remains the same.<br>> ><br>> <br>> <br>> Are the $ORACLE_HOME and $LD_LIBRARY_PATH variables exported for the
<br>> user that Zope is running as? You didn't say whether your test script
<br>> was run as that user or some other user (and hence for whom those
<br>> variables were exported).<br></font></tt><br><tt><font size=2>Ok, I think that was the prod I needed. I have the
variables exported from the profiles of both root and plone (under which
Zope should be running), but I apparently haven't set it in the right spot
yet. If I log in as plone, a manual import of cx_Oracle works fine. However,
if as root I "sudo -u plone /.../python" and try to import, I
get the same error returned by ZcxOracleDA. Haven't figured out how to
get around it yet, but it looks like this takes it out of the realm of
Zope and into basic system administration.</font></tt><br><br><tt><font size=2>Thanks,</font></tt><br><tt><font size=2>David Murphy</font></tt><BR>