topic Re: Alfresco + PostgreSQL installation in Alfresco Archive

Alfresco + PostgreSQL installation

melkor_kp — Mon, 19 Feb 2007 21:55:02 GMT

I installed the alfresco 2.0 preview with the default database version.At the beginning I experienced some problems with alfresco (in a debian based).After installing the jdk 1.5 on a creating the deb java package, defininga the JAVA_HOME system variable and adding the java programs to the system pa

Re: Alfresco + PostgreSQL installation

kevinr — Tue, 20 Feb 2007 19:01:07 GMT

For MySQL you need to execute commands to give access to the schema from the server machine i.e. something like this:


grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;
‍‍‍‍

Can you execute the equivilent commands for PostgreSQL?

Thanks,

Kevin

Re: Alfresco + PostgreSQL installation

melkor_kp — Wed, 21 Feb 2007 08:11:28 GMT

I solved this using the postgres query:

grant all on database alfresco to alfresco;‍

At the moment the alfresco.log is showing another error:

ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schemaBootst
rap' defined in class path resource [alfresco/bootstrap-context.xml]: Can't resolve reference to bea
n '&sessionFactory' while setting property 'localSessionFactory'; nested exception is org.springfram
ework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in
 class path resource [alfresco/hibernate-context.xml]: Initialization of bean failed; nested excepti
on is org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.PostgreSQLDia
lect 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFacto
ry' defined in class path resource [alfresco/hibernate-context.xml]: Initialization of bean failed; 
nested exception is org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect
.PostgreSQLDialect 

‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Alfresco + PostgreSQL installation

derek — Wed, 21 Feb 2007 11:36:12 GMT

Post a copy of the contents of your renamed custom-hibernate-dialect.properties.sample, please. Make sure there are no spaces before or after the property values.

Regards

Re: Alfresco + PostgreSQL installation

melkor_kp — Wed, 21 Feb 2007 11:51:12 GMT

This is the file /usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-hibernate-dialect.properties

#
# PostgresSQL dialect 

#
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect


#
‍‍‍‍‍‍‍‍‍

But this is errors are from version 1.4 only the first post was 2.0 preview.
If I make the version 1.4 working I will move to preview 2.0 and 2.0 because
we are very interested in the pair alfresco + postgres.

Re: Alfresco + PostgreSQL installation

derek — Wed, 21 Feb 2007 11:59:25 GMT

Was there an extra space after the dialect class in the properties file?

Re: Alfresco + PostgreSQL installation

melkor_kp — Thu, 22 Feb 2007 07:14:52 GMT

This is all my custom-hibernate-dialect.properties

hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect‍

The problem is still unsolved.
When I access the tomcat alfresco resource http://localhost:8080/alfresco/ I get:

The resource is not available

Re: Alfresco + PostgreSQL installation

derek — Thu, 22 Feb 2007 10:05:08 GMT

Hi,

Re: Alfresco + PostgreSQL installation

melkor_kp — Thu, 22 Feb 2007 11:01:43 GMT

I installed alfresco using AlfrescoCommunity-1.4-Linux-x86-Install downloaded from alfresco webpage.
the tomcat version is built in this binary, I guess is version 5.0 but I am not sure.
Here is the only hibernate file that I found.
/usr/local/alfresco/tomcat/webapps/alfresco/WEB-INF/lib/hibernate-3.1.3.jar
The manifest file is the following and it is stored in
/usr/local/alfresco/openoffice.org2.0/share/dtd/officedocument/1_0/Manifest.dtd:

<!–

    OpenOffice.org - a multi-platform office productivity suite
 
    $RCSfile: Manifest.dtd,v $
 
    $Revision: 1.9 $
 
    last change: $Author: rt $ $Date: 2005/09/08 15:53:54 $
 
    The Contents of this file are made available subject to
    the terms of GNU Lesser General Public License Version 2.1.
 
 
      GNU Lesser General Public License Version 2.1
      =============================================
      Copyright 2005 by Sun Microsystems, Inc.
      901 San Antonio Road, Palo Alto, CA 94303, USA
 
      This library is free software; you can redistribute it and/or
      modify it under the terms of the GNU Lesser General Public
      License version 2.1, as published by the Free Software Foundation.
 
      This library is distributed in the hope that it will be useful,
      but WITHOUT ANY WARRANTY; without even the implied warranty of
      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
      Lesser General Public License for more details.
 
      You should have received a copy of the GNU Lesser General Public
      License along with this library; if not, write to the Free Software
      Foundation, Inc., 59 Temple Place, Suite 330, Boston,
      MA  02111-1307  USA
 
–>
<!ELEMENT manifest:manifest (manifest:file-entry+)>
<!ATTLIST manifest:manifest xmlns:manifest CDATA #FIXED "http://openoffice.org/2001/manifest"> 

<!ELEMENT manifest:file-entry (manifest:encryption-data?)>
<!– manifest:size is usually only specified for encrypted entries –>
<!ATTLIST manifest:file-entry
        manifest:full-path CDATA #REQUIRED
        manifest:size CDATA #IMPLIED
        manifest:media-type CDATA #REQUIRED
>

<!ELEMENT manifest:encryption-data (manifest:algoritm,manifest:key-derivation)>
<!ATTLIST manifest:encryption-data
        manifest:checksum-type CDATA #REQUIRED
        manifest:checksum CDATA #REQUIRED >
<!– algoritm-name specifies the name of the algoritm used to encrypt
         the stream, for example Blowfish 
         manifest:initialisation-vector is stored encoded in Base64 –>
<!ELEMENT manifest:algoritm EMPTY>
<!ATTLIST manifest:algoritm
        manifest:algoritm-name CDATA #REQUIRED
        manifest:initialisation-vector CDATA #REQUIRED>

<!ELEMENT manifest:key-derivation EMPTY>
<!– manifest:key-derivation-name specifies the name of the algoritm used to derive
         the key, for example PBKDF2 (see rfc 2898 ) 
         manifest:salt is stored encoded in Base64 –>
<!ATTLIST manifest:key-derivation
        manifest:key-derivation-name CDATA #REQUIRED
        manifest:salt CDATA #REQUIRED
        manifest:iteration-count CDATA #REQUIRED>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I changed the word algoritm in the manifest file because the right one is
considered spam in this forum. The right file has the word written properly.
Here is the jar file
/usr/local/alfresco/tomcat/common/lib/postgresql-8.1-408.jdbc3.jar
I am using the postgres version 8.1.4.
If you need more data just ask me.

Re: Alfresco + PostgreSQL installation

derek — Thu, 22 Feb 2007 11:18:16 GMT

Hi,

Also, which flavour of linux are you using?
http://forums.alfresco.com/viewtopic.php?t=5051&view=next.

Did you check if the PostgreSQLDialect class was in the Hibernate jar?

Regards

Re: Alfresco + PostgreSQL installation

melkor_kp — Thu, 22 Feb 2007 11:28:41 GMT

I am using xubuntu, but I am using the tomcat provided by the binary
alfresco instlall package so that is not my case. Furthermore i had
alfresco alfresco running in this computer with hsl and with mysql but
still not in postgres.

I don't know how to check the hibernate issue in a jar file.
Could you help me. I tried with cat or less but I discovered is a
format like tar or a compressed one and I don't know how to
decompress it.

Re: Alfresco + PostgreSQL installation

melkor_kp — Thu, 22 Feb 2007 11:33:33 GMT

I discovered, I uncompress the file with

 jar xf hibernate-3.1.3.jar‍

but I don't know where is placed the information you say, there are two folders.
Which file in org contains what you say in the previous post?

Re: Alfresco + PostgreSQL installation

derek — Thu, 22 Feb 2007 11:58:24 GMT

The package name of the class will give the folder structure in the uncompressed jar, i.e. ./org/hibernate/dialect/PostgreSQLDialect. You could use find as well. Let's see:

find . -name .*Dialect‍

If you find it, then the class is there and you have more serious ClassLoader issues.

Regards

Re: Alfresco + PostgreSQL installation

melkor_kp — Thu, 22 Feb 2007 14:08:36 GMT

I didn't find this file. It is not there.

Re: Alfresco + PostgreSQL installation

derek — Thu, 22 Feb 2007 14:14:38 GMT

OK. That's a start. What is in the manifest.mf file what is in the root?

Re: Alfresco + PostgreSQL installation

melkor_kp — Mon, 26 Feb 2007 07:06:16 GMT

This is the MANIFEST.MF file inside the hibernate-3.1.3.jar

Manifest-Version: 1.0
Ant-Version: Apache Ant 1.6.5
Created-By: 1.4.2_09-b05 (Sun Microsystems Inc.)
Hibernate-Version: 3.1.3
‍‍‍‍‍