Ubuntu install issues, or bugs?

[loonsailor]

I installed labs 3.0b on ubuntu 8.04.  It works pretty well, which is kind of amazing considering that it's an 800Mhz, 512MB system (a new one shows up next week).  However, there are a few issues, and I'm not sure whether they're install problems or bugs.  Just for completeness, and for the next guy, I'll note a couple of things that I've already fixed.  I'm currently using the built-in derby database, rather than mySql.  (is there a good reason to switch soon?) 

The error messages are from alfresco.log.  I'm not sure if there are other logs that I should be checking. 

[size=125]1. pdf2swf[/size]
I was getting an error about pdf2swf:

 ERROR [org.alfresco.repo.content.transform.swf.PDFToSWFContentTransformer] Failed to start SWF2PDF transformer: 
Execution result: 
   os:         Linux
   command:    pdf2swf -V
   succeeded:  false
   exit code:  1
   out:        
   err:        Cannot run program "pdf2swf": java.io.IOException: error=2, No such file or directory
‍‍‍‍‍‍‍‍‍

I installed swftools (with synaptics) and no longer get this error.


[size=125]2. OpenOffice / file conversion[/size]
I'm having problems with OpenOffice.  I was getting this error:

ERROR [org.alfresco.util.exec.RuntimeExecBootstrapBean] Bootstrap command failed: 
Execution result: 
   os:         Linux
   command:    "/usr/bin/soffice" "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager" "-env:UserInstallation=file:////usr/local/Alfresco" -nologo -headless -nofirststartwizard -nocrashrep -norestore
   succeeded:  false
   exit code:  2
   out:        
   err:        Cannot run program ""/usr/bin/soffice"": java.io.IOException: error=2, No such file or directory
‍‍‍‍‍‍‍‍‍

I modified tomcat/shared/classes/alfresco/extension/bootstrap/openoffice-startup-context.xml, fixing the line that starts soffice so that it's now

<value><![CDATA[/usr/bin/soffice "-accept=socket…‍

The error is no longer logged, but I still get the following warning message:

09:20:30,494 WARN  [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
‍‍‍

I wouldn't worry about the warning, except that I can't seem to do a .doc to .pdf conversion, and I suspect that the lack of connection to OpenOffice is the reason.  When I try to convert name.doc to a pdf (show details / run action / transform and copy content) it makes a file called name.pdf, but it's still a word file, of identical size to the original.  It seems that the file is just being copied and rename instead of being transformed.


[size=125]3. Info / details bug[/size]
Those first two seem like installation problems, but the last thing seems like a bug to me.  Clicking the "details" icon from the "information" box doesn't work.  When I'm browsing the space, click "i" then click the "details" icon, it goes to a blank page.  When I'm looking at a file with the "My Spaces List" widget in my dashboard and I click "i" then "details", a new firefox tab appears, then instantly disappears.  However, when I click the "details" icon beneath the file while browsing the space (rather than from the information box) it works fine.

Thanks, in advance, for any help with these issues.  Of course, the nicest thing will be when the slfresco ubuntu package is complete, and all will magically just work!

[loonsailor]

Thanks for the advice, belmekki.  When I try to install openoffice.org, I get the message that I've already got the newest version.  Should I remove it, then reinstall?  Also, I've installed openoffice.org-headless as I saw suggested somewhere in the documentation.  Should I leave it, remove it, remove then reinstall?

BTW, I noticed that /usr/bin/soffice is a link, so I tried changing the command in the xml file to point to the link's target, /usr/lib/openoffice/program/soffice.  That is a script.  The result is identical.

Where will you post the file?  And, what do I do with it when you post it?

Thanks again.

[jgrocha]

To enable Open Office, I've edited
~/Alfresco$ gvim ./tomcat/shared/classes/alfresco/extension/bootstrap/openoffice-startup-context.xml
and just replaced 'soffice' with 'soffice.bin', and removed the commas.

Now it reads:

<value><![CDATA[/usr/lib/openoffice/program/soffice.bin "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager" "-env:UserInstallation=file:////usr/lib/openoffice" -nologo -headless -nofirststartwizard -nocrashrep -norestore]]></value>

I've inserted and *.odt and converted it successfully to PDF within Alfresco.
I'm using Alfresco Labs, version 3.0, ubuntu 8.10, Open Office 3.0
I think this error just started after using JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun-1.5.0.16
Previously, I was using JAVA_HOME=/usr/lib/jvm/java-6-sun, but with this one the Alfresco versioning feature was not working.

[loonsailor]

Thanks, jgrocha & belmeki.  I am out of town, but hopefully will be able to have a look at this tonight or tomorrow.  I'll post what I find.

[loonsailor]

I've fixed the Openoffice / file conversion problem.  There seems to be a bug in tomcat/shared/classes/alfresco/extension/bootstrap/openoffice-startup-context.xml.  I modified the CDATA line, removing all the quotes which were screwing it up, and opening soffice.bin directly.  It now reads

 <value><![CDATA[/usr/lib/openoffice/program/soffice.bin -accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager -env:UserInstallation=file:////usr/lib/openoffice -nologo -headless -nofirststartwizard -noc
rashrep -norestore]]></value>‍‍

File conversion works fine now, and there are no openoffice-related error or warning messages.

The info box problem, that I listed as problem #3 in my original post, persists.  Does anybody else have this problem?  Is it fixed in the enterprise version?

Also, I've written an init.d startup script.  I'll add it as a separate post.

[gmatyi]

I've fixed the Openoffice / file conversion problem.  There seems to be a bug in tomcat/shared/classes/alfresco/extension/bootstrap/openoffice-startup-context.xml.  I modified the CDATA line, removing all the quotes which were screwing it up, and opening soffice.bin directly.  It now reads

 <value><![CDATA[/usr/lib/openoffice/program/soffice.bin -accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager -env:UserInstallation=file:////usr/lib/openoffice -nologo -headless -nofirststartwizard -noc
rashrep -norestore]]></value>‍‍

File conversion works fine now, and there are no openoffice-related error or warning messages.

The info box problem, that I listed as problem #3 in my original post, persists.  Does anybody else have this problem?  Is it fixed in the enterprise version?

Also, I've written an init.d startup script.  I'll add it as a separate post.

Hi!

I had the same problem. But after I modified the tomcat/shared/classes/alfresco/extension/bootstrap/openoffice-startup-context.xml file as you mentioned, I see this lines in the alfresco.log

01:26:56,620 WARN  [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
01:26:56,688 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.5.0_16-b02; maximum heap size 455.125MB
01:26:56,688 WARN  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - WARNING - maximum heap size 455.125MB is less than recommended 512MB
01:26:56,689 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Labs): Current version 3.0.0 (c 1342) schema 1000 - Installed version 3.0.0 (c 1342) schema 1000
01:26:57,010 WARN  [org.alfresco.linkvalidation.LinkValidationServiceImpl] LinkValidationService Update is not running (virtualization server not registered or started)

I tryed to solve this problem with writing  a start_oo.sh

#!/bin/sh
/usr/lib/openoffice/program/soffice.bin "-accept=socket,host=localhost,port=8100; urp;StarOffice.ServiceManager" "-env:UserInstallation=file:////usr/lib/openoffice" -nologo -headless -no
firststartwizard -nochrashrep -norestore&
‍‍‍‍

but If I start this start_oo.sh before I start the alf_start.sh, I get these error in the alfresco.log

12:51:04,951 ERROR [org.quartz.core.JobRunShell] Job DEFAULT.openOfficeConnectionTesterJobDetail threw an unhandled Exception:
net.sf.jooreports.openoffice.connection.OpenOfficeException: connection failed: socket,host=localhost,port=8100,tcpNoDelay=1; com.sun.star.lang.DisposedException: java_remote_bridge com.
sun.star.lib.uno.bridges.java_remote.java_remote_bridge@713c3100 is disposed

12:51:04,961 ERROR [org.quartz.core.ErrorLogger] Job (DEFAULT.openOfficeConnectionTesterJobDetail threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: net.sf.jooreports.openoffice.connection.OpenOfficeException: connection failed: socket,host=localh
ost,port=8100,tcpNoDelay=1; com.sun.star.lang.DisposedException: java_remote_bridge com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge@713c3100 is disposed]

Do you have anyody an idea how to resolve it?

[loonsailor]

Make sure that the "alfresco" user (or whatever UID you're using to run alfresco) can get to openoffice, at the location specified in the startup line.  In my ubuntu, for some reason one of the directories in the openoffice tree was read-only and owned by root, so that alfresco running as the alfresco user (and not root) couldn't start it. If you have this problem, go down the open office directory tree (/usr/lib/openoffice/program on my computer) and make sure everything can be read and executed by everyone.

You might also look at my other post http://forums.alfresco.com/en/viewtopic.php?f=8&t=15346 which gives a couple more suggestions about alfresco on ubuntu.

[vipo]

I've had the same problems on Ubuntu 8.04 LTS and Alfresco 3.0.0 (c 1342) schema 1000.

There are 2 problems:
1.) openoffice-startup-context.xml
had to use <![CDATA[/usr/lib/openoffice/program/soffice "-accept=… no commas around /usr/lib/openoffice/program/soffice to get rid off the error message "Cannot run program ""/usr/lib/openoffice/program/soffice"": java.io.IOException: error=2, No such file or directory"

But still soffice would not be loaded.

2.) permission (access denied) for /usr/lib/openoffice/
This is caused from "-env:UserInstallation=file:////usr/lib/openoffice".
The directory /usr/lib/openoffice/ is only accessible for the root user. I have tried to give another directory (e.g. /home/alfresco), but with no luck. soffice will not start up (but there are no errors in the logfile, except the Warning "WARN  [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established"

so i decided to start OpenOffice within /etc/init.d/alfresco (the debian/ubuntu way) using this shell-function:

start_openoffice(){
        sudo -E -H -u alfresco /usr/lib/openoffice/program/soffice "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager" -nologo  -headless -nofirststartwizard &
}

within the Ubuntu startscript from Joost Horward (found in the Wiki).

So my modifications only prevent error-entries in the logfile, but do not start OpenOffice during the Catalina bootstrap (there are no error indicators in the logfiles showing why soffice could not be started).

[pasteur77]

I've the same problem in Ubuntu 8.10 but I don't think there is an access problem.
In my machine I notice that install script create no "alfresco" user or group and everyone has execution abilty on "/usr/lib/openoffice/program/soffice"

Can be this information usefull?

[loonsailor]

I've the same problem in Ubuntu 8.10 but I don't think there is an access problem.
In my machine I notice that install script create no "alfresco" user or group and everyone has execution abilty on "/usr/lib/openoffice/program/soffice"

The access problem I had wasn't with /usr/lib/openoffice/program/soffice.  It was with one of the directories higher in the path, so that alfresco user couldn't reach /usr/lib/openoffice/program/soffice.  I don't remember which directory it was - maybe /usr/lib/openoffice?