[Zope] ZMySQLDA

[Joseph F. Dries III]

> [Joseph F. Dries III]
> > I have recently installed Zope 2.7.0 b2, and installed the
> > mysql-python 0.9.2 along with ZMySQLDA 2.09b2. I had to
> > manually copy the registry entries for my Python.org
> > Python 2.3 installation to the 2.2 Python that
> > is part of the Zope 2.7.0 b2 binary install.
>
> Then the mysqp-python binary is probably built for Python 2.3 and would
> not likely work with Python 2.2.

No, it is not. I have the mysql-python 0.9.2 binary for Python 2.1, 2.2
and 2.3. I originally had the mysql-python binary installed for Python
2.1, since that is the python that ships with 2.6.2 and Plone 1.0.5.
mysql-python and ZMySQLDA worked fine with the Plone 1.0.5 and Zope 2.6.2
installations. I removed both of those completely, installed Zope 2.7.0
b2, added the correct registry entries for Python 2.2.3 under Zope 2.7.0
b2 so the installer could find the paths, and installed mysql-python 0.9.2
for Python 2.2.

The mysql-python 0.9.2 is also installed in my stand-alone Python 2.3.

I have the mysql-python 0.9.3b1 source tarfile, but like I said I have no
means to compile it on the Windows 2000 box. There is a line in the readme
in 0.9.3b1 that states that it is the suggested version to use for python
2.2 and above.

I obviously cannot be the only person running Zope 2.7.0 on Windows
connecting to MySQL ... What are the others out there doing? If I need to,
I suppose I can download the appropriate development tools to make Zope
2.7.0 and MySQL behave. But this certainly a high barrier to entry. Right
now I need a quick solution so I can continue my site development and
deployment.

> > It looks like that lives in the _mysql.pyd file, which is installed
> > correctly. I can fire up the python interpreter and do an
> > "import _mysql"
> > and it gives me no errors. I can do an "import MySQLdb", create a
> > db.connect, and manually execute some SQL.
>
> Which interpreter?  Zope's Py2.2 or your Py2.3?

Zope's Py2.2. I obviously wouldn't test my Py2.3 interpreter for a working
mysql-python (it is installed, and is working there also)... but the above
test also works in Zope's Py2.2 installation. Which is why I'm confused.

I saw a message posted on Yahoo's groups to find the
self.db.server_capabilities line and remove that and replace it with 0,
but I don't like working around something, I like getting it working.
Especially when it deals with data integrity.

> Cheers,
>
> Tom P

Thanks for the quick response.

-- 
Joseph F. Dries III