Installing Alfresco Labs 3b on Solaris 10

Document created by resplin Employee on Jun 6, 2015
Version 1Show Document
  • View in full screen mode

Obsolete Pages{{Obsolete}}

The official documentation is at: http://docs.alfresco.com



Installation


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


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
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
  • 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?

Attachments

    Outcomes