[Zope] Zope and MySQL (ZMySQLDA errors)

[Robbie Honerkamp]

I apologize in advance if this is too basic of a question to ask- I've
read through countless websites and list archives today, and I'm still
coming up short.

I'm in the process of moving a Zope 2.6.0 instance to a Zope 2.11.4
install. The app is a front end app to a MySQL database that's been
running happily along for the last seven years.

The problem I'm currently running into on the new server is configuring
the database server connection. I've installed ZMySQLDA (though where
the correct location should be is up in the air- it wants to unzip to
lib/python/Products, where some people seem to think it should be, but
other docs I find say it should be under Products in the instance
directory. I've tried it in both locations, though.

I'm running ZMySQLDA version 2.0.8. I've installed MySQL-python version
1.2.3c1.

When I start the instance, I get the following error. I've searched on
the "No module named ImageFile", but I haven't found anything that seems
to apply. I'll greatly appreciate any help here, as this is part of a
larger project that's running behind, and I've already spend my day
playing with this. :/

Robbie


2009-08-08 15:20:43 INFO ZServer HTTP server started at Sat Aug  8
15:20:43 2009

      Hostname: 0.0.0.0

      Port: 8090

2009-08-08 15:20:43 INFO Zope Set effective user to "zope"

2009-08-08 15:20:43 ERROR Application Could not import Products.ZMySQLDA

Traceback (most recent call last):

  File "/opt/Zope-2.11.4/lib/python/OFS/Application.py", line 709, in
import_product

    product=__import__(pname, global_dict, global_dict, silly)

  File "/srv/zope/testinstance/Products/ZMySQLDA/__init__.py", line 91, in ?

    import DA

  File "/srv/zope/testinstance/Products/ZMySQLDA/DA.py", line 93, in ?

    import Shared.DC.ZRDB.Connection, sys, DABase

  File "/srv/zope/testinstance/Products/ZMySQLDA/DABase.py", line 92, in ?

    from ImageFile import ImageFile

ImportError: No module named ImageFile

Traceback (most recent call last):

  File "/opt/Zope-2.11.4/lib/python/Zope2/Startup/run.py", line 56, in ?

    run()

  File "/opt/Zope-2.11.4/lib/python/Zope2/Startup/run.py", line 21, in run

    starter.prepare()

  File "/opt/Zope-2.11.4/lib/python/Zope2/Startup/__init__.py", line
109, in prepare

    self.startZope()

  File "/opt/Zope-2.11.4/lib/python/Zope2/Startup/__init__.py", line
300, in startZope

    Zope2.startup()

  File "/opt/Zope-2.11.4/lib/python/Zope2/__init__.py", line 47, in startup

    _startup()

  File "/opt/Zope-2.11.4/lib/python/Zope2/App/startup.py", line 51, in
startup

    OFS.Application.import_products()

  File "/opt/Zope-2.11.4/lib/python/OFS/Application.py", line 686, in
import_products

    import_product(product_dir, product_name, raise_exc=debug_mode)

  File "/opt/Zope-2.11.4/lib/python/OFS/Application.py", line 709, in
import_product

    product=__import__(pname, global_dict, global_dict, silly)

  File "/srv/zope/testinstance/Products/ZMySQLDA/__init__.py", line 91, in ?

    import DA

  File "/srv/zope/testinstance/Products/ZMySQLDA/DA.py", line 93, in ?

    import Shared.DC.ZRDB.Connection, sys, DABase

  File "/srv/zope/testinstance/Products/ZMySQLDA/DABase.py", line 92, in ?

    from ImageFile import ImageFile

ImportError: No module named ImageFile