[Building Sakai] Google Docs rSmart Integration issue

Kevin Takacs ktakacs at anisakai.com
Wed Apr 9 08:34:37 PDT 2014


Make sure you have google-content.enabled=true and
google-content.useOAuth2=true in sakai.properties.  There is a PDF in the
top level of the google-content source called
GoogleDriveIntegrationConfiguration.pdf that has step by step instructions
for getting the clientId/secret from Google and setting up the OAuth
provider in your instance.

If you ran your instance with google-content prior to installing the source
from the rSmart msub there are a few lines of sql that you will apply to
your database.  Here they are for mysql:

alter table oauth_provider add column clientId varchar(100);
alter table oauth_provider add column clientSecret varchar(100);
alter table oauth_provider add column authUrl varchar(255);
alter table oauth_provider add column tokenUrl varchar(255);
alter table oauth_provider modify consumer_key varchar(100);
alter table oauth_provider modify accessTokenURL varchar(255);
alter table oauth_provider modify requestTokenURL varchar(255);
alter table oauth_provider modify userAuthorizationURL varchar(255);
alter table oauth_provider modify signatureMethod varchar(255);
alter table oauth_token add column protocolVersion varchar(10) default
'1.0';
alter table oauth_token modify oAuthTokenSecret varchar(100);



On Wed, Apr 9, 2014 at 1:18 AM, Abhinav <yabhinav at gmail.com> wrote:

> Hi John,
>
> I checked out the code from msub and was able to deploy it to my existing
> Sakai instance. But I don't see the "Link to Google Document" in the drop
> down in Resources tool
>
> Below are the configuration details in Oauth Provider tool
> StatusENABLED Provider's Name:Google DocsDescriptiontestConsumer Key:
> XXXXXXXRealm:Access Token Url:https://accounts.google.com/o/oauth2/auth Request
> Token Url:https://accounts.google.com/o/oauth2/tokenUser Authorization
> Url:https://accounts.google.com/o/oauth2/auth OAuth Signature Method:
> HMAC-SHA1HMAC-SHA1 Shared Secret:XXXXXXRSA-SHA1 Key:
> Additional Parameters NameValuescopehttps://www.googleapis.com/auth/drive
> Can you please let me know if I'm missing something.
>
> Regards,
> Abhinav
>
>
> On Mon, Mar 24, 2014 at 11:36 AM, Abhinav <yabhinav at gmail.com> wrote:
>
>> Thank you John. I'll take a look at it.
>>
>> Regards,
>> Abhinav
>>
>>
>> On Sat, Mar 22, 2014 at 8:51 AM, John Bush <jbush at anisakai.com> wrote:
>>
>>> We have made adjustments to use oauth 2. This work is currently in
>>> testing you can find the source in the rsmart msub area.
>>>
>>> Sent from my iPhone
>>>
>>> On Mar 18, 2014, at 5:19 AM, Abhinav <yabhinav at gmail.com> wrote:
>>>
>>> Hi,
>>>
>>> We are unable to proceed with Google docs integration for Sakai provided
>>> by rSmart as Google has deprecated service for Oauth 1.0 and as per the
>>> installation guide we need to fill in details like consumer key and shared
>>> secret to connect to google docs.
>>>
>>> <image.png>
>>>
>>> Would appreciate it if someone can help us figure out how to configure
>>> Google docs for Sakai
>>> --
>>> Regards,
>>> Abhinav
>>> Ph:+91 9885006506
>>>
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>
>>> TO UNSUBSCRIBE: send email to
>>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>>> "unsubscribe"
>>>
>>>
>>
>>
>> --
>> Regards,
>> Abhinav
>> Ph:+91 9885006506
>>
>
>
>
> --
> Regards,
> Abhinav
> Ph:+91 9885006506
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>



-- 
Kevin Takacs
Software Engineer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140409/be253046/attachment.html 


More information about the sakai-dev mailing list