[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>&gt; &gt;&nbsp; But I want to</FONT>
> <BR><FONT SIZE=3D2>&gt; &gt;&nbsp; access my Oracle database with Zope =
> SQL methods, so I </FONT>
> <BR><FONT SIZE=3D2>&gt; &gt;&nbsp; downloaded the Oracle</FONT>
> <BR><FONT SIZE=3D2>&gt; &gt;&nbsp; database adapter (Z Oracle =
> DA).&nbsp; The &quot;installation </FONT>
> <BR><FONT SIZE=3D2>&gt; &gt;&nbsp; instructions&quot; only tell</FONT>
> <BR><FONT SIZE=3D2>&gt; &gt;&nbsp; me how to build DCOracle; no sign of =
> how to install </FONT>
> <BR><FONT SIZE=3D2>&gt; &gt;&nbsp; ZOracleDA into Zope can</FONT>
> <BR><FONT SIZE=3D2>&gt; &gt;&nbsp; be found, and Zope has yet to read =
> my mind and detect </FONT>
> <BR><FONT SIZE=3D2>&gt; &gt;&nbsp; ZOracleDA's presence.</FONT>
> <BR><FONT SIZE=3D2>&gt; </FONT>
> <BR><FONT SIZE=3D2>&gt; The .tgz contans a README.txt file in the src =
> directory which details</FONT>
> <BR><FONT SIZE=3D2>&gt; 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.&nbsp; 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>&gt;&nbsp; Even in</FONT>
> <BR><FONT SIZE=3D2>&gt; its current state you should be able to visit =
> the Control </FONT>
> <BR><FONT SIZE=3D2>&gt; Panel/Products</FONT>
> <BR><FONT SIZE=3D2>&gt; 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.&nbsp; I'll move it and see what =
> shakes loose.&nbsp; 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>&gt;&nbsp; Check the README.txt for</FONT>
> <BR><FONT SIZE=3D2>&gt; 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>&gt; BTW, what platform are you running (Win/Sparc =
> Solaris)?</FONT>
> <BR><FONT SIZE=3D2>Solaris.</FONT>
> </P>
> 
> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <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.
-----------------------------------------------------------------------------