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] >>>>> <[email protected]></username>* >>>>> * <password>wso2carbon</password>* >>>>> * </googlespreadsheet.usernameLogin>* >>>>> * <googlespreadsheet.getAllSpreadsheets >>>>> configKey="MyGSConfig"/>* >>>>> * <respond/>* >>>>> * </inSequence>* >>>>> * </target>* >>>>> * </proxy>* >>>>> * <localEntry key="MyGSConfig">* >>>>> * <googlespreadsheet.usernameLogin>* >>>>> * <username>[email protected] <[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.
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
