Re: [Virtuoso-users] vhost_define vsp_user and real user

2015-02-06 Thread Gang Fu
Hi Rumi, I totally understand your point. My quesiton is about the 'vsp_user' or called 'vsp_host' used to expose the sparql endpoint. Our system security team has concern about the 'vsp_user', they are not sure what is used for, and how to configure it. Basically, they are not familiar with

Re: [Virtuoso-users] vhost_define vsp_user and real user

2015-02-06 Thread Rumi
Hi Gang Fu, On 06-Feb-15 4:29 PM, Gang Fu wrote: Hi Rumi, I totally understand your point. My quesiton is about the 'vsp_user' or called 'vsp_host' used to expose the sparql endpoint. Our system security team has concern about the 'vsp_user', they are not sure what is used for, and how

Re: [Virtuoso-users] vhost_define vsp_user and real user

2015-02-05 Thread Gang Fu
Hi Rumi, Using vhost_define() through isql we can achieve the same thing: DB.DBA.VHOST_DEFINE ( lhost=ip:port, vhost=name, lpath='/sparql', ppath='/!sparql/', is_dav=1, vsp_user='dba', ses_vars=0, sec='digest', auth_fn='DB.DBA.HP_AUTH_SPARQL_USER', realm='SPARQL',

Re: [Virtuoso-users] vhost_define vsp_user and real user

2015-02-05 Thread Rumi
Hi Gang Fu, On 05-Feb-15 3:03 PM, Gang Fu wrote: Hi Rumi, Using vhost_define() through isql we can achieve the same thing: DB.DBA.VHOST_DEFINE ( lhost=ip:port, vhost=name, lpath='/sparql', ppath='/!sparql/', is_dav=1, vsp_user='dba', ses_vars=0, sec='digest',

Re: [Virtuoso-users] vhost_define vsp_user and real user

2015-02-03 Thread Gang Fu
Hi Rumi, I have also tried: grant execute on DB.DBA.SPARUL_LOAD_SERVICE_DATA to SPARQL; but still, user SPARQL cannot be used as vsp_user to expose a sparql endpoint, I got: 404 page not found Resource /sparql not found.Access to page is forbidden Best, Gang On Tue, Feb 3, 2015 at 8:10 AM,

Re: [Virtuoso-users] vhost_define vsp_user and real user

2015-02-03 Thread Gang Fu
Hi Rumi, I looked at the source code of libsrc/Wi/sparql_io.sql for procedure WS.WS ./!sparql/: create procedure WS.WS./!sparql/ (inout path varchar, inout params any, inout lines any) I am not sure whether the user as SPARQL for /sparql endpoint are set by default here: user_id :=

[Virtuoso-users] vhost_define vsp_user and real user

2015-02-03 Thread Gang Fu
Hi, I am using function vhost_define() to expose read-only sparql endpoint through another port (different from 8890) for security concern. I have two questions: 1) how can I expose a sparql endpoint using account other than 'dba'. I have tried to using vsp_user='SPARQL', but I got '404 cannot

Re: [Virtuoso-users] vhost_define vsp_user and real user

2015-02-03 Thread Rumi
Hi Gang Fu, On 03-Feb-15 3:47 PM, Gang Fu wrote: Hi Rumi, I looked at the source code of libsrc/Wi/sparql_io.sql for procedure WS.WS http://WS.WS./!sparql/: create procedure WS.WS./!sparql/(inout pathvarchar, inout params any, inout lines any) I am not sure whether the user as SPARQL for

Re: [Virtuoso-users] vhost_define vsp_user and real user

2015-02-03 Thread Gang Fu
Hi Rumi, I have tried to expose a password-protected sparql endpoint, actually it can be done using vhost_define() function as well, just add sec='digest' and authentication function. But the vsp_user to expose a password-protected sparql endpoint is still dba. Best, Gang On Tue, Feb 3, 2015 at