RE: [Sqlrelay-discussion] SQLRelay install issue
Brought to you by:
mused
|
From: David M. <dav...@fi...> - 2005-11-08 03:42:57
|
The SQLRelay folder should definitely go inside the lib/python/Products/ZSQLRelayDA folder. After making sure that's right, try: ldd /usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA/SQLRelay/CSQLRelay.so Dave dav...@fi... On Fri, 2005-11-04 at 10:39 -0500, Vecchio, Peppi wrote: > Thanks for the help. I did the "ldd /usr/src/zope-2.7.7/lib/python/SQLRelay/SQLRelay/CSQLrelay.so" and it came up with "no such file or directory" via commandline, but through my SSHclient, I'm looking at the file. I musn't have the path set properly. I'll continue to work on it. > > As far as the Zope path, I'm afraid it's my mistake for not being entirely clear. The /lib/python is actually /usr/src/zope-2.7.7/lib/python/. I had read that someone moved the SQLRelay folder to /usr/src/zope-2.7.7/lib/python/ as opposed to /usr/src/zope-2.7.7/lib/python/Products/ZSQLRelayDA. Thought it was worth a try. As far as structure and permissions, can you please confirm for me that the SQLRelay folder does belong in ZSQLRelayDA and that all folders should be set to 755 and all subsequent files (dtml, py, etc.) should be 644? Seems I've had some issues installing other products where the permissions were not getting set right. > > Thanks again, > > Peppi Vecchio | Web Developer > TECHNOLOGY SERVICES GROUP > > > > -----Original Message----- > From: sql...@li... > [mailto:sql...@li...]On Behalf Of > Firstworks/4access > Sent: Friday, November 04, 2005 10:00 AM > To: sql...@li... > Subject: Re: [Sqlrelay-discussion] SQLRelay install issue > > > 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. > > > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |