Problems installing the MySQL drivers
Hello, I try to install the Zope MySQL drivers, instructions from http://heanet.dl.sourceforge.net/sourceforge/mysql-python/ ZMySQLDA-2.0.8.tar.gz I dowloaded the python driver and the Zope DA from http://sourceforge.net/projects/mysql-python I did a: bastet:~/MySQL-python-0.9.2 # python setup.py build bastet:~/MySQL-python-0.9.2 # python setup.py install (as root) I used my /usr/bin/python to compile it, the same I used to build Zope. All seemed fine. Then I extracted the Zope DA from the Zope directory /opt/Zope2.7 it extracted into ./lib/python/Products/ZMySQLDA/ When I try to startup Zope bastet:/var/zope/bin # ./runzope ------ 2003-10-15T16:07:17 INFO(0) ZServer HTTP server started at Wed Oct 15 16:07:17 2003 Hostname: localhost.localdomain Port: 8080 ------ 2003-10-15T16:07:17 INFO(0) ZServer FTP server started at Wed Oct 15 16:07:17 2003 Hostname: bastet Port: 8021 ------ 2003-10-15T16:07:17 INFO(0) Zope Set effective user to "zope" ------ 2003-10-15T16:07:21 ERROR(200) Zope Could not import Products.ZMySQLDA Traceback (most recent call last): File "/opt/Zope-2.7/lib/python/OFS/Application.py", line 534, in import_product product=__import__(pname, global_dict, global_dict, silly) File "/opt/Zope-2.7/lib/python/Products/ZMySQLDA/__init__.py", line 91, in ? import DA File "/opt/Zope-2.7/lib/python/Products/ZMySQLDA/DA.py", line 92, in ? from db import DB File "/opt/Zope-2.7/lib/python/Products/ZMySQLDA/db.py", line 89, in ? import _mysql ImportError: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory Traceback (most recent call last): File "/opt/Zope-2.7/lib/python/Zope/Startup/run.py", line 27, in ? run() File "/opt/Zope-2.7/lib/python/Zope/Startup/run.py", line 24, in run start_zope(opts.configroot) File "/opt/Zope-2.7/lib/python/Zope/Startup/__init__.py", line 50, in start_zope starter.startZope() File "/opt/Zope-2.7/lib/python/Zope/Startup/__init__.py", line 218, in startZope Zope.startup() File "/opt/Zope-2.7/lib/python/Zope/__init__.py", line 46, in startup _startup() File "/opt/Zope-2.7/lib/python/Zope/App/startup.py", line 47, in startup OFS.Application.import_products() File "/opt/Zope-2.7/lib/python/OFS/Application.py", line 512, in import_products import_product(product_dir, product_name, raise_exc=debug_mode) File "/opt/Zope-2.7/lib/python/OFS/Application.py", line 534, in import_product product=__import__(pname, global_dict, global_dict, silly) File "/opt/Zope-2.7/lib/python/Products/ZMySQLDA/__init__.py", line 91, in ? import DA File "/opt/Zope-2.7/lib/python/Products/ZMySQLDA/DA.py", line 92, in ? from db import DB File "/opt/Zope-2.7/lib/python/Products/ZMySQLDA/db.py", line 89, in ? import _mysql ImportError: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory bastet:/var/zope/bin # What's wrong? Thanks, Florian
--On Mittwoch, 15. Oktober 2003 16:10 Uhr +0200 Florian Lindner <mailinglists@xgm.de> wrote:
ImportError: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory bastet:/var/zope/bin #
adjust the LD_LIBRARY_PATH environment to the directory containing the corresponding libraries. -aj
Am Mittwoch, 15. Oktober 2003 16:19 schrieben Sie:
--On Mittwoch, 15. Oktober 2003 16:10 Uhr +0200 Florian Lindner
<mailinglists@xgm.de> wrote:
ImportError: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory bastet:/var/zope/bin #
adjust the LD_LIBRARY_PATH environment to the directory containing the corresponding libraries.
-aj
Done, I added /usr/lib/mysql to my /etc/ld.so.conf The error went away, just to be replaced by another one: ImportError: /usr/lib/mysql/libmysqlclient_r.so.12: undefined symbol: ERR_get_error_line_data Any ideas? Thx, Florian
--On Mittwoch, 15. Oktober 2003 16:58 Uhr +0200 Florian Lindner <mailinglists@xgm.de> wrote:
Am Mittwoch, 15. Oktober 2003 16:19 schrieben Sie:
--On Mittwoch, 15. Oktober 2003 16:10 Uhr +0200 Florian Lindner
<mailinglists@xgm.de> wrote:
ImportError: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory bastet:/var/zope/bin #
adjust the LD_LIBRARY_PATH environment to the directory containing the corresponding libraries.
-aj
Done, I added /usr/lib/mysql to my /etc/ld.so.conf
The error went away, just to be replaced by another one:
ImportError: /usr/lib/mysql/libmysqlclient_r.so.12: undefined symbol: ERR_get_error_line_data
The symbol seems to come from OpenSSL. Maybe you have linked or compiled the Pytjon bindings against a different version of OpenSSL...or maybe the MySQL libs were compiled against a different version....best to compile MySQL from scratch. -aj
Am Mittwoch, 15. Oktober 2003 17:30 schrieben Sie:
--On Mittwoch, 15. Oktober 2003 16:58 Uhr +0200 Florian Lindner
<mailinglists@xgm.de> wrote:
Am Mittwoch, 15. Oktober 2003 16:19 schrieben Sie:
--On Mittwoch, 15. Oktober 2003 16:10 Uhr +0200 Florian Lindner
<mailinglists@xgm.de> wrote:
ImportError: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory bastet:/var/zope/bin #
adjust the LD_LIBRARY_PATH environment to the directory containing the corresponding libraries.
-aj
Done, I added /usr/lib/mysql to my /etc/ld.so.conf
The error went away, just to be replaced by another one:
ImportError: /usr/lib/mysql/libmysqlclient_r.so.12: undefined symbol: ERR_get_error_line_data
The symbol seems to come from OpenSSL. Maybe you have linked or compiled the Pytjon bindings against a different version of OpenSSL...or maybe the MySQL libs were compiled against a different version....best to compile MySQL from scratch.
Both MySQL and Python were compiled from scratch against the same OpenSSL version... this can't be the error :-( Thx, Florian
participants (2)
-
Andreas Jung -
Florian Lindner