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] <javascript:_e(%7B%7D,'cvml','[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] >> <javascript:_e(%7B%7D,'cvml','[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] >>> <javascript:_e(%7B%7D,'cvml','[email protected]');> >>> >>> On Mon, Jun 1, 2015 at 7:38 PM, Malaka Silva <[email protected] >>> <javascript:_e(%7B%7D,'cvml','[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] >>>> <javascript:_e(%7B%7D,'cvml','[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] >>>>> <javascript:_e(%7B%7D,'cvml','[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] >>>>>> <javascript:_e(%7B%7D,'cvml','[email protected]');> >>>>>> >>>>>> On Mon, Jun 1, 2015 at 4:32 PM, Rajith Vitharana <[email protected] >>>>>> <javascript:_e(%7B%7D,'cvml','[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] >>>>>>> <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: >>>>>>> >>>>>>>> +chanaka >>>>>>>> >>>>>>>> On Mon, Jun 1, 2015 at 3:48 PM, Amal Gunatilake <[email protected] >>>>>>>> <javascript:_e(%7B%7D,'cvml','[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] >>>>>>>>> <javascript:_e(%7B%7D,'cvml','[email protected]');></username>* >>>>>>>>> * <password>wso2carbon</password>* >>>>>>>>> * </googlespreadsheet.usernameLogin>* >>>>>>>>> * <googlespreadsheet.getAllSpreadsheets >>>>>>>>> configKey="MyGSConfig"/>* >>>>>>>>> * <respond/>* >>>>>>>>> * </inSequence>* >>>>>>>>> * </target>* >>>>>>>>> * </proxy>* >>>>>>>>> * <localEntry key="MyGSConfig">* >>>>>>>>> * <googlespreadsheet.usernameLogin>* >>>>>>>>> * <username>[email protected] >>>>>>>>> <javascript:_e(%7B%7D,'cvml','[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] <javascript:_e(%7B%7D,'cvml','[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] <javascript:_e(%7B%7D,'cvml','[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] <javascript:_e(%7B%7D,'cvml','[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. >>>> >>> >>> >> >> >> -- >> <javascript:_e(%7B%7D,'cvml','[email protected]');> >> Keerthika Mahendralingam >> Associate Software Engineer >> Mobile :+94 (0) 776 121144 >> [email protected] <javascript:_e(%7B%7D,'cvml','[email protected]');> >> WSO2, Inc. >> lean . enterprise . middleware >> >> _______________________________________________ >> Dev mailing list >> [email protected] <javascript:_e(%7B%7D,'cvml','[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
