I have a function that automatically fetches the ECB exchange rates. In version 17.0.8, the data collection still worked. The data collection no longer works in version 17.0.10. The following error message is displayed:

The secure connection to the remote host failed. The connection was closed from the other side.
SQLCode=-990, ODBC 3 Stat=“HY000“

create function EZB_WAEHRUNGSKURSE()
returns xml
url 'https://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist-90d.xml' 
type 'HTTP:GET' 
CERTIFICATE 'file=*'

Does anyone knows a solution for this problem?

asked 16 Jan, 02:41

Till's gravatar image

Till
26113
accept rate: 0%

edited 16 Jan, 03:15

Volker%20Barth's gravatar image

Volker Barth
36.3k343504753

See that yet unanswered FAQ - with v17.0.10 a new basic crypto library has been introduced. What happens when you explicitly provide the root certificate of the according web service instead of using the 'file=*' placeholder?

(16 Jan, 03:17) Volker Barth

It doesn't work either. I have tried the Path to the Certificate. I have stored the Certificate in the DB. Always the Same error.

(16 Jan, 06:03) Till
Replies hidden

Hm, it fails for me, as well, with 17.0.10.5963, although I added the whole ECB certificate chain to the database... With v16, it works fine.

A very wild guess: Although v17.0.10 does no longer use OpenSSL, you might use its client to check for any issues, or possibly web client request logging (aka CALL sa_server_option('WebClientLogging', 'ON')) might help...

(16 Jan, 06:30) Volker Barth

Thank you for your hint. I create for each version a looginng file. I compared both logging files, they are almost the same. The only differnces is that the version 17.0.10 does not contain "socket closed by peer".

(16 Jan, 08:42) Till
Be the first one to answer this question!
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:

×168
×41
×21

question asked: 16 Jan, 02:41

question was seen: 408 times

last updated: 16 Jan, 08:42