OSB SFTP Business Service

http://hhendriks.wordpress.com/2012/08/13/create-a-sftp-polling-service-in-the-osb/

http://docs.oracle.com/cd/E17904_01/doc.1111/e15866/transport_level.htm#i1058815
102 and 200 are two hosts.

I have created a PV_POC_SFTP project on 102 7001, to transfer files to 200

on 200:

mkdir /home/soa/sftpdestination

/sbin/ifconfig

10.56.25.135

on 102:

cat /home/soa/.ssh/known_hosts | grep hqchpippo200

hqchpippo200,10.56.25.135 ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEA6KpqfXWf6XdJBQFjYgc2rmapk2yba55BZrdLqbJjIIEb15Huc7zrIxAQeXJh8eohD5qCUGztOhJzmURuPP1oofxI1iERzp0QWED7ZnO1EPqMLp+FdLxTC03he1gn2Ng1ugYPZkpGrkaG/pYEs8LlTFadQ6ICa4fIAxQYNxa8R0MEkzxsCewP66ahzPTGVWp03QpPtUPQV0sOIOb7mZKPaxQ3JhxN+IFDDIKoWuiaz1B08oV51JtdBnQRR0JPIzx1EwwUL9x2tEKNKzcCzhFn8jwsxvKP882c5R6rWHDn1adS6F+rg3jPjmyV1h4J/CnAFmYlNMVdeLo7zhfh95JURw==

hqchpippo200.acme.com ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEA6KpqfXWf6XdJBQFjYgc2rmapk2yba55BZrdLqbJjIIEb15Huc7zrIxAQeXJh8eohD5qCUGztOhJzmURuPP1oofxI1iERzp0QWED7ZnO1EPqMLp+FdLxTC03he1gn2Ng1ugYPZkpGrkaG/pYEs8LlTFadQ6ICa4fIAxQYNxa8R0MEkzxsCewP66ahzPTGVWp03QpPtUPQV0sOIOb7mZKPaxQ3JhxN+IFsdDDoWuiaz1B08oV51JtdBnQRR0JPIzx1EwwUL9x2tEKNKzcCzhFn8jwsxvKP882c5R6rWHDn1adS6F+rg3jPjmyV1h4J/CnAFmYlNMVdeLo7zhfh95JURw==

(official Oracle doc is WRONG!  it’s not $DOMAIN_HOME/osb/transports/sftp but $DOMAIN_HOME/config/osb/transports/sftp !!!!!)


mkdir –p /opt/oracle/domains/osbdv2do/config/osb/transports/sftp

cd /opt/oracle/domains/osbdv2do/config/osb/transports/sftp

vi known_hosts

paste the result of cat /home/soa/.ssh/known_hosts | grep hqchpippo200
(it's above)

create Service Account

PV_POC_SFTP_SA

static

soa

#thepassword


create the BS

anyxml

protocol sftp

endpoint uri

sftp://hqchpippo200:22/sftpdestination 


press ADD

User Authentication =Username Password

attach service account


test

if you get this:

The invocation resulted in an error: com.sshtools.j2ssh.transport.InvalidHostFileException: known_hosts file does not exist or it does not have read permissions..

check that you put the known_hosts in the right place /opt/oracle/domains/osbdv2do/config/osb/transports/sftp


if you get this:

The invocation resulted in an error: com.sshtools.j2ssh.transport.TransportProtocolException: Key Mismatch for host hqchpippo200,10.56.25.135.

make sure you got the right ssh-rsa kkeys from the /home/soa/.ssh/known_hosts file


upon successful invokation of the service, on 200 in /home/soa/sftpdestination you should see a file

How to specify a destination filename, and how to put some content into it, who knows.... we shall discover