[Zope-CMF] ZMySQLDA __init__.py initialisation problem.

[Paul Erickson]

If you can load the module with python, it seems like it might either be
that the file is not found, or that the user that you are using to start
zope doesn't have permissions on the file.

Where is your _mysql.so file? 

Mine is in /usr/lib/python1.5/site-packages

The permissions on the file are:
-rwxr-xr-x    1 root     root

-Paul

Gregory Lambert wrote:
> 
> Hi!
> 
> I am really stuck on this one. I am trying connect my wonderful Zope/CMF
> server (running under Linux Redhat 6.1) to my MySQL database (tested and
> working) and I don't seem to be able to start the Zope server without the
> following error:
> 
> 2001-05-20T13:06:40 ERROR(200) Zope Couldn't import Products.ZMySQLDA
> Traceback (innermost last):
>   File
> /home/zope/Zope-2.3.1_dev/Zope-2.3.1-linux2-x86/lib/python/OFS/Application.p
> y, line 536, in import_products
>     (Object: string)
>   File /home/zope/Zope-d1/lib/python/Products/ZMySQLDA/__init__.py, line 92,
> in ?
>   File /home/zope/Zope-d1/lib/python/Products/ZMySQLDA/DA.py, line 92, in ?
>   File /home/zope/Zope-d1/lib/python/Products/ZMySQLDA/db.py, line 89, in ?
> ImportError: _mysql: init failed
> 
> I have successfully re-compiled the tar for the _mysql extension as
> referenced by the URL: http://www.zope.org/Members/mordred/ZMySQLDA/INSTALL.
> Also, I have successfully manually imported the _mysql module directly with
> the python command line interface - no apparent problems there. I have tried
> all of these procecures on my Win32 machine and was able to import the
> product and successfully connect to my MySQL database. I just need to get
> our "production" Linux machine working now....
> 
> Can anyone help?
> 
> Gregory Lambert
> Camwood Consulting UK
> 

> Lots of stuff chopped <

-- 
Paul Erickson       | erickson@kaivo.com
Kaivo, Inc.         | www.kaivo.com