Alfresco 5.1 OpenOffice not running

rmeske 2016-04-07 22:26:29 UTC #1

Hello,

The transforms are not working and when I checked the log it is showing they cannot connect to OpenOffice on port 8100.

It looks like OpenOffice is not starting at all.

Where in the configuration can I find where openoffice is started or how do I check that it is starting properly?

Regards,
Ron

jariza 2016-04-11 11:46:00 UTC #2

Hi @rmeske

You can check if OpenOffice is running with the commands:

ps aux | grep soffice.bin
netstat -punta | grep soffice.bin

You will find information about the process which is running OpenOffice and which port and socket is listening at.
If you wan to start|stop OpenOffice please rename the script found at /installdir/libreoffice/scripts/

mv /installdir/libreoffice/scripts/libreoffice_ctl.sh /installdir/libreoffice/scripts/ctl.sh

After that, you can start|stop|restart OpenOffice as you do with Apache, MySQL and other services using /installdir/ctlscript.sh:

./installdir/ctlscript.sh start|stop|restart

Regards,

Juan

rmeske 2016-04-11 17:26:30 UTC #3

Hi @jariza,

Below I am ging to provide the output of using ctlscript.sh for stopping and starting the services. I first stopped all and the started again.

Stop

Syntax OK
/opt/bitnami/apache2/scripts/ctl.sh : httpd stopped
Using CATALINA_BASE:   /opt/bitnami/apache-tomcat
Using CATALINA_HOME:   /opt/bitnami/apache-tomcat
Using CATALINA_TMPDIR: /opt/bitnami/apache-tomcat/temp
Using JRE_HOME:        /opt/bitnami/java
Using CLASSPATH:       /opt/bitnami/apache-tomcat/bin/bootstrap.jar:/opt/bitnami                                 /apache-tomcat/bin/tomcat-juli.jar
Using CATALINA_PID:    /opt/bitnami/apache-tomcat/temp/catalina.pid
Tomcat did not stop in time.
To aid diagnostics a thread dump has been written to standard out.
Killing Tomcat with the PID: 1266
The Tomcat process has been killed.
/opt/bitnami/apache-tomcat/scripts/ctl.sh : tomcat stopped
/opt/bitnami/mysql/scripts/ctl.sh : mysql stopped

Start

160411 09:26:33 mysqld_safe Logging to '/opt/bitnami/mysql/data/mysqld.log'.
160411 09:26:33 mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
/opt/bitnami/mysql/scripts/ctl.sh : mysql  started at port 3306
Using CATALINA_BASE:   /opt/bitnami/apache-tomcat
Using CATALINA_HOME:   /opt/bitnami/apache-tomcat
Using CATALINA_TMPDIR: /opt/bitnami/apache-tomcat/temp
Using JRE_HOME:        /opt/bitnami/java
Using CLASSPATH:       /opt/bitnami/apache-tomcat/bin/bootstrap.jar:/opt/bitnami/apache-tomcat/bin/tomcat-juli.jar
Using CATALINA_PID:    /opt/bitnami/apache-tomcat/temp/catalina.pid
Tomcat started.
/opt/bitnami/apache-tomcat/scripts/ctl.sh : tomcat started
Syntax OK
/opt/bitnami/apache2/scripts/ctl.sh : httpd started at port 80

As you can see it doesn't look like OpenOffice is started, or at least doesn't echo anything.

When I run ps aux | greg soffice.bin I recieve:

username    4221  0.0  0.1  11748  2224 pts/0    S+   09:18   0:00 grep --color=auto soffice.bin

When I run sudo netstat -punta | grep soffice.bin I do not receive any output.

I renamed libreoffice_ctl.sh to ctl.sh and the tried stopping openoffice just to check. It echoed:

/opt/bitnami/libreoffice/scripts/ctl.sh : libreoffice not running

I then tried to start openoffice and it outputs:

 /opt/bitnami/libreoffice/scripts/ctl.sh : libreoffice could not be started

I then tried to start as a service with daemon and it did not output anything. Using status as a parameter it output:

libreoffice not running

I confirmed with netstat that it was not listening on any ports. The last thing I tried was to restart the server. Libreoffice still does not start.

Lastly, I tried starting from the command line and received an error:

sudo /opt/bitnami/libreoffice/program/soffice --nologo --headless --nofirststartwizard --accept='socket,host=127.0.0.1,port=8100,tcpNoDelay=1;urp'
/opt/bitnami/libreoffice/program/oosplash: error while loading shared libraries: libXinerama.so.1: cannot open shared object file: No such file or directory

EDIT: In searching for a solution it appears the following package is required:

apt-get install libxinerama1

When I install that I get a new message the

sudo ./soffice --nologo --headless --nofirststartwizard --accept='socket,host=127.0.0.1,port=8100,tcpNoDelay=1;urp;StarOffice.Service'
javaldx: Could not find a Java Runtime Environment!
Warning: failed to read path from javaldx
/opt/bitnami/libreoffice/program/.soffice.bin: error while loading shared libraries: libcups.so.2: cannot open shared object file: No such file or directory

In looking for libcups I found:

32-bit Debian or Ubuntu : apt-get install libcups2
64-bit Debian or Ubuntu : apt-get install libcups2:i386

In reading the package descriptions I am wondering why these are being required when I am running on a server. Is it possibly a bad install of LibreOffice?

I went back and uninstalled libxinerama1 and installed libxinerama1:i386, thinking perhaps I had installed the incorrect one and that then gave the original error of it being missing.

My system is Ubuntu 14.04.4 LTS (GNU/Linux 4.2.0-35-generic x86_64) running on an Intel Core2 Duo.

Any suggestions on how to get LibreOffice running?

Regards,
Ron

rmeske 2016-04-12 00:49:12 UTC #4

The solution to get OpenOffice (LibreOffice working) consisted of the following steps:

Install missing packages:
sudo apt-get install libxinerama1
sudo apt-get install libcups2
sudo apt-get install libfontconfig1
Rename the libreoffice_ctl.sh to ctl.sh. It is located at: /installdir/libreoffice/scripts/
Edit the libreoffice ctl.sh and modify the following line:

SOFFICE="$SOFFICEWRAPPER --nofirststartwizard --nologo --headless --accept=socket,host=localhost,port=$SOFFICE_PORT\;urp\;StarOffice.ServiceManager"

add double quotes around accept parameter:

SOFFICE="$SOFFICEWRAPPER --nofirststartwizard --nologo --headless "--accept=socket,host=localhost,port=$SOFFICE_PORT\;urp\;StarOffice.ServiceManager""

jariza 2016-04-12 10:59:30 UTC #5

Hi @rmeske

We are glad to find that you could solve your issue. Thanks for sharing this solution with the community.
I could not reproduce your issue since I could use the script without double quoting the parameters.

As you mentioned, some libraries are needed to use OpenOffice. You can find more information here:
https://wiki.bitnami.com/Components/Libreoffice

We will include a Validation in our installers to check if those libraries are missing.

Regards,

Juan

rmeske 2016-04-12 13:39:01 UTC #6

Hi @jariza,

The double quotes being needed are mentioned in the Alfresco user forums, the Libreoffice forums, and a variety of other sites. I feel it would be best if you include them by default in your config as there doesn't seem to be anyone that has found a problem with them breaking anything.

Another issue came up with open office. The soffice service was running at about 100% of CPU constantly. I let it run for 12 hours thinking it may be catching up on tasks but it didn't stop. In searching the Alfresco forums I found a solution that involves stopping the service and then starting it again. This has fixed the issue and I have not seen any side effects.

It would be helpful if your image has this solution of stopping the service after a few minutes and then restarting it.

https://forums.alfresco.com/forum/installation-upgrades-configuration-integration/installation-upgrades/sofficebin-using-100-cpu

Regards,
Ron

LibreOffice (soffice) using 100% CPU

jariza 2016-04-13 16:34:43 UTC #7

Hi @rmeske

Thanks for reporting this issue, I could reproduce it and apparently it only affects to native installers. We really appreciate your collaboration. We will open a task to look into it and we'll decide if we include this solution on our Alfresco products.

Regards,

Juan

jariza 2016-04-14 13:41:39 UTC #8

Hi @rmeske

There was not any problem with libreOffice and CPU capacity.

We provide Alfresco already configured to work with libreOffice and the application is able to start and stop libreOffice depending if it needs it or not. That is the reason why the name of the script found at libreoffice/scripts/ was libreoffice-ctl.sh, this way we excluded it from the general ctlscript.sh.

When you renamed the script in order to be able to access to it through the /opt/bitnami/ctlscript.sh and you ran "./ctlscript.sh start", it broke. The reason is that Alfresco tries to start libreOffice which is already started and the problem with the CPU capacity appeared. However, if you do not rename that file, the problem never appears.

Sorry for the wrong information. I apologize.

Summing up:
1 - Do not rename the script found at /opt/bitnami/libreoffice/scripts/
2 - Alfresco is able to start|stop libreOffice when needed.
3 - You can use the script for stopping libreOffice if it starts to have CPU capacity problems for any other reason or for checking if it is running.

Regards,

Juan

rmeske 2016-04-14 17:46:32 UTC #9

Hi @jariza,

So the solution needs to be modified from my original.

The change is to not rename libreoffice_ctl.sh to ctl.sh and edit. Instead just edit libreoffice_ctl.sh to include the double-quotes around the --accept parameter.

If I am understanding correctly, the missing packages for LibreOffice will be addressed in future Bitnami installers and is only a short-term fix as needed as is editing for the double quotes.

I have tested and soffice now starts and stops automatically as needed by Alfresco.

Now I can look through and identify what the remaining issues are.

Best Regards,
Ron

todachuy2406 2016-10-04 05:47:39 UTC #10

I did anything in your guideline, but still show this following error
[root@dms tmp]# service alfresco restart
Using CATALINA_BASE: /opt/alfresco-community/tomcat
Using CATALINA_HOME: /opt/alfresco-community/tomcat
Using CATALINA_TMPDIR: /opt/alfresco-community/tomcat/temp
Using JRE_HOME: /opt/alfresco-community/java
Using CLASSPATH: /opt/alfresco-community/tomcat/bin/bootstrap.jar:/opt/alfresco-community/tomcat/bin/tomcat-juli.jar
Using CATALINA_PID: /opt/alfresco-community/tomcat/temp/catalina.pid
Tomcat stopped.
/opt/alfresco-community/tomcat/scripts/ctl.sh : tomcat stopped
ps: /opt/alfresco-community/common/lib/libz.so.1: no version information available (required by /lib64/libdw.so.1)
/opt/alfresco-community/libreoffice/scripts/ctl.sh : libreoffice not running
waiting for server to shut down..... done
server stopped
/opt/alfresco-community/postgresql/scripts/ctl.sh : postgresql stopped
waiting for server to start.... done
server started
/opt/alfresco-community/postgresql/scripts/ctl.sh : postgresql started at port 5432
ps: /opt/alfresco-community/common/lib/libz.so.1: no version information available (required by /lib64/libdw.so.1)
ps: /opt/alfresco-community/common/lib/libz.so.1: no version information available (required by /lib64/libdw.so.1)
/opt/alfresco-community/libreoffice/scripts/ctl.sh : libreoffice could not be started
Using CATALINA_BASE: /opt/alfresco-community/tomcat
Using CATALINA_HOME: /opt/alfresco-community/tomcat
Using CATALINA_TMPDIR: /opt/alfresco-community/tomcat/temp
Using JRE_HOME: /opt/alfresco-community/java
Using CLASSPATH: /opt/alfresco-community/tomcat/bin/bootstrap.jar:/opt/alfresco-community/tomcat/bin/tomcat-juli.jar
Using CATALINA_PID: /opt/alfresco-community/tomcat/temp/catalina.pid
Tomcat started.
/opt/alfresco-community/tomcat/scripts/ctl.sh : tomcat started

marcos 2016-10-12 10:04:13 UTC #11

Hi @todachuy2406,

Is the error reproducible? That is, could you try to start LibreOffice again? You could also check for already running LibreOffice proceses with ps aux | grep libreoffice, and kill the LibreOffice processes with kill PID (PID is the LibreOffice process ID).

You could try to start LibreOffice in foreground and show us which error you get:

$ /opt/bitnami/libreoffice/program/soffice.bin --nofirststartwizard --nologo --headless --accept=socket,host=localhost,port=8100\;urp\;StarOffice.ServiceManager

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!