[Zope-DB] Zope 2.7.0 and MySQL: What Am I Missing?
Roy S. Rapoport
zope-db at ols.inorganic.org
Tue Jun 8 20:28:53 EDT 2004
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
> >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
More information about the Zope-DB