mysql and zope connection

Download File

I hope someone will find the following useful.

-- INSTALLATION

1.  Shutdown Zope if running. 


2.  Copy the directory and files

    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:\Zope\Instance\2.10.4\lib\python\

    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:\Zope\Instance\2.10.4\Products

    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.)

--  FINISHED