[Sqlrelay-discussion] SQLRelay install problem

[Gerson S. <gsa...@gm...>]

Hi

I have a debian linux with oracle 10g client and sqlrelay 0.36.4 and I trie=
d
connect zope 2.7 instance with ZSQLRelayDA to a remote Oracle 8i linux
server.

After sqlrelay install process I edited etc/sqlrelay.conf file and I tried
execute sqlr-start

------------------
./sqlr-start -id Vega

Starting listener:
  sqlr-listener-debug -id Vega -config
/usr/local/firstworks/etc/sqlrelay.conf &
sh: line 1: sqlr-listener-debug: command not found

Starting 2 connections to VEGA :
  sqlr-connection-oracle8 -id Vega -connectionid VEGA -config
/usr/local/firstworks/etc/sqlrelay.conf
sh: line 1: sqlr-connection-oracle8: command not found

sqlr-connection-oracle8 failed to start.

Thanks to MP3.com for sponsoring:
        Clustered/Replicated database support.
        Perl API.
----------------

Then I tried to run sqlr-listener / sqlr-connection-oracle8 manually but th=
e
sqlrsh don't return any query then I run sqlr-listener-debug and the
var/sqlrelay/debug/sqlrelay-listener.24918 was

--------------
01/18/2006 16:48:49 BRST listener [24918] : id filename:
01/18/2006 16:48:49 BRST listener [24918] :
/usr/local/firstworks/var/sqlrelay/tmp/ipc/Vega
01/18/2006 16:48:49 BRST listener [24918] :     creating shared memory...
01/18/2006 16:48:49 BRST listener [24918] :     creating semaphores...
01/18/2006 16:48:49 BRST listener [24918] : waiting for client connection..=
.
-------------

My sqlrelay.conf
-------------
<?xml version=3D"1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>
    <instance id=3D"Vega" port=3D"9000" socket=3D"/tmp/vega_mega.socket"
dbase=3D"oracle8" connections=3D"2" maxconnections=3D"10" maxqueu
elength=3D"0" growby=3D"1" ttl=3D"60" endofsession=3D"commit" sessiontimeou=
t=3D"600"
runasuser=3D"nobody" runasgroup=3D"nobody" cursors=3D"5"
authtier=3D"listener" handoff=3D"pass" debug=3D"listener">
        <users>
            <user user=3D"HPS" password=3D"HPS"/>
        </users>
        <connections>
            <connection connectionid=3D"VEGA"
string=3D"user=3DHPS;password=3DHPS;oracle_sid=3DVEGA.MEGA" metric=3D"1"/>
        </connections>
    </instance>
</instances>
-----------

My tnsnames.ora
----------
VEGA.MEGA =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D
      (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 10.10.69.16)(PORT =3D 1521))
    )
    (CONNECT_DATA =3D
      (SID =3D VEGADB)
      (SERVER =3D DEDICATED)
    )
)
---------

Thanks in advance for any help

Gerson