topic Erreur intégration Google Docs in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/erreur-int%C3%A9gration-google-docs/m-p/195316#M148446 <HTML><HEAD></HEAD><BODY><SPAN>Bonjour,</SPAN><BR /><BR /><SPAN>J'ai installé la version Linux de Community 4.2.c sur un serveur ubuntu.</SPAN><BR /><SPAN>J'ai installé la vesion 2.0.3 de Google Docs.</SPAN><BR /><SPAN>Lorsque j'essaie de créer un contenu de type Google Docs, j'ai l'erreur suivante : </SPAN><BR /><BR /><SPAN>Web Script Status 500 - Internal Error</SPAN><BR /><BR /><SPAN>The Web Script /alfresco/s/googledocs/completeauth has responded with a status of 500 - Internal Error.</SPAN><BR /><BR /><SPAN>500 Description:&nbsp;&nbsp;&nbsp;An error inside the HTTP server which prevented it from fulfilling the request.</SPAN><BR /><SPAN> &nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>Message:&nbsp;&nbsp;&nbsp;09230002 Wrapped Exception (with status template): I/O error: accounts.google.com: Nom ou service inconnu; nested exception is java.net.UnknownHostException: accounts.google.com: Nom ou service inconnu</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>Exception:&nbsp;&nbsp;&nbsp;java.net.UnknownHostException - accounts.google.com: Nom ou service inconnu</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:866)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1258)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;java.net.InetAddress.getAllByName0(InetAddress.java:1211)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;java.net.InetAddress.getAllByName(InetAddress.java:1127)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;java.net.InetAddress.getAllByName(InetAddress.java:1063)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.http.impl.conn.DefaultClientConnectionOperator.resolveHostname(DefaultClientConnectionOperator.java:242)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:130)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:149)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:121)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:561)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:415)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:820)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:754)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:732)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.social.support.HttpComponentsClientHttpRequest.executeInternal(HttpComponentsClientHttpRequest.java:81)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.http.client.AbstractClientHttpRequest.execute(AbstractClientHttpRequest.java:52)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:438)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.web.client.RestTemplate.execute(RestTemplate.java:401)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.web.client.RestTemplate.postForObject(RestTemplate.java:279)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.social.oauth2.OAuth2Template.postForAccessGrant(OAuth2Template.java:152)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.social.oauth2.OAuth2Template.exchangeForAccess(OAuth2Template.java:104)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.alfresco.integrations.google.docs.service.GoogleDocsServiceImpl.completeAuthentication(GoogleDocsServiceImpl.java:504)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.alfresco.integrations.google.docs.webscripts.CompleteAuth.executeImpl(CompleteAuth.java:63)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:433)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:433)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:495)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:533)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:349)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:377)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;javax.servlet.http.HttpServlet.service(HttpServlet.java:722)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1771)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;java.lang.Thread.run(Thread.java:722)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>Exception:&nbsp;&nbsp;&nbsp;org.springframework.web.client.ResourceAccessException - I/O error: accounts.google.com: Nom ou service inconnu; nested exception is java.net.UnknownHostException: accounts.google.com: Nom ou service inconnu</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:453)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>Exception:&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.WebScriptException - 09230002 Wrapped Exception (with status template): I/O error: accounts.google.com: Nom ou service inconnu; nested exception is java.net.UnknownHostException: accounts.google.com: Nom ou service inconnu</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1067)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>Server:&nbsp;&nbsp;&nbsp;Community v4.2.0 (4576) schema 6 022</SPAN><BR /><SPAN>Time:&nbsp;&nbsp;&nbsp;23 oct. 2013 15:53:25</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>Diagnostics:&nbsp;&nbsp;&nbsp;Inspect Web Script (org/alfresco/integrations/google/docs/CompleteAuth.get)</SPAN><BR /><BR /><BR /><BR /><BR /><BR /><SPAN>Au niveau de la configuration Google Docs dans le fichier alfresco-global.properties : </SPAN><BR /><BR /><SPAN># Enables google editable functionality</SPAN><BR /><SPAN>googledocs.googleeditable.enabled=true</SPAN><BR /><BR /><SPAN># Google docs application name</SPAN><BR /><SPAN>googledocs.application.name=Alfresco ECM system</SPAN><BR /><BR /><SPAN># Google docs URL (ne pas modifier cette adresse)</SPAN><BR /><SPAN># Google docs URL (ne pas modifier cette adresse)</SPAN><BR /><BR /><SPAN>googledocs.url=</SPAN><A href="https://docs.google.com/feeds/default/private/full" rel="nofollow noopener noreferrer">https://docs.google.com/feeds/default/private/full</A><BR /><SPAN>googledocs.downloadurl=</SPAN><A href="https://docs.google.com/feeds/download" rel="nofollow noopener noreferrer">https://docs.google.com/feeds/download</A><BR /><BR /><SPAN># System google docs authentication credentials</SPAN><BR /><SPAN>googledocs.username=USER</SPAN><BR /><SPAN>googledocs.password=PASSWORD</SPAN><BR /><BR /><SPAN># Google docs spreadsheet service name</SPAN><BR /><SPAN>googledocs.spreadsheet.service.name=wise</SPAN><BR /><SPAN>googledocs.spreadsheet.downloadurl=</SPAN><A href="https://spreadsheet.google.com/feeds/download" rel="nofollow noopener noreferrer">https://spreadsheet.google.com/feeds/download</A><BR /><BR /><SPAN>Et au niveau de la configuration Google Docs dans le fichier share-config-custom.xml:</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; &lt;config evaluator="string-compare" condition="DocumentLibrary" replace="true"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;google-docs&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;enabled&gt;true&lt;/enabled&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;creatable-types&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;creatable type="doc"&gt;application/msword&lt;/creatable&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;creatable type="xls"&gt;application/vnd.ms-excel&lt;/creatable&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;creatable type="ppt"&gt;application/vnd.ms-powerpoint&lt;/creatable&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/creatable-types&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/google-docs&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/config&gt;</SPAN><BR /><BR /><BR /><SPAN>Auriez-vous une idée du problème ?</SPAN></BODY></HTML> Wed, 23 Oct 2013 14:22:30 GMT cpillette 2013-10-23T14:22:30Z Erreur intégration Google Docs https://connect.hyland.com/t5/alfresco-archive/erreur-int%C3%A9gration-google-docs/m-p/195316#M148446 Bonjour,J'ai installé la version Linux de Community 4.2.c sur un serveur ubuntu.J'ai installé la vesion 2.0.3 de Google Docs.Lorsque j'essaie de créer un contenu de type Google Docs, j'ai l'erreur suivante : Web Script Status 500 - Internal ErrorThe Web Script /alfresco/s/googledocs/completeauth has Wed, 23 Oct 2013 14:22:30 GMT https://connect.hyland.com/t5/alfresco-archive/erreur-int%C3%A9gration-google-docs/m-p/195316#M148446 cpillette 2013-10-23T14:22:30Z Re: Erreur intégration Google Docs https://connect.hyland.com/t5/alfresco-archive/erreur-int%C3%A9gration-google-docs/m-p/195317#M148447 <HTML><HEAD></HEAD><BODY><SPAN>Bonjour,</SPAN><BR /><BR /><SPAN>"UnknownHostException: accounts.google.com"</SPAN><BR /><SPAN>Il y a 9 chances sur 10 pour que votre serveur ne sache pas résoudre l'adresse du service Google.</SPAN><BR /><SPAN>Bien vérifier que le serveur accède à internet, et au service nommé.</SPAN><BR /><BR /><SPAN>Un simple ping accounts.google.com (depuis le serveur) devrait vous en apprendre un peu plus.</SPAN><BR /><BR /></BODY></HTML> Wed, 23 Oct 2013 16:07:58 GMT https://connect.hyland.com/t5/alfresco-archive/erreur-int%C3%A9gration-google-docs/m-p/195317#M148447 michaelh 2013-10-23T16:07:58Z Re: Erreur intégration Google Docs https://connect.hyland.com/t5/alfresco-archive/erreur-int%C3%A9gration-google-docs/m-p/195318#M148448 <HTML><HEAD></HEAD><BODY><SPAN>Effectivement, l'erreur venait bien de là.</SPAN><BR /><SPAN>La mise à jour de la configuration du serveur DNS, ainsi que la mise à jour des règles de firewall (autorisation flux DNS + HTTP/HTTPS entrant et sortant) a résolu le problème.</SPAN><BR /><BR /><SPAN>Merci beaucoup.</SPAN></BODY></HTML> Thu, 31 Oct 2013 10:15:01 GMT https://connect.hyland.com/t5/alfresco-archive/erreur-int%C3%A9gration-google-docs/m-p/195318#M148448 cpillette 2013-10-31T10:15:01Z