Re: [Sqlrelay-discussion] Connection problem
Brought to you by:
mused
Menu
▾
▴
Re: [Sqlrelay-discussion] Connection problem
|
From: David M. <dav...@fi...> - 2013-07-31 13:41:31
|
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 > |
