Re: [Sqlrelay-discussion] Connection problem

[David M. <dav...@fi...>]

When using sqlplus, you appear to be using an ORACLE_SID of 
1.2.3.4:1234/SID but then in the sqlrelay configuration you appear to be 
using an oracle_sid of TEST.

Try using the same ORACLE_SID that you used with sqlplus and see if that 
fixes the problem or not.

David Muse
dav...@fi...

On 7/31/2013 1:28 AM, Jiří Wetter wrote:
> Hello everybody,
>
> I have trouble with connection. I have configured only one connection
> for testing purpose. With sqlplus64 haven't problem to log-in.
>
> sqlplus64 username/password@1.2.3.4:1234/SID => success
>
> but with sqlrelay always getting
>
> 07/30/2013 14:30:03 BST connection [11404] : attaching to shared memory
> and semaphores
> 07/30/2013 14:30:03 BST connection [11404] : id filename:
> /var/cache/sqlrelay/tmp/ipc/TEST
> 07/30/2013 14:30:03 BST connection [11404] : attaching to shared memory...
> 07/30/2013 14:30:03 BST connection [11404] : attaching to semaphores...
> 07/30/2013 14:30:03 BST connection [11404] : done attaching to shared
> memory and semaphores
> 07/30/2013 14:30:03 BST connection [11404] : getting unix socket...
> 07/30/2013 14:30:03 BST connection [11404] : opening
> /var/cache/sqlrelay/tmp/sockseq
> 07/30/2013 14:30:03 BST connection [11404] : locking...
> 07/30/2013 14:30:03 BST connection [11404] : got sequence number: 1178
> 07/30/2013 14:30:03 BST connection [11404] : writing new sequence
> number: 1179
> 07/30/2013 14:30:03 BST connection [11404] : unlocking...
> 07/30/2013 14:30:03 BST connection [11404] : done getting unix socket
> 07/30/2013 14:30:03 BST connection [11404] : logging in "TEST"...
> 07/30/2013 14:30:03 BST connection [11404] : log in failed
>
> 	<users>
>           <user user="sqlr_test"  password="sqlr_test"  />
>           </users>
>           <connections>
>               <connection connectionid="TEST"
>                   string="user=SameUsernameLikeSQLPLUS;password=SamePasswordLikeSQLPLUS
> ;oracle_sid=TEST;autocommit=no;maxselectlistsize=32"
>                   metric="1"
>               />
>           </connections>
>
>
> Thank you for help.
>
>
> ------------------------------------------------------------------------------
> Get your SQL database under version control now!
> Version control is standard for application code, but databases havent
> caught up. So what steps can you take to put your SQL databases under
> version control? Why should you start doing it? Read more to find out.
> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com
>