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