can't use solaris 10 sshd server and oracle.

Discussion of open issues, suggestions and bugs regarding network security and data protection solution - SecureBridge
Post Reply
xalion
Posts: 124
Joined: Fri 20 May 2005 10:08

can't use solaris 10 sshd server and oracle.

Post by xalion » Thu 22 Nov 2007 08:01

hi,I like this product.
I use it with linux l ok.
but when I use it with solaris 10 sshd server and oracle with same problem.

I use sshclient in my pc. and shhd server in solaris. connection is ok.
and oracle installed in same server.
I use channel forward to the server.
in my pc have a tns name like this:
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 127.0.0.1)(PORT = 5001))) (CONNECT_DATA = (SERVICE_NAME = ORCL))).
but when i use oracle tnsping ,

sshclient show "connection timeout expired". and sshclient stoped .

what's wrong with this?

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 22 Nov 2007 09:30

Please describe settings of your TScSSHChannel component, and connection settings of your Oracle server (host name, port number).
When does the error occurs, on TScSSHchannel connect, or on Oracle client connect?

Can you establish connection to Oracle using another SSH client like OpenSSH?
Is it possible that Solaris refuses connection between sshd and Oracle.

xalion
Posts: 124
Joined: Fri 20 May 2005 10:08

detail

Post by xalion » Fri 23 Nov 2007 02:27

I use the sshclient demo, and i set server ip:172.16.131.44 port:22
use:oracle . I can connect the server ,and I can use the shell command.
it looks the sshd server is fine.
oracle server install in 172.16.131.44 port:1521.
chanell forward source port :5001 .des ip:172.16.131.44 des port:1521
when oracle client connect. the error occurs.

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 23 Nov 2007 08:27

Set ScSSHChannel.DestHost to '127.0.0.1', and try to increase ScSSHChannel.Timeout.
If the problem still persists, it means that Solaris refuses connection between sshd and Oracle.

xalion
Posts: 124
Joined: Fri 20 May 2005 10:08

Post by xalion » Fri 23 Nov 2007 08:48

so ,it still there. maybe solaris don't like sshd connect oracle.

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 23 Nov 2007 13:37

I asked you to check connection to Oracle using another SSH client like OpenSSH. What was the result?

xalion
Posts: 124
Joined: Fri 20 May 2005 10:08

i find the answer.

Post by xalion » Tue 27 Nov 2007 02:12

I found solaris sshd's config file.
"# Port forwarding
AllowTcpForwarding yes " this default is no.
I changed it to yes.
now It works fine.

Post Reply