REPOST: Running MySQLdb under solaris and python 2.1

[hugh]

I'm trying to write a cgi script in python that accesses the mySQL
database. This is made more complicated by the way my ISP forces
everything run from a cgi to be under the user's home directory. I
have python installed, and I have mySQLdb installed. But when I try to
use it I get the following error:

>>> import MySQLdb
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/export/home/incent01/usr/local/lib/python2.1/MySQLdb/__init__.py",
line 27, in ?
    import _mysql
ImportError: ld.so.1: python: fatal: libmysqlclient.so.10: open
failed: No such file or directory
>>>

So it's finding the MySQLdb package; it's loading the _mysql.so
module; and then it's failing to link in the libmysqlclient. (right?)
I've found libmysqlclient but I can't get it into the right directory
so the system can link it in--usr/local/bin (where the python program
is), usr/local/lib and usr/local/lib/python2.1 all don't work.

Is there some magic place for it? Is there some environment variable I
can set so it can be found?

========= WAS CANCELLED BY =======:
Path: news.sol.net!spool1-nwblwi.newsops.execpc.com!newsfeeds.sol.net!newspump.sol.net!newsfeed.direct.ca!look.ca!newsfeed.dacom.co.kr!feeder.kornet.net!news1.kornet.net!ua4canc3ll3r
From: beyer at incent.com (hugh)
Newsgroups: comp.lang.python
Subject: cmsg cancel <3d504fd.0112281335.45ca330 at posting.google.com>
Control: cancel <3d504fd.0112281335.45ca330 at posting.google.com>
Date: Mon, 31 Dec 2001 04:23:28 GMT
Organization: A poorly-installed InterNetNews site
Lines: 2
Message-ID: <cancel.3d504fd.0112281335.45ca330 at posting.google.com>
NNTP-Posting-Host: 211.57.49.2
X-Trace: news2.kornet.net 1009775044 27193 211.57.49.2 (31 Dec 2001 05:04:04 GMT)
X-Complaints-To: usenet at news2.kornet.net
NNTP-Posting-Date: Mon, 31 Dec 2001 05:04:04 +0000 (UTC)
X-No-Archive: yes
X-Unac4ncel: yes
X-Commentary: I love NewsAgent 1.10 and the Sandblaster Cancel Engine Build 74 (19 March 1999)

This message was cancelled from within Mozilla.