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.
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 >>>>>>>> <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 >>>>>>>> <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. >>> >> >> > > > -- > <dev-requ...@wso2.org> > 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>*
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
