[Zope] adding Oracle adapter?
LD Landis
ldl@LDL.HealthPartners.COM
Tue, 13 Apr 1999 22:00:05 -0500 (CDT)
Hi,
Here's what I did... MDR is my Meta-Data Repository, running
Oracle 8.0.5 for Linux with Python 1.5.1. Change your user/passwd
and instance.world to match your installation. Sorry, haven't gotten
to Zope.1.10 yet...
-----------------------------------------------------------
echo "/-------------------------\\"
echo "| Making Zope 1.9 for MDR |"
echo "\\------------------------/"
echo
cd /usr/local/src
rm -rf Zope-1.9.0-src
tar xvfz gz/Zope-1.9.0-src.tar.gz
cd Zope-1.9.0-src
tar xvfz ../gz/ZOracleDA-2.0.0-nonbin.tar.gz
python wo_pcgi.py
-----------------------------------------------------------
To make DCOracle available to general Python programs...
-----------------------------------------------------------
echo "/-------------------------------\\"
echo "| Making DCOracle 1.1.0 for MDR |"
echo "\\-------------------------------/"
echo
cd /usr/local/src
rm -rf DCOracle-1.1.0-nonbin
tar xvfz gz/DCOracle-1.1.0-nonbin.tgz
cd DCOracle-1.1.0-nonbin/src
cp Setup-8.0.4 Setup-8.0.5
echo "- create Setup-8.0.5"
ed Setup-8.0.5 << EOF
/-lsocket/
s/-lsocket -lnsl -lgen -ldl -lelf -laio -lposix4 //
w
q
EOF
echo "- build extension"
cp Setup-8.0.5 Setup
cp Makefile.pre.in-1.5 Makefile.pre.in
make -f Makefile.pre.in boot PYTHON=python
make
make install
python DCOracle_test.py user/passwd@instance.world
make clobber
exit 0
-----------------------------------------------------------
Keith Rohrer wrote:
> > > But I want to
> > > access my Oracle database with Zope SQL methods, so I
> > > downloaded the Oracle
> > > database adapter (Z Oracle DA). The "installation
> > > instructions" only tell
> > > me how to build DCOracle; no sign of how to install
> > > ZOracleDA into Zope can
> > > be found, and Zope has yet to read my mind and detect
> > > ZOracleDA's presence.
> >
> > The .tgz contans a README.txt file in the src directory which details
> > the all-too-painful process of compiling the Oracle modules.
>
> Which, for me, started with getting my own Python.h so I could compile.
> This entailed getting my own Python, so I concluded I was supposed to untar
> ZOracleDA into my Python directory, not Zope's private Python directory...
>
>
> > Even in
> > its current state you should be able to visit the Control
> > Panel/Products
> > folder and see a broken ZOracleDA product.
> Not if you think it goes in your Python directory, as opposed to Zope's
> Python directory. I'll move it and see what shakes loose. You might want
> to amend the installations to say to start by untarring in the Zope
> directory, not the Python directory...
>
> > Check the README.txt for
> > step-by-step compilation instructions.
> DCOracle works, though I had to get my own
>
> > BTW, what platform are you running (Win/Sparc Solaris)?
> Solaris.
>
> Keith
>
> ------_=_NextPart_001_01BE85F7.38132E80
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
> charset=3Diso-8859-1">
> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
> 5.5.2448.0">
> <TITLE>RE: [Zope] adding Oracle adapter?</TITLE>
> </HEAD>
> <BODY>
>
> <P><FONT SIZE=3D2>> > But I want to</FONT>
> <BR><FONT SIZE=3D2>> > access my Oracle database with Zope =
> SQL methods, so I </FONT>
> <BR><FONT SIZE=3D2>> > downloaded the Oracle</FONT>
> <BR><FONT SIZE=3D2>> > database adapter (Z Oracle =
> DA). The "installation </FONT>
> <BR><FONT SIZE=3D2>> > instructions" only tell</FONT>
> <BR><FONT SIZE=3D2>> > me how to build DCOracle; no sign of =
> how to install </FONT>
> <BR><FONT SIZE=3D2>> > ZOracleDA into Zope can</FONT>
> <BR><FONT SIZE=3D2>> > be found, and Zope has yet to read =
> my mind and detect </FONT>
> <BR><FONT SIZE=3D2>> > ZOracleDA's presence.</FONT>
> <BR><FONT SIZE=3D2>> </FONT>
> <BR><FONT SIZE=3D2>> The .tgz contans a README.txt file in the src =
> directory which details</FONT>
> <BR><FONT SIZE=3D2>> the all-too-painful process of compiling the =
> Oracle modules.</FONT>
> </P>
>
> <P><FONT SIZE=3D2>Which, for me, started with getting my own Python.h =
> so I could compile. This entailed getting my own Python, so I =
> concluded I was supposed to untar ZOracleDA into my Python directory, =
> not Zope's private Python directory...</FONT></P>
> <BR>
>
> <P><FONT SIZE=3D2>> Even in</FONT>
> <BR><FONT SIZE=3D2>> its current state you should be able to visit =
> the Control </FONT>
> <BR><FONT SIZE=3D2>> Panel/Products</FONT>
> <BR><FONT SIZE=3D2>> folder and see a broken ZOracleDA =
> product.</FONT>
> <BR><FONT SIZE=3D2>Not if you think it goes in your Python directory, =
> as opposed to Zope's Python directory. I'll move it and see what =
> shakes loose. You might want to amend the installations to say to =
> start by untarring in the Zope directory, not the Python =
> directory...</FONT></P>
>
> <P><FONT SIZE=3D2>> Check the README.txt for</FONT>
> <BR><FONT SIZE=3D2>> step-by-step compilation instructions.</FONT>
> <BR><FONT SIZE=3D2>DCOracle works, though I had to get my own</FONT>
> </P>
>
> <P><FONT SIZE=3D2>> BTW, what platform are you running (Win/Sparc =
> Solaris)?</FONT>
> <BR><FONT SIZE=3D2>Solaris.</FONT>
> </P>
>
> <P> <FONT =
> SIZE=3D2>Keith</FONT>
> </P>
>
> </BODY>
> </HTML>
> ------_=_NextPart_001_01BE85F7.38132E80--
>
> _______________________________________________
> Zope maillist - Zope@zope.org
> http://www.zope.org/mailman/listinfo/zope
>
> (For developer-specific issues, use the companion list,
> zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )
>
--
--
Cheers,
--ldl
-----------------------------------------------------------------------------
LD Landis ldl@HealthPartners.Com N0YRQ Voice 612/883-5511 Fax 612/883-6363
HealthPartners, 8100 34th Avenue So, PO Box 1309, Minneapolis, MN 55440-1309
Shape your life not from your memories, but from your hopes. (Borrowed)
Still programming for the day-job... haven't yet gotten that Microsoft PR job
-----------------------------------------------------------------------------
"PowerPoint -- the production platform of choice of the 'Big 6'." -me
"The harder truth is that just because a company is spending a large amount
on IT doesn't necessarily mean it's spending that money well."
-- InformationWeek, Dec 8 1997, Pg 66 in "Old Countries, New Technologies"
"But it sure is easier just to sit back and bitch than to actually try to
make yourself heard." -- Jim Edwards-Hewitt meanwhile...
"I'm not one of those who think Bill Gates is the devil. I simply suspect
that if Microsoft ever met up with the devil, it wouldn't need an
interpreter." -- Nicholas Petreley, InfoWorld editor.
Remember: The enthusiasm for having chosen "NT" is at its maximum at t=-1.
-----------------------------------------------------------------------------