[Zope-DB] Zope 2.7.0 and MySQL: What Am I Missing?

[Roy S. Rapoport]

On Tue, Jun 08, 2004 at 04:58:22PM -0700, Kent Hoxsey wrote:
> > My symptoms are that when I include this product,
> > Zope runs for a moment, but as soon as I try a
> > request, any request, it terminates the connection
> > and then does not respond to connection attempts.
> 
> Please clarify: this problem happens the first time you start up Zope
> after installling the ZMySQLDA product, or it happens the first time you
> start up Zope after creating a DA object in Zope.

Good question.  I had a DA already in there, so I didn't really get that
far.  I've removed the two connectors I had and started it again -- and
Zope stopped working immediately.  In other words, I don't get to do any
product management or interact with Zope in any way once I include this
product.

> >From your description, it sounds like the first. If so, I would suggest
> >you make sure everything was built properly, against the right
> >libraries, using the same compiler, etc. Silly I know, but I've been
> >bitten a couple times by setups where
> 
>     sudo python setup.py install
> 
> runs a different python than
> 
>    python setup.py build

Very good call.  I've (now) done this.  While I'm at it, I re-inspected
MySQL-Python's README and noticed 1.1.1 requires Python 2.3.4, which I
don't have (I've got 2.3.3); so I've downgraded it to 1.0.0 (which is also
stable, which is a good thing).

So then I thought to myself "maybe I should look at that fix that someone
suggested, which uses _mysql.connection, rather than _mysql.connect."  And
then I said to myself "self, maybe you should actually try to use the
_mysql module in Python and see what happens."

So I tried that.  And I got 
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
ImportError: ld.so.1: python: fatal: libmysqlclient.so.14: open failed: No such file or directory

Which hey, makes sense because my MySQL libraries were in a non-standard
location.  So, having fixed that (thanks to the magic of crle), I could now
do 'import _mysql' with impunity.

Which, unfortunately, does not fix my problem.

Are there any success stories with 2.7.0, MySQL-python, and ZMySQLDA? Just
knowing what versions people used will at least let me know that I'm on the
right path.

-roy