IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Expand all | Collapse all

SFTP in BC

  • 1.  SFTP in BC

    Posted Tue June 15, 2004 10:53 PM

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


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 2.  RE: SFTP in BC

    Posted Wed August 09, 2006 03:31 PM

    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.


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 3.  RE: SFTP in BC

    Posted Sat August 12, 2006 01:07 PM

    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.


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 4.  RE: SFTP in BC

    Posted Sat August 12, 2006 01:08 PM

    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 5.  RE: SFTP in BC

    Posted Tue August 15, 2006 04:46 PM

    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


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 6.  RE: SFTP in BC

    Posted Tue August 15, 2006 09:03 PM

    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.


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 7.  RE: SFTP in BC

    Posted Thu August 17, 2006 05:25 PM

    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.


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 8.  RE: SFTP in BC

    Posted Thu August 17, 2006 05:54 PM

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

    Mark


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 9.  RE: SFTP in BC

    Posted Thu July 26, 2007 07:04 PM

    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


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 10.  RE: SFTP in BC

    Posted Tue July 31, 2007 04:40 AM

    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


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 11.  RE: SFTP in BC

    Posted Fri October 10, 2008 10:23 AM

    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


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB