Editar con GoogleDocs

[carlosescriva]

Hola tengo problemas al utilizar GoogleDocs.

Estoy trabajando con la versión Alfresco Community 4.2.f y he implementado la versión alfresco-googledocs-share-2.0.7-18com.

El problema es que cada vez que intento crear con GoogleDocs el programa me pide autorizar desde la dirección https://accounts.google.com. El hecho es que acepto y después de intentar la autorización da un Web Script Status 500 - Internal Error.

Pego el contenido del mensaje de error:

"The Web Script /alfresco/s/googledocs/completeauth has responded with a status of 500 - Internal Error.

500 Description:   An error inside the HTTP server which prevented it from fulfilling the request.

Message:   072763377 Wrapped Exception (with status template): I/O error: Connection to https://accounts.google.com refused; nested exception is org.apache.http.conn.HttpHostConnectException: Connection to https://accounts.google.com refused
   
Exception:   java.net.ConnectException - Connection timed out: connect
   
   java.net.DualStackPlainSocketImpl.connect0(Native Method)
   java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
   java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
   java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
   java.net.AbstractPlainSocketImpl.connect(Unknown Source)
   java.net.PlainSocketImpl.connect(Unknown Source)
   java.net.SocksSocketImpl.connect(Unknown Source)
   java.net.Socket.connect(Unknown Source)
   sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
   org.apache.http.conn.ssl.SSLSocketFactory.connectSocket(SSLSocketFactory.java:375)
   org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:148)
   org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:149)
   org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:121)
   org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:561)
   org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:415)
   org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:820)
   org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:754)
   org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:732)
   org.springframework.social.support.HttpComponentsClientHttpRequest.executeInternal(HttpComponentsClientHttpRequest.java:81)
   org.springframework.http.client.AbstractClientHttpRequest.execute(AbstractClientHttpRequest.java:52)
   org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:438)
   org.springframework.web.client.RestTemplate.execute(RestTemplate.java:401)
   org.springframework.web.client.RestTemplate.postForObject(RestTemplate.java:279)
   org.springframework.social.oauth2.OAuth2Template.postForAccessGrant(OAuth2Template.java:228)
   org.springframework.social.oauth2.OAuth2Template.exchangeForAccess(OAuth2Template.java:133)
   org.alfresco.integrations.google.docs.service.GoogleDocsServiceImpl.completeAuthentication(GoogleDocsServiceImpl.java:536)
   sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   java.lang.reflect.Method.invoke(Unknown Source)
   org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
   org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
   org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
   org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:161)
   org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   com.sun.proxy.$Proxy326.completeAuthentication(Unknown Source)
   org.alfresco.integrations.google.docs.webscripts.CompleteAuth.executeImpl(CompleteAuth.java:67)
   org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)
   org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:429)
   org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:452)
   org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:491)
   org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:529)
   org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:341)
   org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)
   org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
   org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
   org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
   org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
   org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
   org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
   org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
   org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
   org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
   org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
   org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
   org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
   org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
   org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
   org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2441)
   org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2430)
   java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
   java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   java.lang.Thread.run(Unknown Source)
   
Exception:   org.apache.http.conn.HttpHostConnectException - Connection to https://accounts.google.com refused
   
   org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:158)
   
Exception:   org.springframework.web.client.ResourceAccessException - I/O error: Connection to https://accounts.google.com refused; nested exception is org.apache.http.conn.HttpHostConnectException: Connection to https://accounts.google.com refused
   
   org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:453)
   
Exception:   org.springframework.extensions.webscripts.WebScriptException - 072763377 Wrapped Exception (with status template): I/O error: Connection to https://accounts.google.com refused; nested exception is org.apache.http.conn.HttpHostConnectException: Connection to https://accounts.google.com refused
   
   org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1067)
   
Server:   Community v4.2.0 (r63893-b12) schema 6.033
Time:   27/08/2014 09:01:14
   
Diagnostics:   Inspect Web Script (org/alfresco/integrations/google/docs/CompleteAuth.get)"

A ver si se os ha dado este error alguna vez y me decis como solucionarlo.

Un dato más, nuestra empresa corre detrás de un proxy, por si fuese este el problema.

Muchas gracias.

[cristinamr]

Una pregunta, ¿has probado desde el servidor a hacer un ping a  https://accounts.google.com ? Porque tiene toda la pinta que sea el proxy.

Un saludo.

[carlosescriva]

Hola CristinaMR perdón por la tardanza, efectivamente parece ser el proxy. De todas formas parece que a la organización ya no le interesa que se edite con GoogleDocs, por lo tanto se ha desechado la idea.

Gracias.