[Zope] Re: ZMySQLDA broken with Redhat 9?

[hpinson at indepthl.com]

The reason MySQLDA would not run on my Redhat 9 was that I was 
missing a library called:

zlib-devel

Without it, MySQL-python would not build or install.  I made the 
mistake of trusting the Redhat MySQL-python rpm-- which was a bad 
choice.

I installed the appropriate zlib-devel RPM, as a guess based on an 
obscure thread somewhere, built and installed MySQL-python (without 
errors this time), then copied ZMySQLDA to 
/var/zope/lib/python/Products and restarted.  ZMySQLDA works!

I don't think this had anything to do with my PYTHONPATH as others 
had suggested.  The redhat MySQL-python RPM had installed _mysql.so 
but to the /usr/lib/python1.5/site-packages directory.  Adding this 
to the PYTHONPATH did not help.

One trick is to make sure to build MySQL-python using the Python that 
installs with the binary.  For example:

/var/zope/bin/python setup.py build
/var/zope/bin/python setup.py install

The RPM from redhat probably was built with some other version of 
Python.

If you build MySQL-python with some other version of Python, you may 
have trouble depending on how you are running Zope, i.e Python  
included with the binary release or external python.

It seems that this ZMySQLSA problem is occuring a lot lately and has 
many differnt causes.  My situtaion may or may not be unique, but 
perhaps this will help.

Is this going to get even more confusing with Zope 7?  My 
understanding is that we are getting power over simplicity.  This 
sort of thing should be simple, and not a struggle.










Harlow Pinson
Indepth Learning
Email: hpinson at indepthl.com 
Web: http://www.indepthl.com
Voice: 505-994-2135
FAX: 208-475-7678