Problems running import scripts and executing sparql queries on local WSD - Wikibase Community User Group

3 Aug 2024


      Hello,
I recently installed WSD 3.0 locally on my Mac following the instructions on the github page. I created the wikibase using the default values for the domain names ('wikibase.example.com' etc. ) and admin user/password. I created an OAuth 1 consumer and then tried importing items and properties using a WikibaseIntegrator script which has worked in past versions of Wikibase (both on wikibase cloud and locally on my machine). However this generates an error indicating the SSL certificate is not verified:
"Backing off 1.0 seconds afters 1 tries calling function with args (<wikibaseintegrator.wbi_login.OAuth1 object at 0x104bfeda0>,) and kwargs {'session': <requests_oauthlib.oauth1_session.OAuth1Session object at 0x104bfeec0>, 'token_renew_period': 1800, 'user_agent': None, 'mediawiki_api_url': None} 
...
File "/Users/matthewong/miniforge3/lib/python3.10/ssl.py", line 1342, in do_handshake
    self._sslobj.do_handshake()
ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate (_ssl.c:997)"
The github documentation (under FAQ/Can I host Wikibase Suite locally?) does indicate running WSD locally can create problems for SSL verification when running quickstatements or accessing the wikibase on a browser for the first time. But it doesn't say what to do about other situations involving certificate validation, like the one I indicated above). Does anyone know how to solve this issue?
It may be related that when I try to execute sparql queries using the wdqs-frontend I get a server error:
SELECT ?x ?y ?z WHERE {
  ?x ?y ?z .
  }
Servor Error
<html>
<head><title>502 Bad Gateway</title></head>
<body>
<center><h1>502 Bad Gateway</h1></center>
<hr><center>nginx/1.27.0</center>
</body>
</html>
<!-- a padding to disable MSIE and Chrome friendly error page -->
<!-- a padding to disable MSIE and Chrome friendly error page -->
...