Alfresco3.2r2 on tomcat6 with postgreSQL8.4 how to

[bwakkie]

USE Alfresco 3.3 as it added PostgreSQL support during installation! FINALLY ;-)… this post is not working yet
http://forums.alfresco.com/en/viewtopic.php?f=8&t=21103#p69296

I am struggling over setting up Alfresco svn on tomcat6 with a PostgreSQL 8.4 it the past week.



Here is what I did:

1) checkout HEAD (svn://svn.alfresco.com/alfresco/HEAD)
2) go into root dir
3) run ant build
4) download tomcat6
5) make a virtual-tomcat6 copy (perhaps I need to do this after a complete Alfresco install? This is a little bit unclear to me)
6) set environment variables:

export JAVA_HOME=/usr/lib/jvm/java-6-sun/
export TOMCAT_HOME=/home/dev/apache-tomcat-6.0.20/
export APP_TOMCAT_HOME=$TOMCAT_HOME
export CATALINA_HOME=$TOMCAT_HOME
export CATALINA_BASE=$TOMCAT_HOME
export VIRTUAL_TOMCAT_HOME=/home/dev/apache-virtual-tomcat-6.0.20‍‍‍‍‍‍

7) download http://jdbc.postgresql.org/download/postgresql-8.4-701.jdbc4.jar and place it in TOMCAT_HOME/lib/postgresql-8.4-701.jdbc4.jar

—- intermezzo of the part is the documentation that confuses me (it might be due to my not English nativeness)
[from http://wiki.alfresco.com/wiki/Install_Tomcat6:]
   1. Create TOMCAT_HOME/shared/classes/
   2.   Create the <TOMCAT_HOME>/shared/classes/ directory and copy the extension files and full structure from the WAR to create the following directories:
   ../shared/classes/alfresco/extension/<files> (alfresco.war extension override files)
   ../shared/classes/alfresco/messages/<files> (locale specific message files)
   ../shared/classes/alfresco/web-extension/<files> (share.war extension override files)
Now it is getting brurry for me..what do I need to do in step 2??
   3. Open the <TOMCAT_HOME>/conf/catalina.properties file.
   4. Change the value of shared.loader= to the following:
          shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar
Will this have any effect on already installed webapps?
   5. One further change is that Tomcat6 does away with the common/lib directory, so you need to copy the JDBC drivers for the database you are using to the lib/ directory.
   6. According to the PDF files [where?], you also need to copy commons-el.jar into lib
—- /intermezzo

😎 Extract the war file by hand and drop all files into TOMCAT_HOME/shared/classes/alfresco/extension/? (this is what I understood)
9) Extract the  ../svn/Alfresco/root/projects/slingshot/build/dist/share.war file to TOMCAT_HOME/shared/classes/alfresco/web-extension/
10) Alter <TOMCAT_HOME>/conf/catalina.properties > shared.loader=${catalina.base}/shared/classes,${catalina.base}/lib/*.jar
11) restart tomcat6
12) Not sure when this happened but I also edited  the TOMCAT_HOME/conf/Catalina/localhost/alfresco.xml to add postgres:
<Resource defaultTransactionIsolation="-1" defaultAutoCommit="false" maxActive="100" initialSize="10" password="….." username="workalfresco" url="jdbcostgresql://localhost/alfresco" driverClassName="org.gjt.mm.postgresql.Driver" type="javax.sql.DataSource" auth="Container" name="jdbc/dataSource"/>

according to http://anipossible3.blogspot.com/2008/01/alfresco-postgresql-configuration.html I also need to edit custom-repository.properties and custom-hibernate-dialect.properties but I do not see them.

At one moment I also dropped the alfresco.war file just in the TOMCAT_HOME/webapps folder and created an alfresco folder but this all does not matter.

In the tomcat manager I see alfresco and I can start and stop it.

Can someone get me back on track?

ps why would I do such a thing anyway? Deploying Alfresco into my company will take some time so I rather use the latest of the latest in order to be current by the time I will deploy to production. Sounds reasonable right?

Cheers,
Bastiaan

[bwakkie]

ping, new better title

[bwakkie]

see also the post from alpargata:
http://forums.alfresco.com/en/viewtopic.php?f=8&t=21054&start=0&st=0&sk=t&sd=a&hilit=PostgreSQL

[bwakkie]

Ok I throw is over a different path:

1) I downloaded the alfresco linux install and setup a mysql server (http://process.alfresco.com/ccdl/?file=release/community/build-2039/Alfresco-Community-3.2-Linux-x86...)
2) Setup mysql db make sure you have the root password as the installer will ask for it. Also find out where openoffice is (/usr/lib/openoffice in my case)
3) run the Alfresco-Community-3.2-Linux-x86-Install with the 'standard' mysql db and as a base dir ~/dev/Alfresco32
when finished do not go to the website yet!!!
4) Go as postgres user into your postgres db and create a user and db (like in http://anipossible3.blogspot.com/2008/01/alfresco-postgresql-configuration.html)
check if it is working:

psql -U workalfresco -h 127.0.0.1 -p 5432‍

5) Download http://jdbc.postgresql.org/download/postgresql-8.4-701.jdbc4.jar from http://jdbc.postgresql.org/download/ and place it in ~/dev/Alfresco32/tomcat/lib/postgresql-8.4-701.jdbc4.jar
6)install swftools

 sudo apt-get install swftools‍

7) Edit ~/dev/Alfresco3.2/tomcat/shared/classes/alfresco-global.properties:

dir.root=/home/bwakkie/dev/Alfresco3.2/alf_data
db.name=workalfresco
db.username=workalfresco
db.password=…
db.host=localhost
db.port=5432
ooo.exe=/usr/lib/openoffice/program/soffice
img.root=/usr
swf.exe=/usr/bin/pdf2swf  

#
# PostgreSQL connection
#————-
db.driver=org.postgresql.Driver
db.url=jdbc:postgresql://${db.host}:${db.port}/${db.name}
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
hibernate.query.substitutions=true TRUE,false FALSE‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

😎 download http://process.alfresco.com/ccdl/?file=release/community/build-2039/postgresql-3.2-community.amp and place it in ~/dev/Alfresco3.2/amps
9) run ~/dev/Alfresco3.2/apply_amps.sh
…somewhere in the output you will see:
Module 'PostgreSQL.for.Alfresco.3.2.Community' installed in '/home/bwakkie/dev/Alfresco3.2/tomcat/webapps/alfresco.war'
   -    Title:        PostgreSQL for Alfresco 3.2 (Community)
   -    Version:      1.0
   -    Install Date: Tue Aug 18 10:16:06 CEST 2009
   -    Desription:   Install ibatis sql-maps and sql scripts.
10) rm -rf ~/dev/Alfresco3.2/alf_data and ~/dev/Alfresco3.2/tomcat/webapps/alfresco to be sure

11) startup alfresco:

cd ~/dev/Alfresco3.2
./alfresco.sh 
./alf_start.sh‍‍‍

open in a different terminal

 tail -f dev/Alfresco3.2/tomcat/logs/catalina.out‍

to see the buildup process
after it said "INFO: Server startup in … ms" (was for me 341006 ms) you can go to

http://localhost:8080/alfresco‍

Now my next steps:
Setting up alfresco as replacement for filenet(document management tool) and serena collage(content management tool) (both 5 figures tools) for our websites and intranet.
Thinking about how to migrate the metadata, perhaps with OpenMigrate.

[bwakkie]

some new addresses:
http://sourceforge.net/projects/alfresco/files/Extensions/3.2r%20Community%20Edition/postgresql-3.2r...

Change the ALFRESCO_DIR in the conf files:

sed -i_ 's/@@ALFRESCO_DIR@@/\/home\/alfresco\/Alfresco32r2/g' *.sh‍

Also I normally suppose to start the amp script apply_amps.sh script which is looking for the /tomcat/bin/clean_tomcat.sh script that is not present.

Is this script still te be used in order to include an amp file??
anyway: I did it the manual way:

java -jar bin/alfresco-mmt.jar install /home/alfresco/Alfresco32r2/amps/ /home/alfresco/Alfresco32r2/tomcat/webapps/alfresco.war -directory -verbose
java -jar bin/alfresco-mmt.jar list /home/alfresco/Alfresco32r2/tomcat/webapps/alfresco.war‍‍

Output:
Module 'PostgreSQL.for.Alfresco.3.2r' installed in '/home/alfresco/Alfresco32r2/tomcat/webapps/alfresco.war'
   -    Title:        PostgreSQL for Alfresco 3.2r
   -    Version:      1.0
   -    Install Date: Thu Feb 04 14:34:47 CET 2010
   -    Desription:   Install ibatis sql-maps and sql scripts.


THIS INSTALL FAILED!