Installation

The following installation instructions assume that the installation is taking place on a unix OS using MySql as the database.

1.Download and Install JBoss

• Content Control runs on the JBoss application server. Before you can continue with the installation you need to ensure that JBoss is installed and running on your server.
• You can download JBoss from http://www.jboss.org/jbossas/downloads/. Please download the latest stable version.
• Once you have downloaded JBoss please follow the installation instructions on http://www.jboss.org/jbossas/docs/5-x.html

2. Create a new DB schema.

• Database specific.
  Please ensure that the new database user has full admin rights on the new database and is able to create and alter tables.
  For mysql you need to run the following commands to create your database with the correct priviledges:
  - mysql -u root -p
  -create database <SCHEMA>;
  -GRANT ALL PRIVILEGES ON <SCHEMA>.* to "<myDBUser>"@"localhost" identified by "<myDBPassword>";
  -GRANT ALL PRIVILEGES ON <SCHEMA>.* to "<myDBUser>"@"%" identified by "<myDBPassword>";
  -FLUSH PRIVILEGES;
   
• Please ensure that the JDBC Driver for your database is place in  <JBoss>/commom/lib directory and that JBoss has been restarted so that the driver is loaded.

3. Pre deploy setup

• Create an empty folder to install the application <CC_INSTALL>
• Expand the downloaded binary (ear file) into <CC_INSTALL>/cc7.ear
• Create a folder for the file store at <CC_INSTALL>/filestore
• Create a folder for the lucene index at <CC_INSTALL>/lucene
• Create DB tables:
  java -cp shell-tools-<version_number>-jar-with-dependencies.jar ccc.cli.Schema -u <myDBUser> -p <myDBPassword> -c jdbc:mysql://<DB_HOST>:3306/<SCHEMA> -v 1
• Create the intial admin user:
  java -cp shell-tools-<version_number>-jar-with-dependencies.jar ccc.cli.Users -c jdbc:mysql://<DB_HOST>:3306/<SCHEMA> -ne <admin@example.com>  -nu <admin_username>  -np <admin_password>  -u <myDBUser>  -p <myDBPasswor>
• Set file store and lucene index folder locations on the 'settings' table.
  java -cp shell-tools-<version_number>-jar-with-dependencies.jar ccc.cli.Settings -c jdbc:mysql://<DB_HOST>:3306/<SCHEMA> -u <myDBUser> -p <myDBPassword>  -path <CC_INSTALL>
• Select the appropriate *-ds.xml file in the folder <CC_INSTALL>/cc7.ear; providing your JDBC connection URL; database username and password.
• Edit the <CC_INSTALL>/cc7.ear/META-INF/jboss-app.xml file to specify the *-ds.xml file in the <service> selected in the step above. For mysql this should like like:
  <service>mysql-ds.xml</service>
• Edit the <CC_INSTALL>/cc7.ear/services-ejb3.jar/META-INF/persistence.xml file to specify your persistence dialect. The dialect is database specific, please choose one from the table below which reffers to your database.
  
  

  Database	Dialect
  MySQL	org.hibernate.dialect.MySQL5InnoDBDialect
  SQL Server	org.hibernate.dialect.SQLServerDialect
  Oracle	org.hibernate.dialect.Oracle9Dialect

4. Deploy

• Create a symbolic link from the Jboss server deploy directory to the installation directory.
  ln -s <CC_INSTALL>/cc7.ear <JBOSS_DEPLOY_DIR>/cc7.ear
• Observe server log to monitor deployment.
  tail -f /usr/local/jboss/server/standard/log/server.log

5. Post deploy setup

• Create default folder structure:
  java -cp shell-tools-<version_number>-jar-with-dependencies.jar ccc.cli.Create -a cc7 -p admin -u admin
• Start the search indexer:
  java -cp shell-tools-<version_number>-jar-with-dependencies.jar ccc.cli.Search -b http://<JBOSS_HOST>:<JBOSS_PORT>/cc7 -p admin -u admin -c start
• Start the action schedule:
  java -cp shell-tools-<version_number>-jar-with-dependencies.jar ccc.cli.Scheduling -b http://<JBOSS_HOST>:<JBOSS_PORT>/cc7 -p admin -u admin -c start

6. Confirm the installation.

• Navigate to http://<JBOSS_HOST>:<JBOSS_PORT>/cc7/ccc/client to see the login screen.
• Log in with the initial admin user.