Obsolete Pages{{Obsolete}}
The official documentation is at: http://docs.alfresco.com
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.
The following was completed, not necessarily in this order:
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.
You can really install MySQL however you want, but Blastwave's pkg-get is probably easiest.
pkg-get install phpmyadmin
mysql>create database alfresco;
mysql> grant all privileges to 'alfresco'@'%' on alfresco.* identified by 'alfresco' with grant option;
mysql> flush privileges;
bash-3.00# cp ~/Downloads/mysql-connector-java-5.1.7/mysql-connector-java-5.1.7-bin.jar /opt/alfresco/tomcat/common/lib/
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
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
alfresco:>/opt/csw/mysql5/bin/mysql -umrcontroluser -pwerp230MIlwsqw < /opt/alfresco/extras/databases/mysql/db_setup.sql
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
> /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.