I need to get UN Blacklist XML periodically, same as Kumar back in 2009, however since 2015-10-14 UN website requires a certificate so if I use function proposed by Dmitri and used by Thomas Duemesnil:
I get the following error:
And if I specify certificate like this:
where instead of
Log file says this:
In version 22.214.171.1247 I get this error:
And the log file looks almost same:
I also tried to provide certificate as a file as suggested by Jeff Albion like:
Same result in both SA 12 and SA 16, with all 3 certificates I found on UN page.
I feel ashamed, I had almost exact same problem a while ago while trying to solve another problem - SOAP Error, Response truncated to 1024 characters. That was a SQL Anywhere bug, if was fixed, but there I found out that since version 126.96.36.19994 they switched from Certicom to OpenSSL (What impact will the switch to OpenSSL have on SQL Anywhere strong encryption?) and now I need a root certificate for TLS handshake to succeeded, so after some googling I found the root certificate of COMODO (there is a list of them available at their knowledge base) and now everything works!
answered 29 Oct '15, 08:32