[Zope] [Fwd: Questions on your ZmySQLDA Tutorial]

[Don Undeen]

This is a multi-part message in MIME format.
--------------3ED51BD99F4FD3E79388B0D0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

This is an email I sent to Alan Pogrebinschi, but everyone on this list
has been so helpful, I thought I'd throw this out to the list. Thanks in
advance.

--------------3ED51BD99F4FD3E79388B0D0
Content-Type: message/rfc822
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

X-Mozilla-Status2: 00000000
Message-ID: <387CB8F0.752BCBD4@gator.net>
Date: Wed, 12 Jan 2000 12:25:04 -0500
From: Don Undeen <dundee@gator.net>
X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.12-20 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: alan@empresa.com
Subject: Questions on your ZmySQLDA Tutorial
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello Mr. Pogrebinschi,
    Let me start by thanking you for teh helpful tutorial on getting
ZMySQLDA up and running with Zope. I'm having some troubles, though, and
was hoping you could provide some insite.
Background:
1. Fresh install of Redhat 6.1
2. Installed Python from source, and copied over the  python that Redhat
automatically installed.
3. Installed MySQL, which I unpacked in directory /usr/local/APPS
4. Installed Zope. expanded in directory /usr/local/APPS/
5. expanded ZMySQLDA in top level Zope Directory. It expanded into
[Zope-dir]/lib/python/Products, just as you said.
6. Unpacked MySQLdb in the Products Directory
7. Edited the Setup.in file, changing the line
_mysql _mysqlmodule.c -L/usr/lib/mysql -I/usr/include/mysql
-lmysqlclient
to:
_mysql _mysqlmodule.c -L/usr/local/lib/mysql -I/usr/local/include/mysql
-lmysqlclient

which is where those directories are.

The Problem:
When I run "python build.py" i get the following error

gcc -fpic  -I/usr/local/include/mysql -g -O2 -I/usr/include/python1.5
-I/usr/include/python1.5 -DHAVE_CONFIG_H -c ./_mysqlmodule.c
gcc -shared  _mysqlmodule.o  -L/usr/local/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

that file,  libmysqlclient.so.6, is in /usr/local/lib/mysql
it's also in /usr/local/APPS/mysql-3.22.29/client/.libs/

are there other paths that I can edit so that this file is found?
Or perhaps you have some other insite as to the nature of this problem?
any help you could give would be greatly appreciated.

Thanks again for your work.
Don Undeen
dundee@gator.net


--------------3ED51BD99F4FD3E79388B0D0--