2 Replies Latest reply: Nov 30, 2011 9:59 AM by user9285225 RSS

    FTPS with Oracle SOA 11g FTP Adapter?

    tmcpheeters
      Has anyone successfully connected to a FTPS server using public key authentication with the FTP adapter?

      We receive this error:

      [2009-10-15T21:03:29.409-05:00] [soa_server1] [NOTIFICATION] [] [oracle.soa.adapter] [tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8c95a2f] [userId: <anonymous>] [ecid: 0000IHR5Tg1D4ia_dL7i6_1ApxF600000C,0] [APP: soa-infra] FTP Adapter FTP1 Poller raising Alert for exception : BINDING.JCA-11438[[
      Error in establishing connection to FTP Server.
      Error in establishing connection to FTP Server.
      Unable to establish connection to server.
      Please ensure hostname and port specified to login to the server is correct.

      ]]

      Edited by: tmcpheeters on Oct 16, 2009 7:42 AM
        • 1. Re: FTPS with Oracle SOA 11g FTP Adapter?
          tmcpheeters
          (2009-10-15T22:25:28.209-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) Ftp Adapter FTP1 Calling KeyManager with Keystore Algorith(OracleX509), and Provider(OracleJSSE)
          (2009-10-15T22:25:28.210-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) Ftp Adapter FTP1 Calling TrustManager with Keystore Algorith(OracleX509), and Provider(OracleJSSE)
          (2009-10-15T22:25:28.214-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) Ftp Adapter FTP1 SSLSocketFactory from context==>(com.sun.net.ssl.internal.ssl.SSLSocketFactoryImpl@8f463f6)
          (2009-10-15T22:25:28.407-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) FTP Adapter FTP1 Reading reply from uat.dbdirectconnect.db.com
          (2009-10-15T22:25:28.647-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) FTP Adapter FTP1 Host uat.dbdirectconnect.db.com FTP command: AUTH TLS
          (2009-10-15T22:25:28.840-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) FTP Adapter FTP1 FTP Command: AUTH TLS, reply:((
          234 AUTH TLS OK.

          ))
          (2009-10-15T22:26:29.470-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) FTP Adapter FTP1 Validating Input dir : /
          (2009-10-15T22:26:29.473-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) Ftp Adapter FTP1 FTPManagedConnectionFactory::getPasswordCredential using mcf for credentials
          (2009-10-15T22:26:29.474-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) Ftp Adapter FTP1 Managed Connection Created
          (2009-10-15T22:26:29.474-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) Ftp Adapter FTP1 Adding Event Listener
          (2009-10-15T22:26:29.476-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) Ftp Adapter FTP1 Connection Created
          (2009-10-15T22:26:29.476-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) FTP Adapter FTP1 Host name is 'uat.dbdirectconnect.db.com'.
          (2009-10-15T22:26:29.476-05:00) (soa_server1) (NOTIFICATION) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (APP: soa-infra) Ftp Adapter FTP1 The provider could not be added. Either it already exists or there was an error.
          (2009-10-15T22:26:29.476-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) Ftp Adapter FTP1 Calling KeyStore with KeystoreType(PKCS12), and Provider(OraclePKI)
          (2009-10-15T22:26:29.514-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) Ftp Adapter FTP1 Calling KeyManager with Keystore Algorith(OracleX509), and Provider(OracleJSSE)
          (2009-10-15T22:26:29.515-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) Ftp Adapter FTP1 Calling TrustManager with Keystore Algorith(OracleX509), and Provider(OracleJSSE)
          (2009-10-15T22:26:29.519-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) Ftp Adapter FTP1 SSLSocketFactory from context==>(com.sun.net.ssl.internal.ssl.SSLSocketFactoryImpl@9029c61)
          (2009-10-15T22:26:29.712-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) FTP Adapter FTP1 Reading reply from uat.dbdirectconnect.db.com
          (2009-10-15T22:26:29.945-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) FTP Adapter FTP1 Host uat.dbdirectconnect.db.com FTP command: AUTH TLS
          (2009-10-15T22:26:30.138-05:00) (soa_server1) (TRACE) () (oracle.soa.adapter) (tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@8a7706d) (userId: <anonymous>) (ecid: 0000IHRKGFOD4ia_dL7i6_1ApyBa00000C,0) (SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl) (APP: soa-infra) (SRC_METHOD: log) FTP Adapter FTP1 FTP Command: AUTH TLS, reply:((
          234 AUTH TLS OK.

          ))

          Edited by: tmcpheeters on Oct 16, 2009 9:50 AM
          • 2. Re: FTPS with Oracle SOA 11g FTP Adapter?
            user9285225
            Hi,

            Any pointers on how this issue got resolved?

            TIA