Mailing List Archive: ImportError: libmysqlclient

ImportError: libmysqlclient_r.so.15

Nov 7, 2007, 12:31 PM

Post #1 of 3 (7812 views)

Hello Zope-DB members

I'm migrating my zope/python/mysql/... installation from RedHat 3 to
RedHat 5 and I still have a little problem.

If I just start python and enter "import MySQLdb" I get the following
error:

> Python 2.3.6 (#1, Nov 7 2007, 17:02:40)
> [GCC 4.1.1 20070105 (Red Hat 4.1.1-52)] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
> >>> import MySQLdb
> Traceback (most recent call last):
> File "<stdin>", line 1, in ?
> File "/scratch/local/app/python/current/lib/python2.3/site-
> packages/PIL/__init__.py", line 19, in ?
>
> File "build/bdist.linux-i686/egg/_mysql.py", line 7, in ?
> File "build/bdist.linux-i686/egg/_mysql.py", line 6, in
> __bootstrap__
> ImportError: libmysqlclient_r.so.15: cannot open shared object
> file: No such file or directory

If I do the same after setting the LD_LIBRARY_PATH to /usr/local/lib/
mysql, I did not get error messages anymore!

Now the problem: I included the LD_LIBRARY_PATH to my startup-script
zopectl (see below) but I still get the same error message in the
event.log file:

> 2007-11-07T20:53:24 ERROR Zope Could not import Products.ZMySQLDA
> Traceback (most recent call last):
> File "/scratch/local/app/zope/2.8.9.1-2.3.6/lib/python/OFS/
> Application.py", line 695, in import_product
> product=__import__(pname, global_dict, global_dict, silly)
> File "/scratch/ZOPE/TEMPLATE_ZOPE-2.8.9.1_SILVA-1.5.10/Products/
> ZMySQLDA/__init__.py", line 91, in ?
> import DA
> File "/scratch/ZOPE/TEMPLATE_ZOPE-2.8.9.1_SILVA-1.5.10/Products/
> ZMySQLDA/DA.py", line 92, in ?
> from db import DB
> File "/scratch/ZOPE/TEMPLATE_ZOPE-2.8.9.1_SILVA-1.5.10/Products/
> ZMySQLDA/db.py", line 89, in ?
> import _mysql
> File "build/bdist.linux-i686/egg/_mysql.py", line 7, in ?
> File "build/bdist.linux-i686/egg/_mysql.py", line 6, in
> __bootstrap__
> ImportError: libmysqlclient_r.so.15: cannot open shared object
> file: No such file or directory

Any idea?

My versions:

> Zope-2.8.9.1-final
> Python-2.3.6
> MySQL-python-1.2.2
> mysql-5.0.45

The "zopectl" file:

> #! /bin/bash
>
> PYTHON="/scratch/local/app/python/2.3.6/bin/python"
> ZOPE_HOME="/scratch/local/app/zope/2.8.9.1-2.3.6"
>
> reldir=`dirname $0`
> INSTANCE_HOME=`cd $reldir/..; pwd`
> CONFIG_FILE="$INSTANCE_HOME/etc/zope.conf"
>
> SOFTWARE_HOME="/scratch/local/app/zope/2.8.9.1-2.3.6/lib/python"
> PYTHONPATH="$SOFTWARE_HOME"
>
> export PYTHONPATH INSTANCE_HOME SOFTWARE_HOME
>
> export TEMP=/tmp
> export LD_LIBRARY_PATH=/usr/local/lib/mysql
> export PYTHON_EGG_CACHE=$INSTANCE_HOME/var/.python-eggs
>
> ZDCTL="$SOFTWARE_HOME/Zope2/Startup/zopectl.py"
>
> exec "$PYTHON" "$ZDCTL" -C "$CONFIG_FILE" "$@"

Grazie,
Michele

--
ETH Zürich
Michele Marcionelli
IT Support Gruppe D-MATH
HG G 18
Rämistrasse 101
CH–8092 Zürich

michele.marcionelli@math.ethz.ch
http://www.math.ethz.ch/~michele

+41 44 632 6193 Telefon
+41 44 632 1404 Fax

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: ImportError: libmysqlclient_r.so.15 [ In reply to ]

charlie at egenix

Nov 7, 2007, 12:41 PM

Post #2 of 3 (7580 views)

Permalink

Am 07.11.2007, 21:31 Uhr, schrieb Michele Marcionelli
<michele.marcionelli@math.ethz.ch>:

> If I do the same after setting the LD_LIBRARY_PATH to
> /usr/local/lib/mysql, I did not get error messages anymore!
> Now the problem: I included the LD_LIBRARY_PATH to my startup-script
> zopectl (see below) but I still get the same error message in the
> event.log file:

Sounds like a permissions problem: the Zope user might not be allowed to
access /usr/local/lib/mysql.

Charlie

--
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
________________________________________________________________________

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::

eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48
D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
Registered at Amtsgericht Duesseldorf: HRB 46611
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: ImportError: libmysqlclient_r.so.15 [ In reply to ]

michele.marcionelli at math

Nov 7, 2007, 11:33 PM

Post #3 of 3 (7581 views)

Permalink

Hello Charlie

no... it's not a permissions problem (and also not a SELinux
problem). I just found a solution for the problem

echo "/usr/local/lib/mysql" > /etc/ld.so.conf.d/mysql.conf
ldconfig

But I still wonder why the LD_LIBRARY_PATH variable is ignored!?

Any idea?

Thank you,
Michele

On 07.11.2007, at 21:41, Charlie Clark wrote:

> Am 07.11.2007, 21:31 Uhr, schrieb Michele Marcionelli
> <michele.marcionelli@math.ethz.ch>:
>
>> If I do the same after setting the LD_LIBRARY_PATH to /usr/local/
>> lib/mysql, I did not get error messages anymore!
>> Now the problem: I included the LD_LIBRARY_PATH to my startup-
>> script zopectl (see below) but I still get the same error message
>> in the event.log file:
>
> Sounds like a permissions problem: the Zope user might not be
> allowed to access /usr/local/lib/mysql.
>
> Charlie

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db