Installing Alfresco Labs 3b on Solaris 10

From alfrescowiki

Contents 1 Summary and Overview 1.1 Synopsis 1.1.1 Questions 1.2 Software Versions and Where to Get It 1.3 Assumptions and Conventions 2 Installation Details 2.1 MySQL 2.2 Alfresco 2.3 Incomplete

Summary and Overview

Synopsis

I had several questions before doing this. I finally got Alfresco installed and working, and, in the process, answered those questions. Here are the questions and hopefully the answers are intermingled in the text of this installation overview.

Questions

• What version of Alfresco?
• Do I need OpenOffice? Why?
• Is "Alfresco" the CMS, the content repository, or both, or more? The terminology is somewhat ambiguous.
• ...more...

Software Versions and Where to Get It

• Solaris 10 (10/08) (Sun Download Page)
• Alfresco Labs 3b
  • Which Installation file? Look for "Preconfigured Tomcat bundle for any platform..."
  • Download Page, direct link to previous bullet
• MySQL 5 installed via Blastwave/pkg-get

Assumptions and Conventions

• Alfresco installation in /opt/alfresco
• MySQL installation in /opt/csw/mysql5
• Some familiarity with setting up Solaris services/SMF will be helpful
• I did this install in 2 places, one in the global zone on a Solaris instance that had only the global zone, and the second on a secondary zone called "alfresco" (of all things). So some code snippets may have "alfresco:>" in them -- that is the command prompt in the alfresco zone. (If you are not familiar with Solaris zones, you should be. They are awesome.)

Installation Details

The following was completed, not necessarily in this order:

• Install MySQL
  • Set up as SMF service
• Install Alfresco
  • Set up as SMF service

I still have some details to tweak, and some addons to install next, which I hope to have done and document here in the next day or two.

MySQL

You can really install MySQL however you want, but Blastwave's pkg-get is probably easiest.

• Install MySQL

pkg-get install phpmyadmin

• Add database `alfresco` and user alfresco with access to that db

mysql>create database alfresco;
mysql> grant all privileges to 'alfresco'@'%'  on alfresco.* identified by 'alfresco' with grant option;
mysql> flush privileges;

• MySQL JDBC Connector
  • Download it MySQL Download Page
  • Copy it to the Alfresco Tomcat container libdir

bash-3.00# cp ~/Downloads/mysql-connector-java-5.1.7/mysql-connector-java-5.1.7-bin.jar  /opt/alfresco/tomcat/common/lib/

Alfresco

• Alfresco Labs 3b
  • alfresco-labs-tomcat-3b.tar.gz
• Configure Alfresco
• Use MySQL instead of HSQL
• Edit files in Tomcat configuration
• EDIT /opt/alfresco/tomcat/shared/classes/alfresco/extension/custom-hibernate-dialect.properties

EXAMPLE:

alfresco:>vi /opt/alfresco/tomcat/shared/classes/alfresco/extension/custom-hibernate-dialect.properties

### Uncomment the following (line 19):

# MySQL dialect (default)
#
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

• EDIT /opt/alfresco/tomcat/shared/classes/alfresco/extension/custom-repository.properties

EXAMPLE:

alfresco:>vi /opt/alfresco/tomcat/shared/classes/alfresco/extension/custom-repository.properties

### Uncomment the following (lines 46-47):

# MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server)
#
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco

• Create Alfresco database and user

alfresco:>/opt/csw/mysql5/bin/mysql -umrcontroluser -pwerp230MIlwsqw  < /opt/alfresco/extras/databases/mysql/db_setup.sql

• Tweak the supplied startup script.
  • Take "export" off of variable declaration lines and move to subsequent line. (e.g. "export X=blah" to "X=blah;export X")
  • Set up ALF_HOME=/opt/alfresco
  • Add JAVA_HOME=/usr/java

New alfresco.sh EXAMPLE:

> cat /opt/alfresco/alfresco.sh
#!/bin/sh
# Start or stop Alfresco server
# Set the following to where Tomcat is installed
ALF_HOME=/opt/alfresco
JAVA_HOME=/usr/java
export JAVA_HOME
cd "$ALF_HOME"
APPSERVER="${ALF_HOME}/tomcat"
# Set any default JVM values
JAVA_OPTS='-Xms128m -Xmx512m -XX:MaxPermSize=128m -server'
export JAVA_OPTS

if [ "$1" = "start" ]; then
  "${APPSERVER}/bin/startup.sh"
#  if [ -r ./virtual_start.sh ]; then
#    sh ./virtual_start.sh
#  fi
#  if [ -r ./start_oo.sh ]; then
#    sh ./start_oo.sh
#  fi
elif [ "$1" = "stop" ]; then
  "${APPSERVER}/bin/shutdown.sh"
#  if [ -r ./virtual_start.sh ]; then
#    sh ./virtual_stop.sh
#  fi
#  if [ -r ./start_oo.sh ]; then
#    killall soffice.bin
#  fi
fi

• Start Alfresco
  • 1. start MySQL
  • 2. start Alfresco

> /opt/csw/mysql5/bin/mysqld_safe &
> /opt/alfresco/alfresco.sh start

That should be enough to get Alfresco running! The rest is important, but can be done after. I still need to add OpenOffice, Sharepoint integration, and one or two other things.

Incomplete

• SharePoint
• OpenOffice
• Starting Alfresco as a SMF service
• Starting MySQL as a SMF service
• More?