Re: [Virtuoso-users] Loading RDF into Virtuoso

2012-11-07 Thread Thomas Michaux
once you got a specific directory ID you can also list files in it using RES_NAME like '%' filename pattern matching : SQL> select RES_FULL_PATH, 'R', length (RES_CONTENT), RES_MOD_TIME, RES_ID, RES_PERMS, RES_GROUP, RES_OWNER, RES_CR_TIME, RES_TYPE, RES_NAM

Re: [Virtuoso-users] Loading RDF into Virtuoso

2012-11-07 Thread Thomas Michaux
Hello, for "HTTP/1.1 409 Conflict: can not create resource if a collection with same name exists (when WebDav checkbox is on and the physical path is set to the rdf_sink folder of a user) - Q: why is there a message that a collection already exists if there are no files in DAV directories and t

Re: [Virtuoso-users] Loading RDF into Virtuoso

2012-11-07 Thread Uldis Bojars
Thanks for posting configs. Indeed, the path was different (probably set when I was trying this and that to work around that HTTP error). I changed all settings to match your configs. Still getting "HTTP 409 Invalid path". I'm running Virtuoso on Ubuntu 12.04, installed via apt-get. Here's a list

Re: [Virtuoso-users] Loading RDF into Virtuoso

2012-10-22 Thread Uldis Bojars
Hi Hugh, > virtuoso-t -? Indeed, it is 6.1.4 bundled with Ubuntu: Virtuoso Open Source Edition (multi threaded) Version 6.1.4.3127-pthreads as of Feb 15 2012 Compiled for Linux (x86_64-pc-linux-gnu) Copyright (C) 1998-2011 OpenLink Software The reason I chose the apt-get version was to benefit

Re: [Virtuoso-users] Loading RDF into Virtuoso

2012-10-22 Thread David Brooks
Hi Uldis, On 22/10/12 9:28 PM, Uldis Bojars wrote: > On Mon, Oct 22, 2012 at 3:23 AM, Hugh Williams > wrote: >> That query format works for me also: >> >> $ curl -v -T example.rdf >> http://localhost:8890/sparql-graph-crud?graph-uri=http://test.org/my -u dba >> >> Can you please set the Virtuso

Re: [Virtuoso-users] Loading RDF into Virtuoso

2012-10-22 Thread Uldis Bojars
On Mon, Oct 22, 2012 at 3:23 AM, Hugh Williams wrote: > That query format works for me also: > > $ curl -v -T example.rdf > http://localhost:8890/sparql-graph-crud?graph-uri=http://test.org/my -u dba > > Can you please set the Virtusoso "CallstackOnException" option as detailed > in the followi

Re: [Virtuoso-users] Loading RDF into Virtuoso

2012-10-21 Thread Hugh Williams
Hi Uldis, That query format works for me also: $ curl -v -T example.rdf http://localhost:8890/sparql-graph-crud?graph-uri=http://test.org/my -u dba Enter host password for user 'dba': * About to connect() to localhost port 8890 (#0) * Trying ::1... Connection refused * Trying 127.0.0.1... co

Re: [Virtuoso-users] Loading RDF into Virtuoso

2012-10-21 Thread David Brooks
This all works for me curl -v -T t.rdf http://localhost:8890/sparql-graph-crud?graph-uri=http://test.org/my -u dba Enter host password for user 'dba': * About to connect() to localhost port 8890 (#0) * Trying 127.0.0.1... connected * Connected to localhost (127.0.0.1) port 8890 (#0) * Serve

Re: [Virtuoso-users] Loading RDF into Virtuoso

2012-10-21 Thread Uldis Bojars
HTTP PUT implies DELETE-ing the target graph before INSERT-ing new triples: http://www.w3.org/TR/sparql11-http-rdf-update/#http-put That must be why the error message mentioned deleting. However, that problem was solved (needed to configure authentication for the SPARQL endpoint). There is still

Re: [Virtuoso-users] Loading RDF into Virtuoso

2012-10-21 Thread David Brooks
Hmm, /sparql-graph-crud/ is for graph operations, so to delete a graph use the DELETE method, ie: curl -X DELETE http://localhost:8890/sparql-graph-crud?graph-uri=http://test.org/my To delete a statement from a graph use the /sparql/ endpoint and SPARQL Update operations (http://www.w3.org/TR

Re: [Virtuoso-users] Loading RDF into Virtuoso

2012-10-21 Thread Uldis Bojars
On Sun, Oct 21, 2012 at 10:30 PM, Uldis Bojars wrote: > Unfortunately the problem remains -- HTTP PUT to the SPARQL endpoint > returns the same error message: "SQ110: Permission denied for delete > from DB.DBA.RDF_QUAD". > > Command: > curl -v -T myfoaf.rdf > http://localhost:8890/sparql-graph-cru

Re: [Virtuoso-users] Loading RDF into Virtuoso

2012-10-21 Thread Uldis Bojars
> (1) how to grant SPARQL_UPDATE role to a user; Found out how to assign roles via the Conductor web UI (User Accounts -> Roles) and assigned SPARQL_UPDATE role to the DBA user. Unfortunately the problem remains -- HTTP PUT to the SPARQL endpoint returns the same error message: "SQ110: Permissio

Re: [Virtuoso-users] Loading RDF into Virtuoso

2012-10-21 Thread Uldis Bojars
Thanks, http://localhost:8890/sparql-graph-crud/ is just what was needed. I ran into a permissions issue, though ("SQ110: Permission denied for delete from DB.DBA.RDF_QUAD"), which is expected. Could you suggest: (1) how to grant SPARQL_UPDATE role to a user; (2) what authentication method to u

Re: [Virtuoso-users] Loading RDF into Virtuoso

2012-10-19 Thread David Brooks
I suggest using the SPARQL graph endpoint at http://localhost:8890/sparql-graph-crud/ along with libcurl (or equivalent) in your application. Use POST to extend an existing graph, PUT to replace a graph, and DELETE to remove one, specifying the graph via a parameter of 'graph_uri' (e.g. POST

[Virtuoso-users] Loading RDF into Virtuoso

2012-10-19 Thread Uldis Bojars
Hi, What is the best way for inserting RDF/XML data into Virtuoso (Open Source edition) if the following conditions are true: - data to be loaded is generated by the application (=it is not a file on a filesystem) - data needs to be loaded into a named graph G -- if G already has some data,