[Zope] ZMySQLDA weirdness

[Tony McDonald]

At 7:43 am +0000 1/2/00, Tony McDonald wrote:
>Can anyone tell me why I'm getting this traceback in a ZMySQLDA product on a
>new Zope site I've put up?
>
>ZMySQLDA Import Traceback
>
>
>
>Traceback (innermost last):
>   File "/home/nnle/MEDFAC_SERVER/lib/python/OFS/Application.py", line 387, in
>import_products
>     product=__import__(pname, global_dict, global_dict, silly)
>   File "/home/nnle/Zope-2.1.0b1-src/lib/python/Products/ZMySQLDA/__init__.py",
>line 106, in ?
>   File "/home/nnle/Zope-2.1.0b1-src/lib/python/Products/ZMySQLDA/DA.py", line
>108, in ?
>   File "/home/nnle/Zope-2.1.0b1-src/lib/python/Products/ZMySQLDA/db.py", line
>106, in ?
>ImportError: ld.so.1: python: fatal: libmysqlclient.so.6: open failed: No such
>file or directory
>
>The thing is, I have a MySQL library in /usr/local/python/lib/ and ...
>...the path /home/nnle/Zope-2.1.0b1-src doesn't exist! :{
>
>Tone

Busy today aren't I?

I found that I had to
1) delete the product from the Control Panel/Products folder
2) compact the database
3) restart Zope
....
but that still didn't get rid of it

Fortunately, we were installing a tape drive into our Sun box today 
so we had to reboot the system. Strangely, the same error came up, 
but this time the directory did exist. Why I needed to reboot our box 
to get rid of that error message, I dunno, but it seemed to do the 
trick.

But, I digress...
The error above came from connections made to a Zope server using the 
pcgi wrapper, and it was driving me mad.

The solution however, was to start up a ZServer (./start) of the same 
Zope installation, then I found that database operations worked on 
the pcgi 'server' too! (this is weird).

hope this helps someone else out.
Tone
------
Dr Tony McDonald,  FMCC, Networked Learning Environments Project 
http://nle.ncl.ac.uk/
The Medical School, Newcastle University Tel: +44 191 222 5888
Fingerprint: 3450 876D FA41 B926 D3DD  F8C3 F2D0 C3B9 8B38 18A2