Hi All,

SQL Anywhere server 12.0.1. There is a third-party (external) web service that is called via the https protocol https://xxx.xxx.xxx.xxx/Test

To begin with, I am making a simpler version - nttp

CREATE PROCEDURE "DBA"."WebTest2"(in nID integer ,in cDocDate char(10)) 
result (cAttribute long varchar, cValue long varchar) 
dynamic result sets 1
url 'http://xxx.xxx.xxx.xxx/Test?pID=!nID&pDocDate=!cDocDate' 
type 'HTTP:POST'

Here everything is working fine.

Now I need to call this service using the https protocol.

As for https - there is a keyword CERTIFICATE, it can specify a file with a certificate or a certificate key. But https://xxx.xxx.xxx.xxx/Test is a third-party web-service and I accordingly do not have its file with the certificate or the key of its certificate.

Question: What should I do ?

asked 28 Sep '17, 14:03

Stalker's gravatar image

Stalker
460283045
accept rate: 11%


See that question, it applies to the newer 12.0.1 EBFs, as well, starting with 12.0.1.3994, IIRC.

In short: You need to trust the root certificate of the web server's certificate chain.

permanent link

answered 28 Sep '17, 17:00

Volker%20Barth's gravatar image

Volker Barth
39.8k358546815
accept rate: 34%

edited 28 Sep '17, 17:04

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×438
×62

question asked: 28 Sep '17, 14:03

question was seen: 2,011 times

last updated: 28 Sep '17, 17:04