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
