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
