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
