Installing Alfresco Labs 3b on Solaris 10

From AlfrescoWiki

Jump to: navigation, search


Contents

[edit] Summary and Overview

[edit] 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.

[edit] 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...

[edit] Software Versions and Where to Get It

[edit] 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.)

[edit] 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.

[edit] 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 
bash-3.00# cp ~/Downloads/mysql-connector-java-5.1.7/mysql-connector-java-5.1.7-bin.jar  /opt/alfresco/tomcat/common/lib/

[edit] Alfresco

  • Alfresco Labs 3b
  • 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.

[edit] Incomplete

  • SharePoint
  • OpenOffice
  • Starting Alfresco as a SMF service
  • Starting MySQL as a SMF service
  • More?
Retrieved from "http://wiki.alfresco.com/wiki/Installing_Alfresco_Labs_3b_on_Solaris_10"