You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jena.apache.org by Steven Blanchard <st...@microbiome.studio> on 2023/01/06 16:30:51 UTC

Use rsparl to request a spaql database with login/password authentication

Hello Jena Team,

I currently use jena to perform sparql queries on local files with arq 
and on remote public databases with rsparql.
Now, i would like to perform sparql queries with rsparql on a remote 
private database that requires authentication by login and password.
In your documentation, you describe how to identify yourself using your 
java api 
(<https://jena.apache.org/documentation/sparql-apis/http-auth.html>). 
Is it possible to perform this identification with your rsparql program?
Having never programmed in java, I would like if possible to use as 
much as possible the programs that you have created.

I use Jena v4.6.1 on a fedora 36 with openjdk 17.0.5.

Thank you for your answer and your great work,
Regards,

Steven


Re: Re: Use rsparl to request a spaql database with login/password authentication

Posted by Justin <th...@gmail.com>.
Thank you. I've never noticed that one.

On Mon, Jan 9, 2023 at 1:47 AM Lorenz Buehmann <
buehmann@informatik.uni-leipzig.de> wrote:

> It's a commandline tool in the Jena distribution [1]
>
> ./bin/rset
>
> [1] https://dlcdn.apache.org/jena/binaries/apache-jena-4.7.0.tar.gz
>
> On 09.01.23 01:42, Justin wrote:
> > Hi Andy,
> >
> > What repo or package contains the "rset" utility?
> >
> > Not this one I assume?
> > https://github.com/eradman/rset
> >
> >
> > On Fri, Jan 6, 2023 at 5:16 PM Andy Seaborne <an...@apache.org> wrote:
> >
> >> rsparql does not have authentication support.
> >>
> >> You can use curl which has support for HTTP authentication:
> >>
> >>     curl -d query='SELECT * {}' "http://localhost:3030/ds"
> >>
> >> that returns application/sparql-results+json
> >>
> >> Use "-u user:password" or .netrc to put user and password in a secured
> >> file.
> >>
> >>
> >>     curl -d query='SELECT * {}' "http://localhost:3030/ds?format=text"
> >>
> >> returns the text format if asking Fuseki.
> >>
> >> For some other triple store, you can format the results locally with
> "rset"
> >>
> >> curl -s -d query='SELECT * {}' "http://localhost:3030/ds" | \
> >>       rset -in json -out text -- -
> >>
> >>       Andy
> >>
> >> On 06/01/2023 16:30, Steven Blanchard wrote:
> >>> Hello Jena Team,
> >>>
> >>> I currently use jena to perform sparql queries on local files with arq
> >>> and on remote public databases with rsparql.
> >>> Now, i would like to perform sparql queries with rsparql on a remote
> >>> private database that requires authentication by login and password.
> >>> In your documentation, you describe how to identify yourself using your
> >>> java api
> >>> (<https://jena.apache.org/documentation/sparql-apis/http-auth.html>).
> >> Is
> >>> it possible to perform this identification with your rsparql program?
> >>> Having never programmed in java, I would like if possible to use as
> much
> >>> as possible the programs that you have created.
> >>>
> >>> I use Jena v4.6.1 on a fedora 36 with openjdk 17.0.5.
> >>>
> >>> Thank you for your answer and your great work,
> >>> Regards,
> >>>
> >>> Steven
> >>>
> >>>
>

Re: Re: Use rsparl to request a spaql database with login/password authentication

Posted by Lorenz Buehmann <bu...@informatik.uni-leipzig.de>.
It's a commandline tool in the Jena distribution [1]

./bin/rset

[1] https://dlcdn.apache.org/jena/binaries/apache-jena-4.7.0.tar.gz

On 09.01.23 01:42, Justin wrote:
> Hi Andy,
>
> What repo or package contains the "rset" utility?
>
> Not this one I assume?
> https://github.com/eradman/rset
>
>
> On Fri, Jan 6, 2023 at 5:16 PM Andy Seaborne <an...@apache.org> wrote:
>
>> rsparql does not have authentication support.
>>
>> You can use curl which has support for HTTP authentication:
>>
>>     curl -d query='SELECT * {}' "http://localhost:3030/ds"
>>
>> that returns application/sparql-results+json
>>
>> Use "-u user:password" or .netrc to put user and password in a secured
>> file.
>>
>>
>>     curl -d query='SELECT * {}' "http://localhost:3030/ds?format=text"
>>
>> returns the text format if asking Fuseki.
>>
>> For some other triple store, you can format the results locally with "rset"
>>
>> curl -s -d query='SELECT * {}' "http://localhost:3030/ds" | \
>>       rset -in json -out text -- -
>>
>>       Andy
>>
>> On 06/01/2023 16:30, Steven Blanchard wrote:
>>> Hello Jena Team,
>>>
>>> I currently use jena to perform sparql queries on local files with arq
>>> and on remote public databases with rsparql.
>>> Now, i would like to perform sparql queries with rsparql on a remote
>>> private database that requires authentication by login and password.
>>> In your documentation, you describe how to identify yourself using your
>>> java api
>>> (<https://jena.apache.org/documentation/sparql-apis/http-auth.html>).
>> Is
>>> it possible to perform this identification with your rsparql program?
>>> Having never programmed in java, I would like if possible to use as much
>>> as possible the programs that you have created.
>>>
>>> I use Jena v4.6.1 on a fedora 36 with openjdk 17.0.5.
>>>
>>> Thank you for your answer and your great work,
>>> Regards,
>>>
>>> Steven
>>>
>>>

Re: Use rsparl to request a spaql database with login/password authentication

Posted by Justin <th...@gmail.com>.
Hi Andy,

What repo or package contains the "rset" utility?

Not this one I assume?
https://github.com/eradman/rset


On Fri, Jan 6, 2023 at 5:16 PM Andy Seaborne <an...@apache.org> wrote:

> rsparql does not have authentication support.
>
> You can use curl which has support for HTTP authentication:
>
>    curl -d query='SELECT * {}' "http://localhost:3030/ds"
>
> that returns application/sparql-results+json
>
> Use "-u user:password" or .netrc to put user and password in a secured
> file.
>
>
>    curl -d query='SELECT * {}' "http://localhost:3030/ds?format=text"
>
> returns the text format if asking Fuseki.
>
> For some other triple store, you can format the results locally with "rset"
>
> curl -s -d query='SELECT * {}' "http://localhost:3030/ds" | \
>      rset -in json -out text -- -
>
>      Andy
>
> On 06/01/2023 16:30, Steven Blanchard wrote:
> > Hello Jena Team,
> >
> > I currently use jena to perform sparql queries on local files with arq
> > and on remote public databases with rsparql.
> > Now, i would like to perform sparql queries with rsparql on a remote
> > private database that requires authentication by login and password.
> > In your documentation, you describe how to identify yourself using your
> > java api
> > (<https://jena.apache.org/documentation/sparql-apis/http-auth.html>).
> Is
> > it possible to perform this identification with your rsparql program?
> > Having never programmed in java, I would like if possible to use as much
> > as possible the programs that you have created.
> >
> > I use Jena v4.6.1 on a fedora 36 with openjdk 17.0.5.
> >
> > Thank you for your answer and your great work,
> > Regards,
> >
> > Steven
> >
> >
>

Re: Use rsparl to request a spaql database with login/password authentication

Posted by Andy Seaborne <an...@apache.org>.
rsparql does not have authentication support.

You can use curl which has support for HTTP authentication:

   curl -d query='SELECT * {}' "http://localhost:3030/ds"

that returns application/sparql-results+json

Use "-u user:password" or .netrc to put user and password in a secured 
file.


   curl -d query='SELECT * {}' "http://localhost:3030/ds?format=text"

returns the text format if asking Fuseki.

For some other triple store, you can format the results locally with "rset"

curl -s -d query='SELECT * {}' "http://localhost:3030/ds" | \
     rset -in json -out text -- -

     Andy

On 06/01/2023 16:30, Steven Blanchard wrote:
> Hello Jena Team,
> 
> I currently use jena to perform sparql queries on local files with arq 
> and on remote public databases with rsparql.
> Now, i would like to perform sparql queries with rsparql on a remote 
> private database that requires authentication by login and password.
> In your documentation, you describe how to identify yourself using your 
> java api 
> (<https://jena.apache.org/documentation/sparql-apis/http-auth.html>). Is 
> it possible to perform this identification with your rsparql program?
> Having never programmed in java, I would like if possible to use as much 
> as possible the programs that you have created.
> 
> I use Jena v4.6.1 on a fedora 36 with openjdk 17.0.5.
> 
> Thank you for your answer and your great work,
> Regards,
> 
> Steven
> 
>