AnsweredAssumed Answered

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

Question asked by bwakkie on Aug 14, 2009
Latest reply on Feb 4, 2010 by 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
8) 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="jdbc:postgresql://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

Outcomes