Re: [Sqlrelay-discussion] SQLRelay install issue
Brought to you by:
mused
|
From: Firstworks/4access <dav...@fi...> - 2005-11-04 14:56:52
|
Did you ever get this worked out? Usually what causes this problem is if libsqlrclient-0.34.r.so.1 isn't in your LD_LIBRARY_PATH or /etc/ld.so.conf file. If you're sure that it is and you're sure that you've run ldconfig (which you did), then the only other reason that it might not work is if the python module CSQLRelay.so was compiled with -rpath and libsqlrclient-0.34.4.so.1 isn't in that path. Try doing: ldd /usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/CSQLrelay.so and see what path it has for libsqlrclient-0.34.4.so.1 If the output of the ldd command isn't clear, send it to me and I'll take a look at it. There does also appear to be something strange going on with Zope. If you installed stuff under /lib/python, then why is Zope looking (and finding) stuff in /usr/src/zope-2.7.7/lib/python? David Muse dav...@fi... On Thu, 2005-10-20 at 14:22 -0400, Vecchio, Peppi wrote: > So close! Can't quite figure out the last leg of this install. > > I have freetds-0.63 working - tested with the tsql command. > > unixODBC working -tested with the isql command. > > sqlr - working: > > some@here bin]# sqlr-start -id mssql > > Starting listener: > sqlr-listener -id mssql > -config /usr/local/firstworks/etc/sqlrelay.conf > > Starting 3 connections to db1 : > sqlr-connection-freetds -id mssql -connectionid db1 > -config /usr/local/firstworks/etc/sqlrelay.conf > sqlr-connection-freetds -id mssql -connectionid db1 > -config /usr/local/firstworks/etc/sqlrelay.conf > sqlr-connection-freetds -id mssql -connectionid db1 > -config /usr/local/firstworks/etc/sqlrelay.conf > > Starting scaler: > sqlr-scaler -id mssql > -config /usr/local/firstworks/etc/sqlrelay.conf > > Starting cache manager: > sqlr-cachemanager > > > Thanks to MP3.com for sponsoring: > Clustered/Replicated database support. > Perl API. > > All running on RedHad Linux Enterprise. Trying to finish connecting > to MSSQL Server. > > When I installed SQLRelay, it put ZSQLRelayDA in /lib/python/Products. > I read somewhere that SQLRelay (in /lib/python/Products/ZSQLRelayDA/) > needs to be in /lib/python. So I tried it and have gotten this far. > Now when I restart zope with zopectl fg - this is the error I'm > seeing: > > 2005-10-20T13:32:29 ERROR(200) Zope Could not import > Products.ZSQLRelayDA > Traceback (most recent call last): > File "/usr/src/zope-2.7.7/lib/python/OFS/Application.py", line 673, > in import_product > product=__import__(pname, global_dict, global_dict, silly) > File > "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/__init__.py", > line 7, in ? > import DA > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/DA.py", > line 7, in ? > from db import DB > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/db.py", > line 1, in ? > import SQLRelay, DateTime > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/__init__.py", line 4, > in ? > import PySQLRDB > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/PySQLRDB.py", line 10, > in ? > from SQLRelay import CSQLRelay > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/__init__.py", > line 4, in ? > import PySQLRDB > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/PySQLRDB.py", > line 10, in ? > from SQLRelay import CSQLRelay > ImportError: libsqlrclient-0.36.4.so.1: cannot open shared object > file: No such file or directory > Traceback (most recent call last): > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/run.py", line 50, > in ? > run() > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/run.py", line 19, > in run > start_zope(opts.configroot) > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/__init__.py", line > 52, in start_zope > starter.startZope() > File "/usr/src/zope-2.7.7/lib/python/Zope/Startup/__init__.py", line > 231, in startZope > Zope.startup() > File "/usr/src/zope-2.7.7/lib/python/Zope/__init__.py", line 47, in > startup > _startup() > File "/usr/src/zope-2.7.7/lib/python/Zope/App/startup.py", line 45, > in startup > OFS.Application.import_products() > File "/usr/src/zope-2.7.7/lib/python/OFS/Application.py", line 650, > in import_products > import_product(product_dir, product_name, raise_exc=debug_mode) > File "/usr/src/zope-2.7.7/lib/python/OFS/Application.py", line 673, > in import_product > product=__import__(pname, global_dict, global_dict, silly) > File > "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/__init__.py", > line 7, in ? > import DA > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/DA.py", > line 7, in ? > from db import DB > File "/usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/db.py", > line 1, in ? > import SQLRelay, DateTime > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/__init__.py", line 4, > in ? > import PySQLRDB > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/PySQLRDB.py", line 10, > in ? > from SQLRelay import CSQLRelay > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/__init__.py", > line 4, in ? > import PySQLRDB > File "/usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/PySQLRDB.py", > line 10, in ? > from SQLRelay import CSQLRelay > ImportError: libsqlrclient-0.36.4.so.1: cannot open shared object > file: No such file or directory > > > libsqlrclient-0.36.r.so.1 is in /usr/local/firstworks/lib - this path > is also in ld.so.conf (of which I removed ld.so.cache and ran > ldconfig) > > Yet I'm still getting this "cannot open shared object file" error. > > Can anyone help shed some light on this for me? I would be eternally > grateful. > > Thanks, > > > Peppi Vecchio | Web Developer > TECHNOLOGY SERVICES GROUP > > > > ______________________________________________________________________ > > The information contained in this message is privileged, confidential > and intended only for use of the individual or entity addressed above. > If you have received this communication in error, please immediately > notify us by reply and delete the same. Thank you. > |