Devart Forums

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?

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.

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.

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.

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

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

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