Tuesday 13 September 2011

The OpenOffice connection has been lost

Whenever I tried to restart alfresco on fedora 14, I used to get these errors in alfresco logs.

An initial OpenOffice connection could not be established. 
The OpenOffice connection was re-established.
The OpenOffice connection has been lost.
And the results was, not able get the preview of the documents uploaded in share.
So, here are steps which I carried out to get the issue resolved:
  1.  In .../alfresco/tomcat/shared/classes/alfresco-global.properties replace the values as per your environment
          ### External executable locations ###
          ooo.enabled=true
          ooo.exe=.../openoffice.org3/program/soffice.bin
          img.root=.../alfresco/common
          img.dyn=${img.root}/lib
          img.exe=${img.root}/bin/convert
          swf.exe=/apps/alfresco/common/bin/pdf2swf\

     2. To run openoffice as daemon, create file openoffice.sh and copy the script given below.
         #!/bin/bash
         # openoffice.org headless server script
         # chkconfig: 2345 80 30
         # description: headless openoffice server script
         # processname: openoffice
         # Author: Vic Vijayakumar
         # Modified by Federico Ch. Tomasczik
         #
         OOo_HOME=/usr/bin
         SOFFICE_PATH=.../openoffice.org3/program/soffice
         PIDFILE=/var/run/openoffice-server.pid

         set -e

         case "$1" in
         start)
         if [ -f $PIDFILE ]; then
         echo "OpenOffice headless server has already started."
         sleep 5
         exit
         fi
         echo "Starting OpenOffice headless server"
         $SOFFICE_PATH -headless -nologo -nofirststartwizard -           accept="socket,host=127.0.0.1,port=8100;urp" & > /dev/null 2>&1
         touch $PIDFILE
         ;;
         stop)
         if [ -f $PIDFILE ]; then
         echo "Stopping OpenOffice headless server."
         killall -9 soffice && killall -9 soffice.bin
         rm -f $PIDFILE
         exit
         fi
         echo "Openoffice headless server is not running."
         exit
         ;;
         *)
         echo "Usage: $0 {start|stop}"
         exit 1
         esac
         exit 0
         *************

(Thanks for the script Vic Vijayakumar,  Federico Ch. & Tomasczik)
Save the file in /etc/init.d/openoffice.sh and give executable permission.

     3. Sartt the openoffice headless
         # /etc/init.d/openoffice.sh start

     4. Start Alfresco

Hope this works good for you too.