AnsweredAssumed Answered

Configuration for JBoss, JBoss working but configuration not

Question asked by edk on Feb 12, 2009
Latest reply on Feb 14, 2009 by edk
I have been attempting to configure Alfresco running under JBoss, but no configuration changes make any difference!

Working Test
For my test case, I installed Alfresco and JBoss straight out of the box, with minimal configuration:
  • extract alfresco-labs-war-3Stable.zip

  • extract jboss-4.2.3.GA.zip

  • copy alfresco.war and share.war from alfresco-labs-war-3Stable.zip to jboss-4.2.3.GA/server/default/deploy

  • copy mysql-connector-java-5.1.7-bin.jar to jboss-4.2.3.GA/server/default/lib

  • create link from jboss-4.2.3.GA to jboss mostly for my convenience

  • create mysql database: mysqladmin -u root create alfresco

  • set permissions: echo "grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;" | mysql -u root

  • Flush the privileges: mysqladmin -u root flush-privileges

  • edit Alfresco/jboss/bin/run.sh, Alfresco/jboss/server/default/deploy/ejb3.deployer/META-INF/persistence.properties, Alfresco/jboss/server/default/deploy/jboss-web.deployer/conf/web.xml as the following diff file suggests:

diff -u -r Alfresco-org/jboss/bin/run.sh Alfresco/jboss/bin/run.sh
— Alfresco-org/jboss/bin/run.sh   2009-02-11 19:40:47.000000000 -0500
+++ Alfresco/jboss/bin/run.sh   2009-02-11 19:57:51.000000000 -0500
@@ -5,6 +5,9 @@
##                                                                          ##
### ====================================================================== ###

+JAVA_HOME="/home/ed/local/jdk1.6.0_11"
+JAVA_OPTS="-Xms512m -Xmx1G -XX:MaxPermSize=128m -server -Dorg.apache.catalina.STRICT_SERVLET_COMPLIANCE=false"
+
### $Id: run.sh 75849 2008-07-15 18:43:17Z dimitris@jboss.org $ ###

DIRNAME=`dirname $0`
diff -u -r Alfresco-org/jboss/server/default/deploy/ejb3.deployer/META-INF/persistence.properties Alfresco/jboss/server/default/deploy/ejb3.deployer/META-INF/persistence.properties
— Alfresco-org/jboss/server/default/deploy/ejb3.deployer/META-INF/persistence.properties   2008-07-18 14:21:02.000000000 -0400
+++ Alfresco/jboss/server/default/deploy/ejb3.deployer/META-INF/persistence.properties   2009-02-11 19:57:51.000000000 -0500
@@ -14,4 +14,4 @@
hibernate.jndi.java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces
hibernate.bytecode.use_reflection_optimizer=false
# I don't think this is honored, but EJB3Deployer uses it
-hibernate.bytecode.provider=javassist
\ No newline at end of file
+hibernate.bytecode.provider=cglib
diff -u -r Alfresco-org/jboss/server/default/deploy/jboss-web.deployer/conf/web.xml Alfresco/jboss/server/default/deploy/jboss-web.deployer/conf/web.xml
— Alfresco-org/jboss/server/default/deploy/jboss-web.deployer/conf/web.xml   2008-07-18 14:21:02.000000000 -0400
+++ Alfresco/jboss/server/default/deploy/jboss-web.deployer/conf/web.xml   2009-02-11 19:57:51.000000000 -0500
@@ -59,16 +59,20 @@

    <!– Configures JSF for a web application if the javax.faces.webapp.FacesServlet is declared –>
    <!– in web.xml.                                                                             –>
+   <!–
    <listener>
      <listener-class>org.jboss.web.jsf.integration.config.JBossJSFConfigureListener</listener-class>
    </listener>
+   –>

    <!– Listens to all web app lifecycle events so that @PreDestroy can be called on –>
    <!– JSF managed beans that go out of scope.  You can comment this out if you     –>
    <!– don't use JSF or you don't use annotations on your managed beans.            –>
+   <!–
    <listener>
      <listener-class>com.sun.faces.application.WebappLifecycleListener</listener-class>
    </listener>
+   –>


   <!– ================== Built In Servlet Definitions ==================== –>
  • start alfresco with: ./jboss/bin/run.sh >run1.log &
It runs, but not perfect, showing errors of:
  • 20:09:35,097 INFO  [STDOUT] 20:09:35,097 User:System WARN  [alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.

  • Cannot run program "./ImageMagick/bin/convert": java.io.IOException: error=2, No such file or directory

  • Cannot run program "./bin/pdf2swf": java.io.IOException: error=2, No such file or directory
Configuration Setup
So, now lets say that I want to change the login for the MySQL database. Following the directions on this page: http://wiki.alfresco.com/wiki/Repository_Configuration#What_Can_Be_Set.3F I should be able to create the file jboss/server/default/conf/props/alfresco/extension/custom-repository.properties with the contents of:
db.username=alfresco3
db.password=alfresco3ERROR
I have also tried the properties file at jboss/server/default/conf/alfresco/custom-repository.properties.

I would expect an error, showing that the password "alfresco3ERROR" is an invalid login account. Also changes to the following parameters have no affect:
  • ooo.exe=

  • ooo.user=

  • img.root=

  • swf.exe=

  • db.driver=

  • db.url=
Am I putting the property file in the proper location?

Outcomes