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
