Accessing the Virtuoso SPARQL Endpoint - DDMAL/linkedmusic-datalake GitHub Wiki

There are two ways to access the Virtuoso SPARQL endpoint. The first is through the browser at https://virtuoso.simssa.ca/sparql/. Use https://virtuoso.staging.simssa.ca/sparql/ for staging. The second way is through the command line.

1. SSH into Virtuoso

2. Verify Docker permissions

You will need a Virtuoso account with dba permissions to access the isql shell. The credentials here are the same as what you use for Virtuoso Conductor on the web. Contact Liam, Dylan, or Hanwen for access or to make a new account. You will also need to be added to the Docker group. Verify you have the correct Docker permissions by running docker ps.

Reach out to the Virtuoso admin (Liam) and give him your username. This is the same username you use to SSH into the server. Alternatively, a system admin (Hanwen, Dylan) can add you using the following commands:

sudo usermod -aG docker <USERNAME>
sudo usermod -aG virtuoso-users <USERNAME>

3. Enter the isql shell

Run the following command:

docker exec -it my_virtdb isql 1111 <DBA_USERNAME>

Then enter your password.

4. Test SPARQL Query

You should now be able to run SPARQL queries! Test with something like the following:

SPARQL # Remember to specify that you are writing a SPARQL command
  SELECT (COUNT(*) AS ?diammCount)
    WHERE { GRAPH <https://linkedmusic.ca/graphs/diamm/> { ?s ?p ?o } }; # Remember to close with ;