[Virtuoso-users] Virtuoso and spatial extensions / spatial support

2009-02-10 Thread Ceriel Jacobs
After Postgresql, the Mysql database server has support for spatial extensions since version 5.1 [1], by implementing a subset of the SQL with Geometry Types environment proposed by OGC. [2] Information about spatial features within Virtuoso could not be found at openlinksw.com, that why th

Re: [Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

2009-02-10 Thread Rumi Tsekova
Bob, There should be a graph with IRI: http://localhost:8890/DAV/home/user3/rdf_sink/ in the Quad Store. Thus you can get the data from the uploaded file with the following query: select distinct * from where {?s ?p ?o} You can execute it fro

Re: [Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

2009-02-10 Thread Kingsley Idehen
Bob DuCharme wrote: Hi Kingsley, Where is the FROM in the SPARQL? I didn't know it was required. Issuing the query at http://localhost:8890/sparql with no FROM does return some data, so I assumed that there was some default scope for the query, and that for user3 it would be any data acce

Re: [Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

2009-02-10 Thread Bob DuCharme
Thanks, much less confusing now! (as opposed to "much less confusing not") Aldo Bucchi wrote: not -> now? On Tue, Feb 10, 2009 at 1:57 PM, Bob DuCharme wrote: Hi Kingsley, Where is the FROM in the SPARQL? I didn't know it was required. Issuing the query at http://localhost:

Re: [Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

2009-02-10 Thread Aldo Bucchi
not -> now? On Tue, Feb 10, 2009 at 1:57 PM, Bob DuCharme wrote: > Hi Kingsley, > >>Where is the FROM in the SPARQL? > > I didn't know it was required. Issuing the query at > http://localhost:8890/sparql with no FROM does return some data, so I > assumed that there was some default scope for t

Re: [Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

2009-02-10 Thread Bob DuCharme
Hi Kingsley, Where is the FROM in the SPARQL? I didn't know it was required. Issuing the query at http://localhost:8890/sparql with no FROM does return some data, so I assumed that there was some default scope for the query, and that for user3 it would be any data accessible by that user. A

Re: [Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

2009-02-10 Thread Kingsley Idehen
Bob DuCharme wrote: Thanks Rumi, that worked! Before, I hadn't checked "Allow SQL/ODBC Logins,"and I thought /DAV/home// was a default value for "DAV Home Path" and didn't realize what I was supposed to do with it--I guess I assumed that a home/username directory would be created based on the

Re: [Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

2009-02-10 Thread Bob DuCharme
Thanks Rumi, that worked! Before, I hadn't checked "Allow SQL/ODBC Logins,"and I thought /DAV/home// was a default value for "DAV Home Path" and didn't realize what I was supposed to do with it--I guess I assumed that a home/username directory would be created based on the login ID name, and I

Re: [Virtuoso-users] inference context error

2009-02-10 Thread Aldo Bucchi
Rumi, Seeing an explicit ":80" flying around makes me wonder if there is a configuration step missing during installation, or perhaps further clarification ( for example, make sure to set A, B, C ). Specially if this results in unexpected behavior further down the road. We have not done anything

Re: [Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

2009-02-10 Thread Rumi Tsekova
Hi Bob, > > >Thanks Hugh! > >Any suggestions about point 2? Here is what I performed locally on winxp installation: 1. Go to Conductor and click "Create New Account" 2. Enter account name: user11 and also enter pwd, for ex.: 1 3. Check "User Enabled" and "Allow SQL/ODBC Logins" 4. Add roles SP

Re: [Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

2009-02-10 Thread Bob DuCharme
I tried again with "Allow DAV Logins" checked, and for good measure I added SPARQL_SELECT, SPARQL_UPDATE, and SPARQL_SPONGE to the list of Selected Account Roles. (Whenever I add "SPARQL_SPONGE it tells me that SPARQL_SPONGE is already assigned, even when I don't see it in the list of assigned

Re: [Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

2009-02-10 Thread Hugh Williams
Hi Bob, For point 2 when you created the new user account was this a DAV enabled account which is required for the data insertion. Their is an option in the conductor to enable DAV logins when you create a new account. Best Regards Hugh Williams Professional Services OpenLink Software Web

Re: [Virtuoso-users] inference context error

2009-02-10 Thread Rumi Tsekova
Hi Cristian, Could you please check: 1. in virtuoso ini file what is the value of the URIQA - DefaultHost * if the htttp is on port 80, then this port you must not use in the default host, as cname in this case is without the port. 2. You can check what returns this: sparql select count(*)

Re: [Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

2009-02-10 Thread Bob DuCharme
Thanks Hugh! Any suggestions about point 2? Bob Hugh Williams wrote: Hi Bob, The problem in point 1 is a known issue, which will be fixed in the next VOS release. A work around in the meantime is a run the following commands to grant the necessary execute permissions on the procedure: gra

Re: [Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

2009-02-10 Thread Hugh Williams
Hi Bob, The problem in point 1 is a known issue, which will be fixed in the next VOS release. A work around in the meantime is a run the following commands to grant the necessary execute permissions on the procedure: grant execute on SPARQL_INSERT_DICT_CONTENT to "SPARQL"

[Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

2009-02-10 Thread Bob DuCharme
I'm not having much luck with the RDF insertion methods that I've tried from at http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFInsert. I'm using Windows XP. 1. In the "SPARQL Insert via /sparql endpoint" section, the INSERT query in step 1 did not work at http://localhost:8890/