[Zope] Problems installing the MySQL drivers

[Florian Lindner]

Hello,
I try to install the Zope MySQL drivers, instructions from 
http://heanet.dl.sourceforge.net/sourceforge/mysql-python/
ZMySQLDA-2.0.8.tar.gz

I dowloaded the python driver and the Zope DA from 
http://sourceforge.net/projects/mysql-python

I did a:

bastet:~/MySQL-python-0.9.2 # python setup.py build
bastet:~/MySQL-python-0.9.2 # python setup.py install (as root)

I used my /usr/bin/python to compile it, the same I used to build Zope.
All seemed fine.

Then I extracted the Zope DA from the Zope directory /opt/Zope2.7 it extracted 
into ./lib/python/Products/ZMySQLDA/

When I try to startup Zope


bastet:/var/zope/bin # ./runzope
------
2003-10-15T16:07:17 INFO(0) ZServer HTTP server started at Wed Oct 15 16:07:17 
2003
        Hostname: localhost.localdomain
        Port: 8080
------
2003-10-15T16:07:17 INFO(0) ZServer FTP server started at Wed Oct 15 16:07:17 
2003
        Hostname: bastet
        Port: 8021
------
2003-10-15T16:07:17 INFO(0) Zope Set effective user to "zope"
------
2003-10-15T16:07:21 ERROR(200) Zope Could not import Products.ZMySQLDA
Traceback (most recent call last):
  File "/opt/Zope-2.7/lib/python/OFS/Application.py", line 534, in 
import_product
    product=__import__(pname, global_dict, global_dict, silly)
  File "/opt/Zope-2.7/lib/python/Products/ZMySQLDA/__init__.py", line 91, in ?
    import DA
  File "/opt/Zope-2.7/lib/python/Products/ZMySQLDA/DA.py", line 92, in ?
    from db import DB
  File "/opt/Zope-2.7/lib/python/Products/ZMySQLDA/db.py", line 89, in ?
    import _mysql
ImportError: libmysqlclient_r.so.12: cannot open shared object file: No such 
file or directory
Traceback (most recent call last):
  File "/opt/Zope-2.7/lib/python/Zope/Startup/run.py", line 27, in ?
    run()
  File "/opt/Zope-2.7/lib/python/Zope/Startup/run.py", line 24, in run
    start_zope(opts.configroot)
  File "/opt/Zope-2.7/lib/python/Zope/Startup/__init__.py", line 50, in 
start_zope
    starter.startZope()
  File "/opt/Zope-2.7/lib/python/Zope/Startup/__init__.py", line 218, in 
startZope
    Zope.startup()
  File "/opt/Zope-2.7/lib/python/Zope/__init__.py", line 46, in startup
    _startup()
  File "/opt/Zope-2.7/lib/python/Zope/App/startup.py", line 47, in startup
    OFS.Application.import_products()
  File "/opt/Zope-2.7/lib/python/OFS/Application.py", line 512, in 
import_products
    import_product(product_dir, product_name, raise_exc=debug_mode)
  File "/opt/Zope-2.7/lib/python/OFS/Application.py", line 534, in 
import_product
    product=__import__(pname, global_dict, global_dict, silly)
  File "/opt/Zope-2.7/lib/python/Products/ZMySQLDA/__init__.py", line 91, in ?
    import DA
  File "/opt/Zope-2.7/lib/python/Products/ZMySQLDA/DA.py", line 92, in ?
    from db import DB
  File "/opt/Zope-2.7/lib/python/Products/ZMySQLDA/db.py", line 89, in ?
    import _mysql
ImportError: libmysqlclient_r.so.12: cannot open shared object file: No such 
file or directory
bastet:/var/zope/bin #

What's wrong?

Thanks,
Florian