topic Re: Alfresco3.2r2 on tomcat6 with postgreSQL8.4 how to in Alfresco Archive

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

bwakkie — Fri, 14 Aug 2009 14:17:16 GMT

USE Alfresco 3.3 as it added PostgreSQL support during installation! FINALLY ;-)… this post is not working yethttp://forums.alfresco.com/en/viewtopic.php?f=8&t=21103#p69296I am struggling over setting up Alfresco svn on tomcat6 with a PostgreSQL 8.4 it the past week.Here is what I did:1) checkou

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

bwakkie — Mon, 17 Aug 2009 09:53:44 GMT

ping, new better title

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

bwakkie — Mon, 17 Aug 2009 10:33:01 GMT

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

bwakkie — Tue, 18 Aug 2009 10:17:13 GMT

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-Install)
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.

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

bwakkie — Thu, 04 Feb 2010 13:19:29 GMT

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

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!