Data status

TREASURE Workspace
4

Hello @pykoe. Graphryder is made of three parts:

  • Graphryder import script exports data from a Discourse & OpenEthnographer postgresql database and builds a Neo4j graph database from that data.
  • Graphryder Neo4j database is the data layer of Graphryder.
  • Graphryder GraphQL API and dashboard are deployed together in a Docker container and are how the end user interacts with the network graphs.

It looks like the first part is the one that is glitching. I imagine this is yet another consequence of the major update that Matthias and Daniel did to Discourse a while back, which entailed moving the platform to a new and more modern server.

The documentation is here and the Github repo is here. Somebody that understands the update made to the Discourse installation should be able to alter the code so that it works again. It could also be something super simple, like the cron job that automatically imports the script got stuck: for people who know how to use the command line, section 2.6 of the documentation explain where to find that script.

The bad news is this: my Python scripts also no longer work. They hit into a problem I have not seen before, that seems pretty low level:

>>> responses = requests.Session()
>>> responses.headers.update({"Api-Key": API_key})
>>> call = 'https://edgeryders.eu/annotator/projects/55/codes.json'
>>> response = responses.get(call).json()
Traceback (most recent call last):
  File "/Users/albertocottica/Library/Python/3.9/lib/python/site-packages/urllib3/connectionpool.py", line 688, in urlopen
    conn = self._get_conn(timeout=pool_timeout)
  File "/Users/albertocottica/Library/Python/3.9/lib/python/site-packages/urllib3/connectionpool.py", line 280, in _get_conn
    return conn or self._new_conn()
  File "/Users/albertocottica/Library/Python/3.9/lib/python/site-packages/urllib3/connectionpool.py", line 979, in _new_conn
    raise SSLError(
urllib3.exceptions.SSLError: Can't connect to HTTPS URL because the SSL module is not available.

SSL is a (legacy) encryption-based Internet protocol (see). I will ask for help to @bpinaud, again! Bruno, can you help me here? I’ll be in touch separately.

The good news is that the APIs work when queried via browser. If you are Open-Ethnographer enabled, you can put a query in the browser’s bar and get a JSON. For example, this works for me:

https://edgeryders.eu/annotator/projects/55/codes.json

So, solutions:

  1. @daniel, could you please look into the server and try restarting the cron job that imports data into GraphRyder’s database? The instructions are in section 2.6 of this manual.
  2. Maybe Bruno can get me unstuck on the Python script. This won’t restart Graphryder, but it will allow to build Tulip graphs from Edgeryders’s APIs.
2 Likes