Re: ZcxOracleDA configuration assistance
[email protected] Mon, 17 Aug 2009 16:01:37 -0400
| Newsgroups | gmane.comp.web.zope.database |
|---|---|
| Message-ID | <OF5E673DE2.C2D10437-ON85257615.006D71D2-85257615.006E33F7@LocalDomain> |
--===============4410813607600861003== Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable <tt><font size=3D2>Dan Fairs <[email protected]> wrote on 08/17/2= 009 02:31:51 PM:<br><br>> Re: [Zope-DB] ZcxOracleDA configuration assistance= </font></tt><br><tt><font size=3D2>> <br>> > > > At this poi= nt, we're fairly mystified. The file that ZcxOracleDA's<br>> > > > install ultimately complains about is = indeed in $ORACLE=5FHOME, <br>> > where I<br>> > > > would expect it to be lo= oking. We're still able to manually start<br>> > > > Plone's Python and import cx=5FOracle= just fine. Does anyone have <br>> > any<br>> > > > suggestions?<br>= > > ><br>> > > Given that it works when you run Python ma= nually but not when you <br>> > start<br>> > > the cluster the proble= m 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. Plo= ne'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 cho= wn everything in <br>> > $ORACLE=5FHOME to user plone and restart the cluster= again, the error <br>> > remains the same.<br>> ><br>> <br>> <= br>> Are the $ORACLE=5FHOME and $LD=5FLIBRARY=5FPATH variables exported = for the <br>> user that Zope is running as? You didn't say whether your te= st 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= =3D2>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=5FOracle works fine. Howev= er, 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 siz= e=3D2>Thanks,</font></tt><br><tt><font size=3D2>David Murphy</font></tt><BR> --===============4410813607600861003== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Zope-DB mailing list [email protected] http://mail.zope.org/mailman/listinfo/zope-db --===============4410813607600861003==--