Set https proxy

[Sofia Gori]

Hi Statalisters,

I have some problems at importing data directly from internet.
I am using Stata in my company laptop, and I need to set up a proxy to avoid the company firewall. Therefore, I set the http proxy via netio:

set httpproxyhost my_proxy_host
set httpproxyport my_port
set httpproxyuser my_username
set httpproxypw   my_password
set httpproxy on
set httpproxyauth on

The proxy is correctly set. Nonetheless, I have problems at importing data from https URLs.

For instance, this code works fine:

import delimited http://www.stata.com/examples/auto.csv, clear

Whereas the following lines of code do not work:

import delimited https://covid.ourworldindata.org/data/owid-covid-data.csv, clear
import delimited https://raw.githubusercontent.com/owid/covid-19-data/master/public/data/owid-covid-data.csv, clear

PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
could not open url
r(603)

I guess I need to set also a proxy for https website.
Do you know how to set an https proxy, or a workaround to solve this issue? I looked for a solution in help netio but I could not find anything.

My version of Stata is

. about
Stata/MP 16.0 for Windows (64-bit x86-64)
Revision 16 Oct 2019

Thanks in advance for your help!

[Federico Tedeschi]

Hi. I've had a similar issue: error "r(675)" ("server reported server error") when trying to update Stata both on my personal laptop yesterday and on my office pc today. A look at "netio" led me to type "set httpproxy on", that only made things worse, changing the error from "r(675)" to "r(660)" ("proxy server incorrectly specified"). I found the solution here: https://www.stata.com/support/updates/ , i.e. downloading the "zip" file somewhere, then unzipping, locating the "stata.upd" file somewhere and following the recommendation: "Type db update in Stata and browse to the extracted update directory. Click OK and follow any instructions you are given", selecting the path leading to the folder including "stata.upd".