[Zope] wtf, Getting MySQL working for Zope is a tramatic experience, I think I need therapy
Jacob Singh
jacob@prisonbooks.org
Sun, 11 Nov 2001 10:39:41 -0500
This is a multi-part message in MIME format.
------=_NextPart_000_0001_01C16A9D.32352D00
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
So here is what I have tried:
I installed the Python-MySQLDB mod, but was using an old version of
python, then I upgraded python and re-installed it. then I banged my
head against the wall trying to figure out how to use my python
executable and not Zope's. Finnally figured that out (basically
undocumented) So then ZMySQLdb showed up as functional but gave the
following message and restarted the server whenever I tried to use it:
WARNING: Python C API version mismatch for module _mysql:
This Python has API version 1010, module _mysql has version 1007.
I have no idea what this means, so I tried making a symlink between a
directory in my lib/python and lib/python2.1 directories to the
directory containing the Python-MySQLdb .so file and using the Zope
provided interpreter (to no avail). It can't find the module. I think
one of my problems may also lie in that I don't know how to uninstall
the old python, I didn't really upgrade, I just installed the new one
and overwrote the python executable, with the new one, I know this
probably wasn't too smooth, but this is a learning process. NEway, any
help would be GREATLY appreciated. And if any Zope Dev's are reading
this. PLEASE make MySQL and PostGRES connectivity standard with any Zope
installation.
Thank you
Jacob Singh
------=_NextPart_000_0001_01C16A9D.32352D00
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C16A9D.2BAD6C40">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
span.EmailStyle17
{mso-style-type:personal-compose;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:windowtext;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */=20
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple =
style=3D'tab-interval:.5in'>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>So here is what I have =
tried:<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I installed the Python-<span =
class=3DSpellE>MySQLDB</span>
mod, but was using an old version of python, <span =
class=3DGramE>then</span> I
upgraded python and re-installed it.<span =
style=3D'mso-spacerun:yes'>
</span><span class=3DGramE>then</span> I banged my head against the wall =
trying
to figure out how to use my python executable and not <span =
class=3DSpellE>Zope’s</span>.<span
style=3D'mso-spacerun:yes'> </span><span =
class=3DSpellE>Finnally</span>
figured that out (basically undocumented) So then <span =
class=3DSpellE>ZMySQLdb</span>
showed up as functional but gave the following message and restarted the =
server
whenever I tried to use it: <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>WARNING: Python C API version mismatch for module =
_<span
class=3DSpellE>mysql</span>:<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><span style=3D'mso-spacerun:yes'> </span>This =
Python has
API version 1010, module _<span class=3DSpellE>mysql</span> has version =
1007.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I have no idea what this means, so I tried making a =
<span
class=3DSpellE>symlink</span> between a directory in my lib/python and
lib/python2.1 directories to the directory containing the Python-<span
class=3DSpellE>MySQLdb</span> .so file and using the <span =
class=3DSpellE>Zope</span>
provided interpreter (to no avail).<span =
style=3D'mso-spacerun:yes'>
</span>It can’t find the module.<span =
style=3D'mso-spacerun:yes'>
</span>I think one of my problems may also lie in that I don’t =
know how
to uninstall the old python, I didn’t really upgrade, I just =
installed
the new one and overwrote the python executable, with the new one, I =
know this
probably wasn’t too smooth, but this is a learning process.<span
style=3D'mso-spacerun:yes'> </span><span =
class=3DSpellE>NEway</span>, any
help would be GREATLY appreciated.<span =
style=3D'mso-spacerun:yes'> </span><span
class=3DGramE>And if any <span class=3DSpellE>Zope</span> <span =
class=3DSpellE>Dev’s</span>
are reading this…</span> PLEASE make <span =
class=3DSpellE>MySQL</span> and <span
class=3DSpellE>PostGRES</span> connectivity standard with any <span =
class=3DSpellE>Zope</span>
installation.<span style=3D'mso-spacerun:yes'> =
</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Thank you<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Jacob Singh <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
------=_NextPart_000_0001_01C16A9D.32352D00--