SFTP in BC

Is anybody has implement or got SFTP in BusConnector? Where can get it or how to use with BC.
Regards.

hi all,

I am working on SAPbc and I need to implement the OpenSSH in to this and use the SFTP command and communicate with the remotehost using this but, I have a problem here.

I have configured the properties as per Advantage-instructions… that come along with the package. but, here when I execute the sftp service with the required parameters,I am not able to access the remote server but it errors out with the message

Connecting to xx.xxx.xxx.
OpenSSH_3.8.1p1, OpenSSL 0.9.7d 17 Mar 2004
debug1: Reading configuration data packages/OpenSSH/config/options.properties

debug1: Applying options for *
debug1: Connecting to xxx.xxx.xxx[xx.xxx.xx.xxx] port 22.
debug1: connect to address xx.xxx.xx.xxx port 22: Connection timed out
ssh: connect to host xxx.xxx.xxx port 22: Connection timed out
Connection closed

kindly some body help me with the above. the situation is that I am able to execute the batch comand through the command line, but when i am doing through the flow service, i am not able to do it.

immediate help is appreciated.

Thanks in Advance,

Regards,
Teja.

hi all,
HELP ME…Its getting to the crunch for me.
I have no idea as to how to proceed with this error that i am facing with the SFTP in SAPbc.here, I have a new issue which i found is the main reason for the connection to the remote server using the ssh protocol.

the following is the error that i am facing when i execute the sftp service through the SAPbc.
Connecting to xx.xxxx.xxx…
OpenSSH_3.8.1p1, OpenSSL 0.9.7d 17 Mar 2004
debug1: Reading configuration data packages/OpenSSH/config/options.properties
debug1: Applying options for *
debug1: Applying options for xxx.xxxx.xxx
debug1: Applying options for *
debug1: Executing proxy command: exec connect -H sec-proxy.xxxx.xxxxxxxxx.com:8080 xxx.xxx.xxx 9022
debug1: identity file openssh/intserv.rsa.pub type 1
/bin/sh: No such file or directory
ssh_exchange_identification: Connection closed by remote host
Connection closed

I have no Idea why is it that I am not able to execute the proxycommand “Connect”.

I see from the past 2 days none are responding…neither is the thing getting solved. I appreciate if someone who has worked on this kind of issue can help me…

please do it…immediately…its urgent for me.

Thanks and Regards,
Teja.

Teja,

Please confirm the port number for the SFTP server to which you are attempting to connect. I don’t believe that either port 22 or port 8080 is correct as shown in your two examples.

Also, this is an all volunteer user group. Insisting on immediate help is not likely to get you an answer. For urgent requests, I suggest you log a service request with webMethods Support.

Regards,

Mark

Teja,

Have you successfully been able to sftp to your partner from the command line? If not, get that working first.

Also, what platform are you running on? Your post above shows the following error:
/bin/sh: No such file or directory

Not sure what platforms the OpenSSH package was tested on and I’ve never personally used it, but my understanding is that it relies on exec’ing command line programs to do it’s work. Paths to these programs will certainly differ between OS’s and /bin/sh will certainly not exist if you are running on Windows…

Hopefully all of this can be configured in a properties file.

hi mark and Jlammers,

      Thanks for your response.

I am sorry about the mail, i jus was in desperation from my end.Thanks mark for your suggestion.

  coming to my problem, I have infact successfully executed the sftp on commandline earlier(sorry for not mentioning eariler). but it was the problem with the sftp service in webmethods that was erring out with the above statements...
     Now, we have succesfully completed the Execution Even through the Webmethods service, All we had to do was add the sh.exe to the bin folder in webmethods Integration server folder. I was getting confused earlier because the sh.exe was there in /bin folder of OpenSSH software and the path was set.. but the thing was it was not readable to webmethods so, this trick worked..

            Thanks again for your response.

the response and help comes very fast almost all the time from all of you guys that we just forget that its a voluntary service…:slight_smile:

Regards,
Teja.

No worries. Glad its working for you. What port did you end up using?

Mark

Hi All,

Need your help urgently… I am using SAP-BC 4.0(On windows 200) and implementing Openssh to transfer files to a Unix Box.

SFTP connects well from the command prompt.
when trying to execute the "sftp service " from Developer. It gives me


Connecting to abc.zzz.com
OpenSSH_3.8.1p1, OpenSSL 0.9.7d 17 Mar 2004
debug1: Reading configuration data packages/OpenSSH/config/options.properties
debug1: Applying options for abc.zzz.com
debug2: ssh_connect: needpriv 0

debug1: Executing proxy command: exec connect -H xxxx.yyyyy.com:8080 abc.zzz.com 9022
debug3: Not a RSA1 key file intserv.rsa.
debug3: key_read: missing keytype
debug1: identity file intserv.rsa type 1

ssh_exchange_identification: Connection closed by remote host
Connection closed

while in case of sucess results are as below.


Connecting to abc.zzz.com
OpenSSH_3.8.1p1, OpenSSL 0.9.7d 17 Mar 2004
debug1: Reading configuration data packages/OpenSSH/config/options.properties
debug1: Applying options for abc.zzz.com
debug1: Executing proxy command: exec connect -H xxxx.yyyyy.com:8080 abc.zzz.com 9022

debug1: identity file intserv.rsa type -1
debug1: Remote protocol version 2.0, remote software version http://3sp.com_Maverick_SSHD
debug1: no match: http://3sp.com_Maverick_SSHD
debug1: Enabling compatibility mode for protocol 2.0
debug1: Local version string SSH-2.0-OpenSSH_3.8.1p1
debug1: SSH2_MSG_KEXINIT sent
debug1: SSH2_MSG_KEXINIT received
debug1: kex: server->client aes128-cbc hmac-md5 none
debug1: kex: client->server aes128-cbc hmac-md5 none
debug1: sending SSH2_MSG_KEXDH_INIT
debug1: expecting SSH2_MSG_KEXDH_REPLY
debug1: Host ‘abc.zzz.com’ is known and matches the RSA host key.
debug1: Found key in /.ssh/known_hosts:2
debug1: ssh_rsa_verify: signature correct
debug1: SSH2_MSG_NEWKEYS sent
debug1: expecting SSH2_MSG_NEWKEYS
debug1: SSH2_MSG_NEWKEYS received
debug1: SSH2_MSG_SERVICE_REQUEST sent
debug1: SSH2_MSG_SERVICE_ACCEPT received
GIS SSH Server supporting SFTP and SCP
debug1: Authentications that can continue: publickey,password
debug1: Next authentication method: publickey
debug1: Trying private key: intserv.rsa
debug1: read PEM private key done: type RSA
debug1: Authentication succeeded (publickey).
debug1: channel 0: new [client-session]
debug1: Entering interactive session.
debug1: Sending subsystem: sftp
debug1: client_input_channel_req: channel 0 rtype exit-status reply 0
debug1: channel 0: free: client-session, nchannels 1
debug1: Transferred: stdin 0, stdout 0, stderr 0 bytes in 2.5 seconds
debug1: Bytes per second: stdin 0.0, stdout 0.0, stderr 0.0
debug1: Exit status 0

Could anyone please help what should be missing in this scenario…
and what is the command or process which gets details from remote server as in logs ;;;

debug1: Remote protocol version 2.0, remote software version http://3sp.com_Maverick_SSHD
debug1: no match: http://3sp.com_Maverick_SSHD
debug1: Enabling compatibility mode for protocol 2.0
debug1: Local version string SSH-2.0-OpenSSH_3.8.1p1
debug1: SSH2_MSG_KEXINIT sent
debug1: SSH2_MSG_KEXINIT received

Any help is appreciated.

Regards,
Amit

Hi All,

Cud anybody please help me with the sftp (http - proxy user authentication).
How to specify Proxy User ID and Password when executing sftp command.

Any Help is greatly appreciated.

Thanks
Amit

Hi Amit,

Did you get that working through proxy?
I am using customware package for sftp which uses JSCH API, normal sftp works.

however I searching how to add proxy setting, if you have done this, please let me know.

Thanks,
Sumit