Installing MySQLdb and ZMySQLDA for Zope in Windows

1. Shutdown Zope if running.

2. Copy the directory and files

Download Module Zope_MySQLConnection

MySQLdb
_mysql.pyd
_mysql.exceptions.pyc
_mysql.exceptions.pyo

to the lib/python/ directory inside your Zope instance.

In a generic default install of Zope the location will be:
C:ZopeInstance2.10.4libpython

MySQLdb (MySQL for Python) 1.2.2 allows Python to access MySQL using
the Python DB API 2.0 syntax. This version of MySQLdb uses Python
2.4. (The version of Python installed by the Zope 2.10.4 installer
is 2.4.4.) Older/newer versions of Python (2.3, etc.) will not work
with these files, but a version of MySQLdb which does is available from
the sourceforge link below.

(Source: http://sourceforge.net/projects/mysql-python )

3. Copy the directory ZMySQLDA

to the Products/ directory inside your Zope instance.

In a generic default install of Zope the location will be:
C:ZopeInstance2.10.4Products

This is the database adaptor used inside Zope. (ZMySQLDA 2.0.9b3)

(Source: http://sourceforge.net/projects/mysql-python )


4. Restart Zope.

Upon starting Zope you will see a few depreciation warnings. These
are no cause for alarm, however ZMySQLDA will apparently need to be
updated to work with Zope versions 2.11 and above.

If the database adaptor is installed correctly, the item Z MySQL
Database Connection should be available in the “add” dropdown list
and ZMySQLDA should be listed in the collapsable Products menu
(under Control Panel) in the left frame.

You probably need to have installed MySQL and created at least 1
database to add the connection object. The connection string is

database user password

or if there is no user/password simply

database

Click on the connection object to “browse” the database items or enter
“test” SQL queries. If you can browse the database and successfully
enter SQL instructions, the connection between Zope and MySQL **MAY**
be complete. (See below.)

Share

Leave a Reply

Your email address will not be published. Required fields are marked *