Hi Keerthika, Since we have changed the version of the GSS connector in the store, we should change the init method in documentation as well.
Regards, -- *Naasheer Ali* | Associate Software Engineer WSO2, Inc |#20, Palm Grove, Colombo 03, Sri Lanka Email: [email protected] On Wed, Jun 3, 2015 at 9:32 AM, Keerthika Mahendralingam <[email protected] > wrote: > Hi Malaka, > Yes. Now we have 2.0.0 version in the connector store. > > > Thanks, > > On Wed, Jun 3, 2015 at 9:28 AM, Malaka Silva <[email protected]> wrote: > >> Hi All, >> >> Do we have the latest connector that supports OAUTH 2.0 in store? >> >> On Tue, Jun 2, 2015 at 10:02 AM, Naasheer Ali <[email protected]> wrote: >> >>> Hi Amal, >>> >>> +1 for keerthika, >>> Use oAuth2init method instead of init. >>> >>> Regards, >>> -- >>> >>> *Naasheer Ali* | Associate Software Engineer >>> >>> WSO2, Inc |#20, Palm Grove, Colombo 03, Sri Lanka >>> >>> Email: [email protected] >>> >>> On Tue, Jun 2, 2015 at 8:40 AM, Vanjikumaran Sivajothy <[email protected]> >>> wrote: >>> >>>> >>>> >>>> On Tuesday, June 2, 2015, Madhawa Gunasekara <[email protected]> wrote: >>>> >>>>> Hi Amal, >>>>> >>>>> According to the log trace, the issue is occurring at >>>>> "com.google.gdata.client" package, which is outdated one (Older Google >>>>> Data >>>>> (GData) API) [1]. Google recommends to migrate to their new Google APIs >>>>> Client Library for Java [2]. That might be the issue. because according to >>>>> the release notes [1] supports OAuth 2.0 as well. >>>>> >>>> >>>> In that case how does this work for nasheer >>>> >>>> >>>> >>>>> I think, we have to migrate to the new Google APIs Client Library to >>>>> solve this issue >>>>> >>>>> [1] https://github.com/google/gdata-java-client >>>>> [2] https://github.com/google/google-api-java-client >>>>> >>>>> Thanks, >>>>> Madhawa >>>>> >>>>> On Tue, Jun 2, 2015 at 12:17 AM, Keerthika Mahendralingam < >>>>> [email protected]> wrote: >>>>> >>>>>> Hi Amal, >>>>>> I think you have tried with init method. Could you please try >>>>>> with oAuth2init method. >>>>>> <googlespreadsheet.oAuth2init> >>>>>> <oauthConsumerKey>{'oauth.consumerKey'}</oauthConsumerKey> >>>>>> <oauthConsumerSecret>{'oauth.oauthConsumerSecret'} >>>>>> </oauthConsumerSecret> >>>>>> <oauthAccessToken>{'oauth.accessToken'}</oauthAccessToken> >>>>>> >>>>>> <oauthAccessTokenSecret>{'oauth.accessTokenSecret'}</oauthAccessTokenSecret> >>>>>> >>>>>> </googlespreadsheet.oAuth2init> >>>>>> >>>>>> Thanks, >>>>>> >>>>>> On Mon, Jun 1, 2015 at 10:09 PM, Naasheer Ali <[email protected]> >>>>>> wrote: >>>>>> >>>>>>> Hi Amal, >>>>>>> >>>>>>> I can not reproduce the issue, GSS connector builds perfectly and >>>>>>> able to create worksheet as well. >>>>>>> >>>>>>> >>>>>>> Regards, >>>>>>> -- >>>>>>> >>>>>>> *Naasheer Ali* | Associate Software Engineer >>>>>>> >>>>>>> WSO2, Inc |#20, Palm Grove, Colombo 03, Sri Lanka >>>>>>> >>>>>>> Email: [email protected] >>>>>>> >>>>>>> On Mon, Jun 1, 2015 at 7:38 PM, Malaka Silva <[email protected]> >>>>>>> wrote: >>>>>>> >>>>>>>> Connector Team, >>>>>>>> >>>>>>>> Can anyone of you check this please. Also we should have both >>>>>>>> versions or latest in the store. >>>>>>>> >>>>>>>> On Mon, Jun 1, 2015 at 5:39 PM, Amal Gunatilake <[email protected]> >>>>>>>> wrote: >>>>>>>> >>>>>>>>> Hi Nasheer, >>>>>>>>> >>>>>>>>> Thank you for the link. >>>>>>>>> I built the code and deployed the latest google spreadsheet >>>>>>>>> connector (2.0.0). But I still face the same issue. >>>>>>>>> >>>>>>>>> I get the following error. >>>>>>>>> >>>>>>>>> [2015-06-01 17:34:52,756] ERROR - *GoogleSpreadsheetCreateWorksheet >>>>>>>>> Error occured Error authenticating (check service name)* >>>>>>>>> com.google.gdata.util.AuthenticationException: Error >>>>>>>>> authenticating (check service name) >>>>>>>>> at >>>>>>>>> com.google.gdata.client.GoogleAuthTokenFactory.getAuthException(GoogleAuthTokenFactory.java:688) >>>>>>>>> at >>>>>>>>> com.google.gdata.client.GoogleAuthTokenFactory.getAuthToken(GoogleAuthTokenFactory.java:560) >>>>>>>>> at >>>>>>>>> com.google.gdata.client.GoogleAuthTokenFactory.setUserCredentials(GoogleAuthTokenFactory.java:397) >>>>>>>>> at >>>>>>>>> com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:364) >>>>>>>>> at >>>>>>>>> com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:319) >>>>>>>>> at >>>>>>>>> com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:303) >>>>>>>>> at >>>>>>>>> org.wso2.carbon.connector.googlespreadsheet.GoogleSpreadsheetAuthentication.login(GoogleSpreadsheetAuthentication.java:59) >>>>>>>>> at >>>>>>>>> org.wso2.carbon.connector.googlespreadsheet.GoogleSpreadsheetClientLoader.loadSpreadsheetService(GoogleSpreadsheetClientLoader.java:53) >>>>>>>>> at >>>>>>>>> org.wso2.carbon.connector.googlespreadsheet.GoogleSpreadsheetGetAllSpreadsheets.connect(GoogleSpreadsheetGetAllSpreadsheets.java:46) >>>>>>>>> at >>>>>>>>> org.wso2.carbon.connector.core.AbstractConnector.mediate(AbstractConnector.java:32) >>>>>>>>> at >>>>>>>>> org.apache.synapse.mediators.ext.ClassMediator.mediate(ClassMediator.java:78) >>>>>>>>> at >>>>>>>>> org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:77) >>>>>>>>> at >>>>>>>>> org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:47) >>>>>>>>> at >>>>>>>>> org.apache.synapse.mediators.template.TemplateMediator.mediate(TemplateMediator.java:77) >>>>>>>>> at >>>>>>>>> org.apache.synapse.mediators.template.InvokeMediator.mediate(InvokeMediator.java:129) >>>>>>>>> at >>>>>>>>> org.apache.synapse.mediators.template.InvokeMediator.mediate(InvokeMediator.java:78) >>>>>>>>> at >>>>>>>>> org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:77) >>>>>>>>> at >>>>>>>>> org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:47) >>>>>>>>> at >>>>>>>>> org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:131) >>>>>>>>> at >>>>>>>>> org.apache.synapse.core.axis2.ProxyServiceMessageReceiver.receive(ProxyServiceMessageReceiver.java:166) >>>>>>>>> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) >>>>>>>>> at >>>>>>>>> org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:411) >>>>>>>>> at >>>>>>>>> org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:183) >>>>>>>>> at >>>>>>>>> org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) >>>>>>>>> at >>>>>>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >>>>>>>>> at >>>>>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >>>>>>>>> at java.lang.Thread.run(Thread.java:745) >>>>>>>>> >>>>>>>>> Also when building the sample there was a build error and I had to >>>>>>>>> update the pom file as below to get it build. >>>>>>>>> >>>>>>>>> diff --git a/googlespreadsheet/2.0.0/pom.xml >>>>>>>>> b/googlespreadsheet/2.0.0/pom.xml >>>>>>>>> index ba5e188..65af017 100644 >>>>>>>>> --- a/googlespreadsheet/2.0.0/pom.xml >>>>>>>>> +++ b/googlespreadsheet/2.0.0/pom.xml >>>>>>>>> @@ -29,7 +29,7 @@ >>>>>>>>> <dependency> >>>>>>>>> <groupId>org.apache.synapse</groupId> >>>>>>>>> <artifactId>synapse-core</artifactId> >>>>>>>>> - <version>2.1.3-wso2v1-SNAPSHOT</version> >>>>>>>>> + <version>2.1.3-wso2v1</version> >>>>>>>>> </dependency> >>>>>>>>> <dependency> >>>>>>>>> <groupId>com.google.gdata</groupId> >>>>>>>>> >>>>>>>>> Best regards, >>>>>>>>> Amal. >>>>>>>>> >>>>>>>>> >>>>>>>>> On Mon, Jun 1, 2015 at 4:51 PM, Naasheer Ali <[email protected]> >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> Hi Amal, >>>>>>>>>> >>>>>>>>>> We have implemented the google spreadsheet connector with OAuth2 >>>>>>>>>> support. You can find the connector here[1]. >>>>>>>>>> >>>>>>>>>> [1] - >>>>>>>>>> https://github.com/wso2/esb-connectors/tree/master/googlespreadsheet/2.0.0 >>>>>>>>>> >>>>>>>>>> Regards, >>>>>>>>>> -- >>>>>>>>>> >>>>>>>>>> *Naasheer Ali* | Associate Software Engineer >>>>>>>>>> >>>>>>>>>> WSO2, Inc |#20, Palm Grove, Colombo 03, Sri Lanka >>>>>>>>>> >>>>>>>>>> Email: [email protected] >>>>>>>>>> >>>>>>>>>> On Mon, Jun 1, 2015 at 4:32 PM, Rajith Vitharana < >>>>>>>>>> [email protected]> wrote: >>>>>>>>>> >>>>>>>>>>> Hi, >>>>>>>>>>> >>>>>>>>>>> Similar issue occurred in DSS as well. It seems google may have >>>>>>>>>>> changed there authentication mechanism. According to [2],[3],[4] >>>>>>>>>>> google >>>>>>>>>>> stopped supporting Oauth 1.0 and that may be the case for this >>>>>>>>>>> issue. >>>>>>>>>>> Public jira for DSS is in [1] >>>>>>>>>>> >>>>>>>>>>> [1] - https://wso2.org/jira/browse/DS-1049 >>>>>>>>>>> [2] - >>>>>>>>>>> https://developers.google.com/identity/protocols/OAuthForWebApps >>>>>>>>>>> [3] - >>>>>>>>>>> https://bugs.launchpad.net/ubuntu/+source/googlecl/+bug/1408503 >>>>>>>>>>> [4] - https://developers.google.com/identity/protocols/OAuth_ref >>>>>>>>>>> >>>>>>>>>>> Thanks, >>>>>>>>>>> >>>>>>>>>>> On Mon, Jun 1, 2015 at 4:20 PM, Amal Gunatilake <[email protected]> >>>>>>>>>>> wrote: >>>>>>>>>>> >>>>>>>>>>>> +chanaka >>>>>>>>>>>> >>>>>>>>>>>> On Mon, Jun 1, 2015 at 3:48 PM, Amal Gunatilake <[email protected] >>>>>>>>>>>> > wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Hi Vanji, >>>>>>>>>>>>> >>>>>>>>>>>>> I was trying to connect to a google spreadsheet using the ESB >>>>>>>>>>>>> connector and I get the following error when the proxy is invoked. >>>>>>>>>>>>> >>>>>>>>>>>>> *<soapenv:Envelope >>>>>>>>>>>>> xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/ >>>>>>>>>>>>> <http://schemas.xmlsoap.org/soap/envelope/>">* >>>>>>>>>>>>> * <soapenv:Header/>* >>>>>>>>>>>>> * <soapenv:Body>* >>>>>>>>>>>>> * <ns:ErrorResponse >>>>>>>>>>>>> xmlns:ns="http://org.wso2.esbconnectors.googlespreadsheet >>>>>>>>>>>>> <http://org.wso2.esbconnectors.googlespreadsheet>">* >>>>>>>>>>>>> * <ns:ErrorMessage>Error authenticating (check service >>>>>>>>>>>>> name)</ns:ErrorMessage>* >>>>>>>>>>>>> * </ns:ErrorResponse>* >>>>>>>>>>>>> * </soapenv:Body>* >>>>>>>>>>>>> *</soapenv:Envelope>* >>>>>>>>>>>>> >>>>>>>>>>>>> I downloaded the googleSpreadsheet connector from [1], >>>>>>>>>>>>> deployed it in the ESB 4.8.1 server and have enabled it according >>>>>>>>>>>>> to >>>>>>>>>>>>> documentation[2]. >>>>>>>>>>>>> >>>>>>>>>>>>> Could you please help me to identify the issue? >>>>>>>>>>>>> >>>>>>>>>>>>> Following is my synapse configurations >>>>>>>>>>>>> >>>>>>>>>>>>> *<definitions xmlns="http://ws.apache.org/ns/synapse >>>>>>>>>>>>> <http://ws.apache.org/ns/synapse>">* >>>>>>>>>>>>> * <registry >>>>>>>>>>>>> provider="org.wso2.carbon.mediation.registry.WSO2Registry">* >>>>>>>>>>>>> * <parameter name="cachableDuration">15000</parameter>* >>>>>>>>>>>>> * </registry>* >>>>>>>>>>>>> * <import name="googlespreadsheet"* >>>>>>>>>>>>> * package="org.wso2.carbon.connectors"* >>>>>>>>>>>>> * status="enabled"/>* >>>>>>>>>>>>> * <proxy name="testCon"* >>>>>>>>>>>>> * transports="https http"* >>>>>>>>>>>>> * startOnLoad="true"* >>>>>>>>>>>>> * trace="disable">* >>>>>>>>>>>>> * <description/>* >>>>>>>>>>>>> * <target>* >>>>>>>>>>>>> * <inSequence>* >>>>>>>>>>>>> * <googlespreadsheet.usernameLogin>* >>>>>>>>>>>>> * <username>[email protected]</username>* >>>>>>>>>>>>> * <password>wso2carbon</password>* >>>>>>>>>>>>> * </googlespreadsheet.usernameLogin>* >>>>>>>>>>>>> * <googlespreadsheet.getAllSpreadsheets >>>>>>>>>>>>> configKey="MyGSConfig"/>* >>>>>>>>>>>>> * <respond/>* >>>>>>>>>>>>> * </inSequence>* >>>>>>>>>>>>> * </target>* >>>>>>>>>>>>> * </proxy>* >>>>>>>>>>>>> * <localEntry key="MyGSConfig">* >>>>>>>>>>>>> * <googlespreadsheet.usernameLogin>* >>>>>>>>>>>>> * <username>[email protected]</username>* >>>>>>>>>>>>> * <password>wso2carbon</password>* >>>>>>>>>>>>> * </googlespreadsheet.usernameLogin>* >>>>>>>>>>>>> * <description>Authentication config</description>* >>>>>>>>>>>>> * </localEntry>* >>>>>>>>>>>>> * <sequence name="fault">* >>>>>>>>>>>>> * <log level="full">* >>>>>>>>>>>>> * <property name="MESSAGE" value="Executing default >>>>>>>>>>>>> 'fault' sequence"/>* >>>>>>>>>>>>> * <property name="ERROR_CODE" >>>>>>>>>>>>> expression="get-property('ERROR_CODE')"/>* >>>>>>>>>>>>> * <property name="ERROR_MESSAGE" >>>>>>>>>>>>> expression="get-property('ERROR_MESSAGE')"/>* >>>>>>>>>>>>> * </log>* >>>>>>>>>>>>> * <drop/>* >>>>>>>>>>>>> * </sequence>* >>>>>>>>>>>>> * <sequence name="main">* >>>>>>>>>>>>> * <in>* >>>>>>>>>>>>> * <log level="full"/>* >>>>>>>>>>>>> * <filter source="get-property('To')" >>>>>>>>>>>>> regex="http://localhost:9000.*";>* >>>>>>>>>>>>> * <send/>* >>>>>>>>>>>>> * </filter>* >>>>>>>>>>>>> * </in>* >>>>>>>>>>>>> * <out>* >>>>>>>>>>>>> * <send/>* >>>>>>>>>>>>> * </out>* >>>>>>>>>>>>> * <description>The main sequence for the message >>>>>>>>>>>>> mediation</description>* >>>>>>>>>>>>> * </sequence>* >>>>>>>>>>>>> *</definitions>* >>>>>>>>>>>>> >>>>>>>>>>>>> [1] >>>>>>>>>>>>> https://github.com/wso2/esb-connectors/tree/master/distribution/google-spreadsheet >>>>>>>>>>>>> [2] >>>>>>>>>>>>> https://docs.wso2.com/display/ESB480/Google+Spreadsheet+Connector >>>>>>>>>>>>> >>>>>>>>>>>>> Best regards, >>>>>>>>>>>>> Amal. >>>>>>>>>>>>> -- >>>>>>>>>>>>> *Amal Gunatilake* >>>>>>>>>>>>> Software Engineer >>>>>>>>>>>>> WSO2 Inc.; http://wso2.com >>>>>>>>>>>>> lean.enterprise.middleware >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> *Amal Gunatilake* >>>>>>>>>>>> Software Engineer >>>>>>>>>>>> WSO2 Inc.; http://wso2.com >>>>>>>>>>>> lean.enterprise.middleware >>>>>>>>>>>> >>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>> Dev mailing list >>>>>>>>>>>> [email protected] >>>>>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> Rajith Vitharana >>>>>>>>>>> >>>>>>>>>>> Software Engineer, >>>>>>>>>>> WSO2 Inc. : wso2.com >>>>>>>>>>> Mobile : +94715883223 >>>>>>>>>>> Blog : http://lankavitharana.blogspot.com/ >>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> Dev mailing list >>>>>>>>>>> [email protected] >>>>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> *Amal Gunatilake* >>>>>>>>> Software Engineer >>>>>>>>> WSO2 Inc.; http://wso2.com >>>>>>>>> lean.enterprise.middleware >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> Dev mailing list >>>>>>>>> [email protected] >>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> >>>>>>>> Best Regards, >>>>>>>> >>>>>>>> Malaka Silva >>>>>>>> Senior Tech Lead >>>>>>>> M: +94 777 219 791 >>>>>>>> Tel : 94 11 214 5345 >>>>>>>> Fax :94 11 2145300 >>>>>>>> Skype : malaka.sampath.silva >>>>>>>> LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77 >>>>>>>> Blog : http://mrmalakasilva.blogspot.com/ >>>>>>>> >>>>>>>> WSO2, Inc. >>>>>>>> lean . enterprise . middleware >>>>>>>> http://www.wso2.com/ >>>>>>>> http://www.wso2.com/about/team/malaka-silva/ >>>>>>>> <http://wso2.com/about/team/malaka-silva/> >>>>>>>> >>>>>>>> Save a tree -Conserve nature & Save the world for your future. >>>>>>>> Print this email only if it is absolutely necessary. >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Keerthika Mahendralingam >>>>>> Associate Software Engineer >>>>>> Mobile :+94 (0) 776 121144 >>>>>> [email protected] >>>>>> WSO2, Inc. >>>>>> lean . enterprise . middleware >>>>>> >>>>>> _______________________________________________ >>>>>> Dev mailing list >>>>>> [email protected] >>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> *Madhawa Gunasekara* >>>>> Software Engineer >>>>> WSO2 Inc.; http://wso2.com >>>>> lean.enterprise.middleware >>>>> >>>>> mobile: +94 719411002 <+94+719411002> >>>>> blog: *http://madhawa-gunasekara.blogspot.com >>>>> <http://madhawa-gunasekara.blogspot.com>* >>>>> linkedin: *http://lk.linkedin.com/in/mgunasekara >>>>> <http://lk.linkedin.com/in/mgunasekara>* >>>>> >>>> >>>> >>>> -- >>>> Sent from Gmail Mobile >>>> >>>> _______________________________________________ >>>> Dev mailing list >>>> [email protected] >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> _______________________________________________ >>> Dev mailing list >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> >> Best Regards, >> >> Malaka Silva >> Senior Tech Lead >> M: +94 777 219 791 >> Tel : 94 11 214 5345 >> Fax :94 11 2145300 >> Skype : malaka.sampath.silva >> LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77 >> Blog : http://mrmalakasilva.blogspot.com/ >> >> WSO2, Inc. >> lean . enterprise . middleware >> http://www.wso2.com/ >> http://www.wso2.com/about/team/malaka-silva/ >> <http://wso2.com/about/team/malaka-silva/> >> >> Save a tree -Conserve nature & Save the world for your future. Print this >> email only if it is absolutely necessary. >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > <[email protected]> > Keerthika Mahendralingam > Associate Software Engineer > Mobile :+94 (0) 776 121144 > [email protected] > WSO2, Inc. > lean . enterprise . middleware > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
