search

tetherless-world / opendap

Provenance trace and pingback services for OPeNDAP using Prizms.
http://opendap.tw.rpi.edu
1 stars 1 forks source link

Publishing to Virtuoso #69

Open MichaelisJamesR opened 10 years ago

MichaelisJamesR commented 10 years ago

I'm currently trying to publish some data updates to Virtuoso using Prizms. Here are some of the variables given back by cr-vars.sh:

CSV2RDF4LOD_PUBLISH_VIRTUOSO true CSV2RDF4LOD_PUBLISH_VIRTUOSO_HOME /opt/virtuoso CSV2RDF4LOD_CONVERT_DATA_ROOT (not required; but avoids a file copy if set) CSV2RDF4LOD_PUBLISH_VIRTUOSO_ISQL_PATH /opt/virtuoso/bin/isql CSV2RDF4LOD_PUBLISH_VIRTUOSO_PORT #### CSV2RDF4LOD_PUBLISH_VIRTUOSO_USERNAME ### CSV2RDF4LOD_PUBLISH_VIRTUOSO_PASSWORD ### CSV2RDF4LOD_PUBLISH_VIRTUOSO_INI_PATH (will default to: /opt/virtuoso/var/lib/virtuoso/db/virtuoso.ini) CSV2RDF4LOD_PUBLISH_VIRTUOSO_SCRIPT_PATH /opt/virtuoso/scripts/vload CSV2RDF4LOD_PUBLISH_VIRTUOSO_SPARQL_ENDPOINT http://logd.tw.rpi.edu/sparql

However, it looks like we don't have a virtuoso installation under /opt/virtuoso. What values should be used for each of the above variables to publish to OPeNDAP's Virtuoso installation?

timrdf commented 10 years ago

You should only publish as the opendap user, these look like your developer params. Also, best not to broadcast your user/pass onto GitHub...

MichaelisJamesR commented 10 years ago

Thanks for catching that. Username and password commented out.

Previously, I was using the OpenDap login to retrieve and publish the new module listings. However, the new data still doesn't appear to be in Virtuoso. I ran cr-retrieve.sh, followed by a publish.sh script in the retrieved data directory. Below are the outputs for both scripts:

https://github.com/tetherless-world/opendap/blob/master/dataone/logs/7-17_cr-retrieve_log.txt

https://github.com/tetherless-world/opendap/blob/master/dataone/logs/7-17_publish_log.txt

timrdf commented 10 years ago

Peeking into the VM and clearing some of my cobwebs, I actually don't know why the OpenDap user exists. Didn't you create that? Unless you have a particular reason for using it, I'd get rid of it. The "prizms" user is the production user. So, no need for OpenDap w.r.t using Prizms.