Re: [Virtuoso-users] graph group access

[Hugh Williams]

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/ 

Weblog   -- http://www.openlinksw.com/blogs/ 
LinkedIn -- http://www.linkedin.com/company/openlink-software/ 

Twitter  -- http://twitter.com/OpenLink 
Google+  -- http://plus.google.com/100570109519069333827/ 

Facebook -- http://www.facebook.com/OpenLinkSoftware 

Universal Data Access, Integration, and Management Technology Providers



> On 23 Jun 2017, at 15:01, Roland Cornelissen  > 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 > { 
>> <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' 
>> );
>> 
>> Done. -- 2 msec.
>> SQL> SPARQL SELECT * FROM  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 
>> 
>> 
>> 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/ 
>> 
>> Weblog   -- http://www.openlinksw.com/blogs/ 
>> 
>> LinkedIn -- http://www.linkedin.com/company/openlink-software/ 
>> 
>> Twitter  -- http://twitter.com/OpenLink 
>> Google+  -- http://plus.google.com/100570109519069333827/ 
>> 
>> Facebook -- http://www.facebook.com/OpenLinkSoftware 
>> 
>> Universal Data Access, Integration, and Management Technology Providers
>> 
>> 
>> 
>>> On 21 Jun 2017, at 16:02, Roland Cornelissen >> > 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 
>>>

Re: [Virtuoso-users] graph group access

[Hugh Williams]

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/ 

Weblog   -- http://www.openlinksw.com/blogs/ 
LinkedIn -- http://www.linkedin.com/company/openlink-software/ 

Twitter  -- http://twitter.com/OpenLink 
Google+  -- http://plus.google.com/100570109519069333827/ 

Facebook -- http://www.facebook.com/OpenLinkSoftware 

Universal Data Access, Integration, and Management Technology Providers



> On 23 Jun 2017, at 15:01, Roland Cornelissen  > 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 > { 
>> <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' 
>> );
>> 
>> Done. -- 2 msec.
>> SQL> SPARQL SELECT * FROM  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 
>> 
>> 
>> 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/ 
>> 
>> Weblog   -- http://www.openlinksw.com/blogs/ 
>> 
>> LinkedIn -- http://www.linkedin.com/company/openlink-software/ 
>> 
>> Twitter  -- http://twitter.com/OpenLink 
>> Google+  -- http://plus.google.com/100570109519069333827/ 
>> 
>> Facebook -- http://www.facebook.com/OpenLinkSoftware 
>> 
>> Universal Data Access, Integration, and Management Technology Providers
>> 
>> 
>> 
>>> On 21 Jun 2017, at 16:02, Roland Cornelissen >> > 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 
>>> 

Re: [Virtuoso-users] graph group access

[Hugh Williams]

Hi Roland,

This works for me:

SQL> SPARQL INSERT INTO GRAPH  { <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');

Done. -- 2 msec.
SQL> SPARQL SELECT * FROM  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

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/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers



> On 21 Jun 2017, at 16:02, Roland Cornelissen  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 
> where {[] a ?Concept} LIMIT 100
> 
> 
> 
> 
> 
> --
> 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 
> 



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