topic Alfresco and PostgreSQL in Alfresco Archive

Alfresco and PostgreSQL

carl — Fri, 05 Jul 2013 12:09:24 GMT

I'm trying to install alfresco community edition (war file) on a CentOS 6u3 x86_64 machine running tomcat 7 under jsvc with java 1.6u33 and postgresql 9.1postgresql91-server-9.1.8-2PGDG.rhel6.x86_64postgresql91-libs-9.1.8-2PGDG.rhel6.x86_64postgresql91-9.1.8-2PGDG.rhel6.x86_64I've already got anothe

Re: Alfresco and PostgreSQL

gyro_gearless — Fri, 05 Jul 2013 12:20:50 GMT

The log does not say anything about trouble with Postgres; it barks on ClassNotFoundException!

So check which version of java you have installed - Sun err Oracle JDK 7 is the preferred version, OpenJDK 7 should do as well!

HTH
Gyro

Re: Alfresco and PostgreSQL

carl — Fri, 05 Jul 2013 13:27:35 GMT

As per original entry:
Java SDK 1.6u33 (required for other purposes)

It's on the PATH and JAVA_HOME is defined

java version "1.6.0_33"
Java(TM) SE Runtime Environment (build 1.6.0_33-b04)
Java HotSpot(TM) 64-Bit Server VM (build 20.8-b03, mixed mode)

Maybe something in the invocation of tomcat?

Re: Alfresco and PostgreSQL

bopolissimus — Fri, 05 Jul 2013 21:23:05 GMT

Hi,

have a look at:

12:12:33,695 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.service.cmr.repository.ContentIOException: 06050000 Failed to open stream onto channel:
writer: ContentAccessor[ contentUrl=store:///usr/share/tomcat/temp/Alfresco/AlfrescoSchema-PostgreSQLDialect-Update-2242626767569121007.sql, mimetype=null, size=0, encoding=UTF-8, locale=en_GB]

it looks like the problem is that tomcat is trying to create a file in /usr/share/tomcat/temp/Alfresco and it's not able/allowed to.

I'm on Ubuntu (running alfresco under the distribution tomcat7) and I didn't run into that issue, so I don't know how to fix it *the*right*way*. To fix it the quick way, you could just make sure that directory exists and is writable by the tomcat7 user (or whatever user runs tomcat).

gerald