Re: [Zope-DB] ImportError: libmysqlclient_r.so.15

2007-11-07 Thread Michele Marcionelli 

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  
<[EMAIL PROTECTED]>:


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

Re: [Zope-DB] ImportError: libmysqlclient_r.so.15

2007-11-07 Thread Charlie Clark 
Am 07.11.2007, 21:31 Uhr, schrieb Michele Marcionelli  
<[EMAIL PROTECTED]>:


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

[Zope-DB] ImportError: libmysqlclient_r.so.15

2007-11-07 Thread Michele Marcionelli 

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 "", 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

[EMAIL PROTECTED]
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