[Zope] MySQL problem with Zope 2.01 on Linux RH 6.0

[Andreas Björck]

Hello,

I've followed the instructions as described in http://www.zope.org/Members/alanpog/zmysqlda_steps
but I can't get the MySQLdb-0.1.0 to install.  

The system is a Linux RH 6.0 Kernel 2.2.5-15 and I have installed MySQL 3.22.27 from source, Python 1.5.2 from source, Zope 2.01 from source.

The error I get when trying the "python build.py" as described in the MySQLdb-0.1.0 README.txt file, is
something like this:

[snippet...]
make -f Makefile do-it-again
make[2]: Entering directory `/usr/local/Zope-2.0.1-linux2-x86/lib/python/Products/MySQLdb-0.1.0'
/usr/lib/python1.5/config/makesetup \
         -m Makefile.pre -c /usr/lib/python1.5/config/config.c.in Setup -n  /usr/lib/python1.5/config/Setup
make[2]: Leaving directory `/usr/local/Zope-2.0.1-linux2-x86/lib/python/Products/MySQLdb-0.1.0'
make[1]: Leaving directory `/usr/local/Zope-2.0.1-linux2-x86/lib/python/Products/MySQLdb-0.1.0'
gcc -fPIC -g -O2 -I/usr/include/python1.5 -I/usr/include/python1.5 -DHAVE_CONFIG_H  -I/usr/include/mysql -c ./_mysqlmodule.c
./_mysqlmodule.c: In function `_mysql_ConnectionObject_affected_rows':
./_mysqlmodule.c:478: warning: return makes pointer from integer without a cast
./_mysqlmodule.c: In function `_mysql_ConnectionObject_insert_id':
./_mysqlmodule.c:817: warning: return makes pointer from integer without a cast
./_mysqlmodule.c: In function `_mysql_ResultObject_num_rows':
./_mysqlmodule.c:924: warning: return makes pointer from integer without a cast
./_mysqlmodule.c: In function `init_mysql':
./_mysqlmodule.c:1366: warning: assignment makes pointer from integer without a cast
gcc -shared  _mysqlmodule.o  -L/usr/lib/mysql -lmysqlclient -o _mysqlmodule.so
Traceback (innermost last):
  File "build.py", line 14, in ?
    import MySQLdb
  File "MySQLdb.py", line 19, in ?
    from _mysql import *
ImportError: libmysqlclient.so.6: cannot open shared object file: No such file or directory
[...snippet]

The libmysqlclient.so.6 exists in /usr/lib/mysql/, so I guess that can't be the error.

After that I figured I'd attempt installing the ZMySQLDA-1.1.3, but I understand I need to install the MySQLdb module first.  MySQL is a pretty popular database, so I hope someone has run into this as well, and hopefully solved the problem.

Regards,
    Andreas