OpenACS Configuration

1. Install JDK
   # apt-get install sun-java5-jdk
2. Install mysql
   # apt-get install mysql-server

3. Install Java database (JDBC) driver
   # apt-get install libmysql-java
   
   
4. Setting up the user to use JDBC
   # export CLASSPATH=$CLASSPATH:/usr/share/java/mysql.jar
   
   
5. Install JBOSS (JBOSS installation guide) either way:
   a) download and unzip jboss-4.2.3-GA.zip
   b) download jboss-4.2.3-GA-src.tar.gz and built it using Apache ANT
   c) use jems-installer:
   # java -jar jems-installer-1.2.1.CR4.jar
   
   
6. Test the JBOSS installation
   # run.sh
   Make sure the followed:
   a) $JBOSS_HOME, $PATH are correctly configured in bashrc file
   b) /etc/hostname can be correctly resolved
   $JBOSS_HOME/server/default/log would be helpful to see what's wrong with the configurations
   
   
7. Make sure JDBC driver mysql-connector-java.jar is located in $JBOSS_HOME/server/default/lib
   
   
8. Download and unpack OpenACS binary
   # unzip openacs-bin-0.02.zip
   
   
9. Create an mysql account and database for OpenACS
   # mysql -p
   mysql> create database ACS;
   mysql> grant all on ACS.* to openacs_user identified by ‘openacs_pw’
   
   
10. Deploy OpenACS
    # cp openacs/openacs-ds.xml $JBOSS_HOME/server/default/deploy/
    # cp openacs/acs.ear $JBOSS_HOME/server/default/deploy/
    # cp openacs/openacs-service.xml $JBOSS_HOME/server/default/deploy/jms/
    Modify connection-url, user-name, password in openacs-ds.xml
    
    
11. Run JBOSS
    # run.sh
    Disable JBOSS CREATE_TABLES_ON_STARTUP if getting an error "java.sql.SQLException: Table already exists"
    file: $JBOSS_HOME/server/default/deploy/jms/hsqldb-jdbc2-service.xml
    
    
12. Web interface is accessible at http://your.server.ip:8080/openacs/index.jsf.