Unable to connect to messaging.easylink.com through Oracle: certificate problem...
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
Comments
Categories
- All Categories
- 111 Developer Announcements
- 49 Articles
- 103 General Questions
- 123 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 123 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 1 XM Fax