[Zope] cannot import library driving me mad!

[Greg Conway]

Hi all,

I've got a strange problem trying to start MySQL-python-0.9.0.

I get the following error:

2002-01-23T07:19:02 ERROR(200) Zope Could not import Products.ZMySQLDA
Traceback (innermost last):
  File
/home/packages/ZOPE/Zope-2.4.3-linux2-x86/lib/python/OFS/Application.py,
line 563, in import_product
  File
/home/packages/ZOPE/Zope-2.4.3-linux2-x86/lib/python/Products/ZMySQLDA/__ini
t__.py, line 91, in ?
  File
/home/packages/ZOPE/Zope-2.4.3-linux2-x86/lib/python/Products/ZMySQLDA/DA.py
, line 92, in ?
  File
/home/packages/ZOPE/Zope-2.4.3-linux2-x86/lib/python/Products/ZMySQLDA/db.py
, line 89, in ?
ImportError: libmysqlclient.so.10: cannot open shared object file: No such
file or directory

Zope starts and functions okay, but is not much use with it's MySQL
connection!

My MySQL files seem to be in some strange places. To get MySQL-python-0.9.0
to install in the first place I had to copy all my library files from where
MySQL is installed (/home/packages/MySQL-3.23.33/include got copied to
/usr/include/mysql, etc), and eventually it compiled and installed without
errors.

I first tried changing the paths in setup.py, but it gave me "cannot find
mysql.h" errors whatever paths I put, so I ended up moving all the files to
/usr/include/mysql and /usr/lib/mysql, which worked.

But now I have the libmysqlclient.so.10 problems!

The weird thing is that this files is in /usr/lib/mysql (and a few other
places!) but it does not find it.

Where is this call coming from?

I have scanned the above files (Application.py, db.py, etc) but can find no
references.

What I am trying to do is move my new Db (I've just started in Zope) from my
Linux box at home to an Internet Server, a RaQ 3 running Red Hat Linux 6.2.

I've got it working fine on my Linux box at home (7.1), but I didn't have to
change anything there.

So, it's not something stupid like using the wrong version of python as I
have already configured it on one box!

Anyway, any help much appreciated. I've got my Db waiting to go up on the
web and everything, got Zope up and running, but no SQL link.... might as
well have stayed with Access, I already Databases on my laptop with that :(

Thanks,

Greg Conway.

--
==================================
Greg Conway
Technical Director
GML Networking Technologies

Email/MSN: greg@gmlnt.com
ICQ#: 100219981
mobile tel.: +44 (0) 7974 666 967
mobile fax: +44 (0) 7970 087 935
Internet: http://www.gmlnt.com
office tel.: +44 (0) 1255 672 103
office fax: +44 (0) 1255 679 909
==================================


***********************************************************************
This is a confidential communication between sender and addressee. If you are not the intended recipient of this message, please notify the sender and do not read, copy, use or disclose this communication to others. Any opinions or views expressed are those of the individual, and unless otherwise stated, are not those of the company. All attachments and intellectual rights remain the property of GML (NT) Limited.
***********************************************************************