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: naashe...@wso2.com On Tue, Jun 2, 2015 at 8:40 AM, Vanjikumaran Sivajothy <va...@wso2.com> wrote: > > > On Tuesday, June 2, 2015, Madhawa Gunasekara <madha...@wso2.com> 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 < >> keerth...@wso2.com> 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 <naashe...@wso2.com> >>> 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: naashe...@wso2.com >>>> >>>> On Mon, Jun 1, 2015 at 7:38 PM, Malaka Silva <mal...@wso2.com> 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 <am...@wso2.com> >>>>> 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 <naashe...@wso2.com> >>>>>> 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: naashe...@wso2.com >>>>>>> >>>>>>> On Mon, Jun 1, 2015 at 4:32 PM, Rajith Vitharana <raji...@wso2.com> >>>>>>> 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 <am...@wso2.com> >>>>>>>> wrote: >>>>>>>> >>>>>>>>> +chanaka >>>>>>>>> >>>>>>>>> On Mon, Jun 1, 2015 at 3:48 PM, Amal Gunatilake <am...@wso2.com> >>>>>>>>> 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>wso2...@gmail.com</username>* >>>>>>>>>> * <password>wso2carbon</password>* >>>>>>>>>> * </googlespreadsheet.usernameLogin>* >>>>>>>>>> * <googlespreadsheet.getAllSpreadsheets >>>>>>>>>> configKey="MyGSConfig"/>* >>>>>>>>>> * <respond/>* >>>>>>>>>> * </inSequence>* >>>>>>>>>> * </target>* >>>>>>>>>> * </proxy>* >>>>>>>>>> * <localEntry key="MyGSConfig">* >>>>>>>>>> * <googlespreadsheet.usernameLogin>* >>>>>>>>>> * <username>wso2...@gmail.com</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 >>>>>>>>> Dev@wso2.org >>>>>>>>> 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 >>>>>>>> Dev@wso2.org >>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> *Amal Gunatilake* >>>>>> Software Engineer >>>>>> WSO2 Inc.; http://wso2.com >>>>>> lean.enterprise.middleware >>>>>> >>>>>> _______________________________________________ >>>>>> Dev mailing list >>>>>> Dev@wso2.org >>>>>> 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 >>> keerth...@wso2.com >>> WSO2, Inc. >>> lean . enterprise . middleware >>> >>> _______________________________________________ >>> Dev mailing list >>> Dev@wso2.org >>> 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 > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > >
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
