[Sqlrelay-discussion] SQLRelay install issue

[Vecchio, P. <PVe...@or...>]

So close! Can't quite figure out the last leg of this install.
=20
I have freetds-0.63 working - tested with the tsql command.
=20
unixODBC working -tested with the isql command.
=20
sqlr - working:
=20
some@here bin]# sqlr-start -id mssql
=20
Starting listener:
  sqlr-listener -id mssql -config =
/usr/local/firstworks/etc/sqlrelay.conf
=20
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
=20
Starting scaler:
  sqlr-scaler  -id mssql -config /usr/local/firstworks/etc/sqlrelay.conf
=20
Starting cache manager:
  sqlr-cachemanager
=20

Thanks to MP3.com for sponsoring:=20
        Clustered/Replicated database support.
        Perl API.
=20
All running on RedHad Linux Enterprise.  Trying to finish connecting to =
MSSQL Server.
=20
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:
=20
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=3D__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=3Ddebug_mode)
  File "/usr/src/zope-2.7.7/lib/python/OFS/Application.py", line 673, in =
import_product
    product=3D__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

=20
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)
=20
Yet I'm still getting this "cannot open shared object file" error.
=20
Can anyone help shed some light on this for me?  I would be eternally =
grateful.
=20
Thanks,


Peppi Vecchio | Web Developer=20
TECHNOLOGY SERVICES GROUP=20

=20


_________________________________________________________

The information contained in this message is privileged, confidential =
and=20
intended only for use of the individual or entity addressed above.  If =
you=20
have received this communication in error, please immediately notify us
by reply and delete the same.  Thank you.=20