This question has been flagged
2 Replies
5921 Views
Avatar
rosey

I have installed openoffice.org 3.4. I have placed report_aeroo, report_aeroo_ooo, report_aeroo_sample and installed all.

bzr branch lp:aeroolib

cd aeroolib/

sudo python ./setup.py install

Worked above commands.

But when i connect openoffice with aeroo report it shows below message.

Connection to OpenOffice.org instance was not established or convertion to PDF unsuccessful!

Avatar
Discard
Avatar
Atul Makwana
Best Answer

You have already installed aeroolib. I hope you have installed OpenERP Aeroo modules.
Now update openoffice script by running command

sudo nano /etc/init.d/openoffice.sh

and paste the below code in it.

OOo_HOME=/usr/bin
SOFFICE_PATH=$OOo_HOME/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

Now press ctrl + x to save and close the nano editor. Make the script executable and make it start automatically at boot by 

sudo chmod 0755 /etc/init.d/openoffice.sh
sudo update-rc.d openoffice.sh defaults
sudo /etc/init.d/openoffice.sh start

Now go to Settings->Customization->Aeroo Reports->Configure OpenOffice.org connection. Click Connect. it should shows the success message for connection. Courtesy: http://goo.gl/gRv8lG

Avatar
Discard
Avatar
wizardz
Best Answer

this is the right text for the script: 

#!/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=$OOo_HOME/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

Avatar
Discard