Re: [Virtuoso-users] OAuth request_token endpoint returns OAuth Verification Failed: Bad Signature
Hi Hughs, Once again, thanks. I checked out the updated docs and I was able to use the /oauth endpoint. I have a scenario I will like to get more insight on it. This is my scenario, I have an application that connects to users personal graph on virtuosos, which allows individual user manages their data. My implementation should allow other external applications to access user data when the user delegate that application to do so via oauth access. My initial thought is to make use of the oauth/ access mechanism for each user to grant access to their data. But I see that from here http://localhost:8890/oauth/oauth_apps.vspx <http://localhost:8890/oauth/oauth_apps.vspx> I can only generate token for SPARQL and Discussion applications. I want to be able to generate consumer_key and consumer_secret for each application that wants to fetch users data. Questions 1. Is there any other way to achieve this with oauth in virtuosos. 2. Is it possible to make a request to /oauth to programmatically generate the consumer_key and consumer_secret for different applications(developers). Kind Regards. Sunday Ayandokun University of Tartu Tel: +37256724770 Skype: sunday.ayandokun > On Mar 31, 2016, at 3:07 PM, Hugh Williams <hwilli...@openlinksw.com> wrote: > > Hi Sunday, > > The > http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtOAuthSPARQL > <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtOAuthSPARQL> > was pointing to and old ods framework vad and has been updated to point to > the latest one for the 7.2.2 release. Note also that a different ods > framework vad is require for open source and commercial as indicated on the > page also. > > You can also build the required ods framework vad if compiling from open > source archive by passing the --enable-ods-vad configure option … > > 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 30 Mar 2016, at 21:29, Sunday Ayandokun <sunday.ayando...@gmail.com >> <mailto:sunday.ayando...@gmail.com>> wrote: >> >> Hello, >> >> I am having issue connecting to the OAuth to get token. >> >> I installed the ods_framework_dav.vad package and generated SPARQL >> application token and secret following the example here >> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtOAuthSPARQL >> <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtOAuthSPARQL> >> >> >> I read this http://docs.openlinksw.com/virtuoso/voauth.html >> <http://docs.openlinksw.com/virtuoso/voauth.html> to understand how Oauth >> request should be made to Virtuoso Oauth endpoint. >> >> >> http://localhost:8890/OAuth/request_token?oauth_version=1.0_nonce=72180780940317254641459358880_timestamp=1459299214_consumer_key=client_key_signature_method=HMAC-SHA1_signature=KmF8ngGHSBQJIDHTDw%2FWP%2Fdqgmc%3D >> >> <http://192.168.33.18:8890/OAuth/request_token?oauth_version=1.0_nonce=72180780940317254641459358880_timestamp=1459299214_consumer_key=a1bdb2729ee7fa4bb099e0e4968903b8ce9f484d_signature_method=HMAC-SHA1_signature=KmF8ngGHSBQJIDHTDw/WP/dqgmc=> >> >> I am using a python library to sign the request. >> >> client_key = token >> client_secret = secret >> >> client = oauth1.Client(client_key, client_secret=client_secret) >> uri, headers, body = client.sign(request_token_url) >> >> I am getting this response 'OAuth Verification Failed: Bad Signature' >> >> >> Kindly point me to the best approach. >> >> >> Kind Regards. >> Sunday Ayandokun >> University of Tartu >> Tel: +37256724770 >> Skype: sunday.ayandokun >> >> -- >> Transform Data into Opportunity. >> Accelerate data analysis in your applications with >> Intel Data Analytics A
Re: [Virtuoso-users] OAuth request_token endpoint returns OAuth Verification Failed: Bad Signature
Hi Hughs, Once again, thanks. I checked out the updated docs and I was able to use the /oauth endpoint. I have a scenario I will like to get more insight on it. This is my scenario, I have an application that connects to users personal graph on virtuosos, which allows individual user manages their data. My implementation should allow other external applications to access user data when the user delegate that application to do so via oauth access. My initial thought is to make use of the oauth/ access mechanism for each user to grant access to their data. But I see that from here http://localhost:8890/oauth/oauth_apps.vspx <http://localhost:8890/oauth/oauth_apps.vspx> I can only generate token for SPARQL and Discussion applications. I want to be able to generate consumer_key and consumer_secret for each application that wants to fetch users data. Questions 1. Is there any other way to achieve this with oauth in virtuosos. 2. Is it possible to make a request to /oauth to programmatically generate the consumer_key and consumer_secret for different applications(developers). Kind Regards. Sunday Ayandokun University of Tartu Tel: +37256724770 Skype: sunday.ayandokun > On Mar 31, 2016, at 3:07 PM, Hugh Williams <hwilli...@openlinksw.com> wrote: > > Hi Sunday, > > The > http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtOAuthSPARQL > <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtOAuthSPARQL> > was pointing to and old ods framework vad and has been updated to point to > the latest one for the 7.2.2 release. Note also that a different ods > framework vad is require for open source and commercial as indicated on the > page also. > > You can also build the required ods framework vad if compiling from open > source archive by passing the --enable-ods-vad configure option … > > 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 30 Mar 2016, at 21:29, Sunday Ayandokun <sunday.ayando...@gmail.com >> <mailto:sunday.ayando...@gmail.com>> wrote: >> >> Hello, >> >> I am having issue connecting to the OAuth to get token. >> >> I installed the ods_framework_dav.vad package and generated SPARQL >> application token and secret following the example here >> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtOAuthSPARQL >> <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtOAuthSPARQL> >> >> >> I read this http://docs.openlinksw.com/virtuoso/voauth.html >> <http://docs.openlinksw.com/virtuoso/voauth.html> to understand how Oauth >> request should be made to Virtuoso Oauth endpoint. >> >> >> http://localhost:8890/OAuth/request_token?oauth_version=1.0_nonce=72180780940317254641459358880_timestamp=1459299214_consumer_key=client_key_signature_method=HMAC-SHA1_signature=KmF8ngGHSBQJIDHTDw%2FWP%2Fdqgmc%3D >> >> <http://192.168.33.18:8890/OAuth/request_token?oauth_version=1.0_nonce=72180780940317254641459358880_timestamp=1459299214_consumer_key=a1bdb2729ee7fa4bb099e0e4968903b8ce9f484d_signature_method=HMAC-SHA1_signature=KmF8ngGHSBQJIDHTDw/WP/dqgmc=> >> >> I am using a python library to sign the request. >> >> client_key = token >> client_secret = secret >> >> client = oauth1.Client(client_key, client_secret=client_secret) >> uri, headers, body = client.sign(request_token_url) >> >> I am getting this response 'OAuth Verification Failed: Bad Signature' >> >> >> Kindly point me to the best approach. >> >> >> Kind Regards. >> Sunday Ayandokun >> University of Tartu >> Tel: +37256724770 >> Skype: sunday.ayandokun >> >> -- >> Transform Data into Opportunity. >> Accelerate data analysis in your applications with >> Intel Data Analytics A
[Virtuoso-users] OAuth request_token endpoint returns OAuth Verification Failed: Bad Signature
Hello, I am having issue connecting to the OAuth to get token. I installed the ods_framework_dav.vad package and generated SPARQL application token and secret following the example here http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtOAuthSPARQL <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtOAuthSPARQL> I read this http://docs.openlinksw.com/virtuoso/voauth.html <http://docs.openlinksw.com/virtuoso/voauth.html> to understand how Oauth request should be made to Virtuoso Oauth endpoint. http://localhost:8890/OAuth/request_token?oauth_version=1.0_nonce=72180780940317254641459358880_timestamp=1459299214_consumer_key=client_key_signature_method=HMAC-SHA1_signature=KmF8ngGHSBQJIDHTDw%2FWP%2Fdqgmc%3D <http://192.168.33.18:8890/OAuth/request_token?oauth_version=1.0_nonce=72180780940317254641459358880_timestamp=1459299214_consumer_key=a1bdb2729ee7fa4bb099e0e4968903b8ce9f484d_signature_method=HMAC-SHA1_signature=KmF8ngGHSBQJIDHTDw/WP/dqgmc=> I am using a python library to sign the request. client_key= token client_secret = secret client = oauth1.Client(client_key, client_secret=client_secret) uri, headers, body = client.sign(request_token_url) I am getting this response 'OAuth Verification Failed: Bad Signature' Kindly point me to the best approach. Kind Regards. Sunday Ayandokun University of Tartu Tel: +37256724770 Skype: sunday.ayandokun -- Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785471=/4140___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] Sparql Endpoint - Permission Denied
Hello All,
I did the following to set up personal graph, such that only me can access my
graph via Sparql endpoint.
After creating the user ‘sunday'
1. GRANT SPARQL_UPDATE TO “sunday"
2. DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('nobody', 0);
3. SPARQL CREATE GRAPH <http://example.com/sunday/persons/>;
4. DB.DBA.RDF_GRAPH_USER_PERMS_SET('http://example.com/sunday/persons,
’sunday', 3);
I am using this spaqrlwrapper in my application(django)
https://github.com/RDFLib/sparqlwrapper
<https://github.com/RDFLib/sparqlwrapper>
From the error below I see it’s still using the SPAQRL user to query, but since
I gave permission to only ‘sunday’ it will fail.
How can I query the endpoint within my application via http request and specify
the credentials of the graph owner.
Virtuoso RDF02 Error SR619: SPARUL CLEAR GRAPH access denied: database user 107
(SPARQL) has no write permission on graph http://example.com/sunday/persons/
SPARQL query:
define sql:big-data-const 0
#output-format:application/sparql-results+json
CLEAR GRAPH <http://example.com/sunday/persons/>
Thanks.
Kind Regards.
Sunday Ayandokun
University of Tartu
Tel: +37256724770
Skype: sunday.ayandokun--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785231=/4140___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Virtuoso User Accounts Limitation
Hello Hugh, Thanks for your response. I am sorry for the early conclusion. I have an sql file with about 100,000 records to insert new user. The first time I tried using this: isql-vt dba dba 'EXEC=status()’ VirtuosoUserCreateQuery.sql The query was successful. And when I did select count(*) from sys_users;, I got 3050. I tried this for about 3 times same result, definitely am missing something. Kindly point me to the best approach to creating multiples users. Thanks Sunday > On Feb 28, 2016, at 11:24 PM, Hugh Williams <hwilli...@openlinksw.com> wrote: > > Hi Sunday, > > How have you concluded there is a 3050 user limit, as we have system in-house > with 80K+ users ? > > SQL> select count(*) from sys_users; > count > INTEGER > ___ > > 88016 > > 1 Rows. -- 72 msec. > SQL> > > 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 28 Feb 2016, at 17:37, Sunday Ayandokun <sunday.ayando...@gmail.com >> <mailto:sunday.ayando...@gmail.com>> wrote: >> >> Hello all, >> >> I am working on my Master Thesis, as part of my experimentation I have a Use >> Case that requires creating about 100,000 users on the Virtuoso conductor. >> >> I found out that, I can only create 3050 users. >> >> My questions: >> >> 1. Can this limit be increased? >> 2. If yes, where can I do that. >> >> >> Kind regards. >> Sunday >> -- >> Site24x7 APM Insight: Get Deep Visibility into Application Performance >> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month >> Monitor end-to-end web transactions and take corrective actions now >> Troubleshoot faster and improve end-user experience. Signup Now! >> http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140 >> <http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140> >> ___ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
[Virtuoso-users] Virtuoso User Accounts Limitation
Hello all, I am working on my Master Thesis, as part of my experimentation I have a Use Case that requires creating about 100,000 users on the Virtuoso conductor. I found out that, I can only create 3050 users. My questions: 1. Can this limit be increased? 2. If yes, where can I do that. Kind regards. Sunday -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140 ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
