How to configure Alfresco with the OpenOffice.org Plugin?

[daniel_andersso]

Hi  everyone!

I'm trying to use the Alfresco OpenOffice.org Plugin

I've got Microsoft Windows 2003 with Alfresco Community 2.9B and OpenOffice 2.4.1 as the client application.

It is written in README.TXT that Alfresco Enterprise 2.1.1 has been used for testing. Doesn't it work for Community Edition? Anyone got it working?

The "Web Client URL" and "WebDav URL" used in the plugin from within OpenOffice.org are working. I have not configured CIFS for the current Alfresco installation and would prefer not to. Does the plugin use CIFS? Isn't it supposed to use WebDav?

I get the following error message whem trying to use the plugin in OpenOffice:

The Web Script /alfresco/wcservice/openoffice/myAlfresco has responded with a status of 404 - Not Found.  

404 Description: Requested resource is not available.  
   
Message: Script url /openoffice/myAlfresco does not map to a Web Script.  
   
Exception: org.alfresco.web.scripts.WebScriptException - Script url /openoffice/myAlfresco does not map to a Web Script.  
    
 org.alfresco.web.scripts.AbstractRuntime.executeScript(AbstractRuntime.java:97)  
 org.alfresco.web.scripts.servlet.WebScriptServlet.service(WebScriptServlet.java:108)  
 javax.servlet.http.HttpServlet.service(HttpServlet.java:803)  
 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)  
 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)  
 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)  
 org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)  
 org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  
 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)  
 org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)  
 org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)  
 org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)  
 org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)  
 org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)  
 org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)  
 org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)  
 java.lang.Thread.run(Thread.java:619)  
    
Server: Alfresco Community Network v2.9.0 (B 683) schema 116  
Time: 2008-jul-07 12:25:15  
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks in advance
Best regards
Daniel Andersson

[dinger]

Have you completed the backend installation?

Rob

[daniel_andersso]

Have you completed the backend installation?

Rob

Well I ran the "bin/inst.cmd" as instructed in the README.TXT for the plugin.

Are other non-documented steps required?

The Web Client URL "http://localhost:8080/alfresco/"
and the Web WebDav URL "http://localhost:8080/alfresco/webdav/"
are reachable in the configuration of the plugin.
But the CIFS Server setting is empty.

[dinger]

I'm not sure (I have no experience with the plugin) but it looks like it's trying to access a webscript that isn't installed or is under a different path.

Look here: http://localhost:8080/alfresco/service/index/all and see if the webscript it's trying to access is listed (if not you need to figure out why the installer didn't set it up).

Rob

[daniel_andersso]

I'm not sure (I have no experience with the plugin) but it looks like it's trying to access a webscript that isn't installed or is under a different path.

Look here: http://localhost:8080/alfresco/service/index/all and see if the webscript it's trying to access is listed (if not you need to figure out why the installer didn't set it up).

Rob

I'm not sure what I am looking for, but there is a script named "My Alfresco (Office Add-In)" which is reachable at "http://localhost:8080/alfresco/service/office/myAlfresco?p={path?}" Is this the URL used for the Microsoft Office plugin?

The bin/inst.cmd only install files on the local OpenOffice installation. From the README.txt:

3. workaround to install registry "schema" and "defaults" if "bin/inst.cmd" fails from some reason
   - "cd" %OPENOFFICE_HOME%/share/registry/schema/
   - "mkdir" dirs "com/westernacher/openoffice/alfresco"
   - "copy" ../conf/registry.xcs to previously created folder
   - "cd" %OPENOFFICE_HOME%/share/registry/data/
   - "mkdir" dirs "com/westernacher/openoffice/alfresco"
   - "cp" ../conf/registry.xcu (registry defaults) to previously created folder‍‍‍‍‍‍‍‍

Any ideas on how to moving forward on solving this are very appreciated.

[mikeh]

The /office/myAlfresco webscript belongs to the Microsoft Office add-in, as you've guessed.

I also don't have experience with the OpenOffice add-in, but looking at the README.txt:

3. Installation
—————
Follow the installation instructions in install.txt (included in the prebuilt binaries).

IMPORTANT: The installation consists of two parts:

- Client side installation of the plugin.
- Deployment of webscripts and configuration files on the Alfresco server. (Described in "Backend Installation")

Make sure you install both!

It looks like you have completed the client side installation, but overlooked the webscripts deployment.


Mike

[daniel_andersso]

- Deployment of webscripts and configuration files on the Alfresco server. (Described in "Backend Installation")

Make sure you install both!

It looks like you have completed the client side installation, but overlooked the webscripts deployment.


Mike

Well that would explain the problem. But which README-file is this quote from Mike? The one I'm reading doesn't mention anything about a backend installation. I'm using the 1.0.0 version from the download page of the Project at forge.alfresco.org. Would you please post the URL to the installation files you are using.

[mikeh]

Well that would explain the problem. But which README-file is this quote from Mike? The one I'm reading doesn't mention anything about a backend installation. I'm using the 1.0.0 version from the download page of the Project at forge.alfresco.org. Would you please post the URL to the installation files you are using.

It's the README you linked in the original post.

Thanks,
Mike

[daniel_andersso]

It's the README you linked in the original post.

Thanks,
Mike

I assumed that README.TXT at the project download page and install.txt in the installation zip-file had the same content. Thanks Mike for pointing out this unnecessary mistake!