Instalación Alfresco Labs 3b en Ubuntu Server 8.04

[tychocity]

El tutorial fue basado en el siguiente

http://forums.alfresco.com/fr/viewtopic.php?f=6&t=1810


1. Instalar los paquetes necesarios

$sudo apt-get install mysql-server libmysql-java openoffice.org openoffice.org-headless iptables sun-java6-jdk imagemagick portmap nfs-common libjpeg62-dev libt1-dev libt1-dev libxft-dev libungif4-dev‍

2. instalar swftools

$wget http://www.swftools.org/swftools-2008-09-26-2010.tar.gz

$tar -zxvf swftools-2008-09-26-2010.tar.gz
$cd swftools-2008-09-26-2010
$sudo ./configure
$sudo ./make
$sudo ./make install‍‍‍‍‍‍‍

3. Crear usuario y grupo para correr la aplicacion

$sudo groupadd alfresco
$sudo useradd -m -g alfresco alfresco
‍‍‍

4. Descomprimir el paquete

$sudo mkdir /opt/alfresco
$cd /opt/alfresco
$sudo cp alfresco-labs-tomcat-3b.tar.gz /opt/alfresco
$sudo tar -zxvf alfresco-labs-tomcat-3b.tar.gz
$sudo rm alfresco-labs-tomcat-3b.tar.gz‍‍‍‍‍

5. Crear la base de datos

$mysql –u root -p
$mysql> create database alfresco;
$mysql> grant all privileges on alfresco.* to alfresco@localhost identified by 'alfresco';‍‍‍

6. Agregar variable JAVA_HOME

editar /opt/alfresco/alfresco.sh

export JAVA_HOME=/usr/lib/jvm/java-6-sun

7. Configurar repositorio

editar custom-repository.properties

tiene que quedar asi

###############################
## Common Alfresco Properties #
###############################

#
# Sample custom content and index data location
#
dir.root=/opt/alfresco/alf_data

#
# Sample database connection properties
#
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=100

#
# Sample index tracking frequency
#
#index.tracking.cronExpression=0/5 * * * * ?

#
# Property to control whether schema updates are performed automatically.
# Updates must be enabled during upgrades as, apart from the static upgrade scripts,
# there are also auto-generated update scripts that will need to be executed.  After
# upgrading to a new version, this can be disabled.
#
#db.schema.update=true

#
# Derby connection
#
#db.driver=org.apache.derby.jdbc.EmbeddedDriver
#db.url=jdbc:derby:alf_data/derby_data/alfresco;create=true

#
# HSQL connection
#
#db.driver=org.hsqldb.jdbcDriver
#db.url=jdbc:hsqldb:file:alf_data/hsql_data/alfresco;ifexists=true;shutdown=true;

#
# 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

#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)
#
#db.driver=org.postgresql.Driver
#db.url=jdbc:postgresql://localhost:5432/alfresco‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

editar custom-hibernate-dialect.properties

tiene que quedar asi

#hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect‍‍

8. arreglar inicio de openoffice

editar openoffice-startup-context.xml

tiene que quedar asi

 <value><![CDATA[/usr/lib/openoffice/program/soffice "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager" "-env:UserInstallation=file:///usr/lib/openoffice" -nologo -headless -nofirststartwizard -nocrashrep -norestore]]></value>[/code]

9. Crear script inicio.

[code]#!/bin/bash
#
# Alfresco init script for Ubuntu server 8.04 based on Joost Horward’s script
# 16:16 02.05.2008 VDo
#

export PIDFILE=/var/run/alfresco
export LOGFILE=/var/log/alfresco/alfresco.log
export ALFRESCO_HOME=/opt/alfresco
export JAVA_HOME=/usr/lib/jvm/java-6-sun

cd $ALFRESCO_HOME
#
# redirect FROM TO PROTOCOL
# setup port redirect using iptables
redirect() {
  echo "Redirecting port $1 to $2 ($3)"
  iptables -t nat -A OUTPUT -d localhost -p $3 –dport $1 -j REDIRECT –to-ports $2
  iptables -t nat -A PREROUTING -d $HOSTNAME -p $3 –dport $1 -j REDIRECT –to-ports $2
  iptables -t nat -A OUTPUT -d $HOSTNAME -p $3 –dport $1 -j REDIRECT –to-ports $2
}

#
# setup_iptables
# setup iptables for redirection of CIFS and FTP
setup_iptables () {

  echo "1" >/proc/sys/net/ipv4/ip_forward
  # Clear NATing tables
  iptables -t nat -F
  # FTP NATing
  redirect 21 2021 tcp

  # CIFS NATing
  redirect 445 1445 tcp
  redirect 139 1139 tcp
  redirect 137 1137 udp
  redirect 138 1138 udp
}

#
# start_openoffice
##
start_openoffice(){
  sudo -H -u alfresco /usr/bin/soffice "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager" -nologo -headless -nofirststartwizard &
}


case $1 in
start)
  if [ -f $PIDFILE ] ; then
    echo "Alfresco is already running!"
    exit 1
  fi
  touch $PIDFILE

echo "Starting OpenOffice service …"
  start_openoffice 

 
  echo "Setting up iptables …"
  setup_iptables 

  echo "Starting Alfresco …"
  echo -e "\n\n\n`date` Starting Alfresco …" >>$LOGFILE
  sudo chown alfresco:alfresco $LOGFILE

  sudo -H -u alfresco sh $ALFRESCO_HOME/alfresco.sh start
        ;;
stop) 
  sudo -H -u alfresco sh $ALFRESCO_HOME/alfresco.sh stop
  killall -w -u alfresco
        echo  -e "`date` Stopping Alfresco …" >>$LOGFILE
  rm $PIDFILE
        ;;
restart)
  rm $PIDFILE
  sudo -H -u alfresco sh $ALFRESCO_HOME/alfresco.sh stop
  killall -w -u alfresco
   echo  -e "\n\n\n`date` Restarting Alfresco …" >>$LOGFILE
  sudo -H -u alfresco sh $ALFRESCO_HOME/alfresco.sh start
  touch $PIDFILE
        ;;
zap)
  echo "Zapping $PIDFILE …"
  rm $PIDFILE
  ;;
*)
  echo "Usage: alfresco [start|stop|restart|zap] [tail]"
  exit 1
  ;;

esac   

case $2 in
tail)
  tail -f $LOGFILE
  ;;
esac

exit 0
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

$sudo chown root:root /etc/init.d/alfresco
$sudo chmod 755 /etc/init.d/alfresco
$sudo cp /usr/share/java/mysql-5.1.5.jar /usr/share/java/mysql-5.1.5.jar
$sudo chown -R alfresco.alfresco /opt/alfresco‍‍‍‍

10. Iniciar Alfresco.

$sudo /etc/init.d/alfresco start‍

alfresco.log

17:21:21,876 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
17:21:47,916 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
17:22:03,388 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
17:22:03,503 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-31102.sql (Generated).
17:22:15,910 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-31103.sql (Copied from classpath:alfresco/dbscripts/create/2.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-2.2-MappedFKIndexes.sql).
17:22:15,914 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-31104.sql (Copied from classpath:alfresco/dbscripts/create/2.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-2.2-Extra.sql).
17:22:16,036 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-31105.sql (Copied from classpath:alfresco/dbscripts/create/3.0/org.hibernate.dialect.MySQLInnoDBDialect/create-activities-extras.sql).
17:22:16,178 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] All executed statements written to file /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-All_Statements-31106.sql.
17:23:09,541 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /opt/alfresco/alf_data
17:23:09,583 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …
17:23:10,138 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.db-V3.0-0-CreateActivitiesExtras
RESULT: 
Script completed
=====================================
17:23:10,142 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Found 0 module(s).
17:23:10,381 ERROR [org.alfresco.smb.protocol] Failed to get local domain/workgroup name, using default of WORKGROUP
17:23:10,381 ERROR [org.alfresco.smb.protocol] (This may be due to firewall settings or incorrect <broadcast> setting)
17:23:11,159 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_06-b02; maximum heap size 506.313MB
17:23:11,160 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Labs): Current version 3.0.0 (b 1164) schema 131 - Installed version 3.0.0 (b 1164) schema 131‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[tychocity]

i'm post the alfresco  log.