Unable to connect to messaging.easylink.com through Oracle: certificate problem...

jcspitz

Hello,

as written in the subject,

I try to request WebService "'https://messaging.easylink.com/soap/sync'" from a Linux host (not my own worstation)

using Oracle Package "UTL_HTTP" functionnalities.

Here my Environnment:

OS: Linux RedHat 6.4 x86_64

Oracle: 11gR2 Standart Edition 11.2.0.3

I install in a defined Oracle wallet on the host

the needed certificates "root" & "intermediate"...

But perhaps, some of them are not good or are missing...

Here see the "orapki" Oracle Command Output

Input:

orapki wallet display -wallet /oracle/admin/TPHGCHW1/wallet  -pwd WalletPasswd123

Output:
Oracle PKI Tool : Version 11.2.0.3.0 - Production
Copyright (c) 2004, 2011, Oracle and/or its affiliates. All rights reserved.

Requested Certificates:
User Certificates:
Trusted Certificates:
Subject:        CN=messaging.easylink.com,OU=Unified Communications,OU=Hosted by Open Text Corporation,OU=Cloud Services,O=Open Text Corporation,S              TREET=275 Frank Tompa,L=Waterloo,ST=Ontario,2.5.4.17=N2L 0A1,C=CA
Subject:        CN=COMODO RSA Domain Validation Secure Server CA,O=COMODO CA Limited,L=Salford,ST=Greater Manchester,C=GB
Subject:        CN=COMODO SHA-256 Domain Validation Secure Server CA,O=COMODO CA Limited,L=Salford,ST=Greater Manchester,C=GB
Subject:        CN=COMODO RSA Organization Validation Secure Server CA,O=COMODO CA Limited,L=Salford,ST=Greater Manchester,C=GB
Subject:        CN=COMODO RSA Certification Authority,O=COMODO CA Limited,L=Salford,ST=Greater Manchester,C=GB
Subject:        CN=COMODO RSA Extended Validation Secure Server CA,O=COMODO CA Limited,L=Salford,ST=Greater Manchester,C=GB
Subject:        CN=COMODO SHA-256 Organization Validation Secure Server CA,O=COMODO CA Limited,L=Salford,ST=Greater Manchester,C=GB
Subject:        CN=COMODO SHA-256 Extended Validation Secure Server CA,O=COMODO CA Limited,L=Salford,ST=Greater Manchester,C=GB
 
then
connected with SQLPLUS as sysdba on the Oracle Instance
trying to run the following Input,

Input:
declare
req utl_http.req;
resp utl_http.resp;
data varchar2(32767);
begin
    utl_http.set_wallet('file:' || '/oracle/admin/TPHGCHW1/wallet', 'WalletPasswd123');
    utl_http.Set_Proxy (
   proxy => '<proxy_host>.fmlogistic.fr:8080',
   no_proxy_domains => 'fmlogistic.fr' );

    req := utl_http.begin_request('https://messaging.easylink.com/soap/sync', 'POST',' HTTP/1.1');
    utl_http.set_header(req, 'User-Agent', 'Mozilla/4.0');
    resp := utl_http.get_response(req);
    loop
      begin
        data := null;
        utl_http.read_line(resp, data, TRUE);
        -- process your data here
        exception when others then exit;
      end;
    end loop;
    utl_http.end_response(resp);
end;
/

I get the following error Output:

Output:
declare
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-29024: Certificate validation failure
ORA-06512: at line 11

Can you, please, give some suggestions to resolve this problem ?

Perhaps I don't have the correct "EasyLink" certificate...???

Can you, please, perhaps send it to me ?

Thank you in advance.

Best regards.

JC

thuneke

Not sure what you are trying to do. You are not making an API Request and you are not using API credentials. Are you working with a Sales Person or a PreSales Engineer?