Hi Roland,

By sparql interface, I assume you mean the Virtuoso default /sparql endpoint ? 
I tried this myself on my test instance and can query the same data from my 
/sparql endpoint as I can from isql.

What happens if you query via the /sparql-auth  protected default endpoint and 
authenticate as the “dba” user can you then query the graphgroup and get 
results ?

What is the complete sequence of command that have been run against you 
Virtuoso instance to setup the graph group test ?

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.      //              http://www.openlinksw.com/ 
<http://www.openlinksw.com/>
Weblog   -- http://www.openlinksw.com/blogs/ <http://www.openlinksw.com/blogs/>
LinkedIn -- http://www.linkedin.com/company/openlink-software/ 
<http://www.linkedin.com/company/openlink-software/>
Twitter  -- http://twitter.com/OpenLink <http://twitter.com/OpenLink>
Google+  -- http://plus.google.com/100570109519069333827/ 
<http://plus.google.com/100570109519069333827/>
Facebook -- http://www.facebook.com/OpenLinkSoftware 
<http://www.facebook.com/OpenLinkSoftware>
Universal Data Access, Integration, and Management Technology Providers



> On 23 Jun 2017, at 15:01, Roland Cornelissen <metamatter...@gmail.com 
> <mailto:metamatter...@gmail.com>> wrote:
> 
> Hi Hugh,
> 
> Thanks for the reply, as always!
> 
> When I run the query as dba through isg I get results as expected. The query 
> mentioned below was run through the sparql endpoint. So I guess this is an 
> access/rights issue. I expected the graph and the graphgroup to be accessible 
> after opening those up for public access, as in:
> 
>  DB.DBA.RDF_GRAPH_USER_PERMS_SET ('graphgroup', 'nobody', 1);
>  DB.DBA.RDF_GRAPH_USER_PERMS_SET ('graph', 'nobody', 1);
> So, in isql I get results, through the sparql interface none. (?) I don' t 
> understand why.
> Thanks,
> 
> Roland
> 
> 
> On 23-06-17 01:52, Hugh Williams wrote:
>> Hi Roland,
>> 
>> This works for me:
>> 
>> SQL> SPARQL INSERT INTO GRAPH <http://example.org <http://example.org/>> { 
>> <1> <2> <3> };
>> 
>> Done. -- 4 msec.
>> SQL> DB.DBA.RDF_GRAPH_GROUP_CREATE ('graphgroup', 0);
>> 
>> Done. -- 1 msec.
>> SQL> DB.DBA.RDF_GRAPH_GROUP_INS ('graphgroup','http://example.org' 
>> <http://example.org%27/>);
>> 
>> Done. -- 2 msec.
>> SQL> SPARQL SELECT * FROM <graphgroup> where {?s ?p ?o};
>> s                                                                            
>>      p                                                                       
>>           o
>> LONG VARCHAR                                                                 
>>      LONG VARCHAR                                                            
>>           LONG VARCHAR
>> _______________________________________________________________________________
>> 
>> 1                                                                            
>>      2                                                                       
>>           3
>> 
>> 1 Rows. -- 253 msec.
>> SQL>
>> 
>> Please provide steps to reproduce your issue preferably via isql so all 
>> steps and results can clearly be seen ...
>> 
>> What user are you connecting with, as typically graph groups are used to 
>> control access to specific user or groups of users as in the example at:
>> 
>>      http://vos.openlinksw.com/owiki/wiki/VOS/VirtRDFGraphsSecurity 
>> <http://vos.openlinksw.com/owiki/wiki/VOS/VirtRDFGraphsSecurity>
>> 
>> and permissions need to be accessed to the specific user for accessing the 
>> graph group which is not indicate in your mail to have been done, thus I 
>> assume you are connecting as the default “dba” or sparql user ?
>> 
>> Best Regards
>> Hugh Williams
>> Professional Services
>> OpenLink Software, Inc.      //              http://www.openlinksw.com/ 
>> <http://www.openlinksw.com/>
>> Weblog   -- http://www.openlinksw.com/blogs/ 
>> <http://www.openlinksw.com/blogs/>
>> LinkedIn -- http://www.linkedin.com/company/openlink-software/ 
>> <http://www.linkedin.com/company/openlink-software/>
>> Twitter  -- http://twitter.com/OpenLink <http://twitter.com/OpenLink>
>> Google+  -- http://plus.google.com/100570109519069333827/ 
>> <http://plus.google.com/100570109519069333827/>
>> Facebook -- http://www.facebook.com/OpenLinkSoftware 
>> <http://www.facebook.com/OpenLinkSoftware>
>> Universal Data Access, Integration, and Management Technology Providers
>> 
>> 
>> 
>>> On 21 Jun 2017, at 16:02, Roland Cornelissen <metamatter...@gmail.com 
>>> <mailto:metamatter...@gmail.com>> wrote:
>>> 
>>> Hi,
>>> 
>>> I created a graph group [1] and added a graph [2]. Now when I query [3] the 
>>> graph group I get no results. The individual graph however does produce 
>>> results.
>>> 
>>> I am missing something here but I don't understand what it is; What is 
>>> going wrong here?
>>> 
>>> Thanks,
>>> 
>>> Roland
>>> 
>>> [1] DB.DBA.RDF_GRAPH_GROUP_CREATE ('graphgroup', 0);
>>> [2] DB.DBA.RDF_GRAPH_GROUP_INS ('graphgroup','graph');
>>> [3] select distinct ?Concept 
>>> from <graphgroup>
>>> where {[] a ?Concept} LIMIT 100
>>> 
>>> 
>>> 
>>> ------------------------------------------------------------------------------
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org <http://slashdot.org/>! 
>>> http://sdm.link/slashdot_______________________________________________ 
>>> <http://sdm.link/slashdot_______________________________________________>
>>> Virtuoso-users mailing list
>>> Virtuoso-users@lists.sourceforge.net 
>>> <mailto:Virtuoso-users@lists.sourceforge.net>
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users 
>>> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users>
>> 
> 

Attachment: smime.p7s
Description: S/MIME cryptographic signature

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to