nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Alfresco + PostgreSQL installation

melkor_kp

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, defining
a the JAVA_HOME system variable and adding the java programs to the system path
everything works fine.

I have a problem now because I have to change the default database to a postgres
one. I followed the wiki instructions but the database migration is not working.
In the alfresco.log I receive a message of unauthorized schema.

Does anybody knows what is happening?

Find more posts tagged with

Comments

kevinr

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

melkor_kp

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 

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

derek

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

melkor_kp

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.

derek

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

melkor_kp

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

derek

Hi,

What version of Tomcat are you using?Exactly which file did you use to install Alfresco (filename and downloaded from)?Can you double check that there is exactly one Hibernate jar present in the installation and that it is in the alfresco web application WEB-INF/lib.What version of the jar is it, i.e. what does it say in the manifest file?Is the PostgreSQLDialect in the jar?

melkor_kp

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.

derek

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

melkor_kp

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.

melkor_kp

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?

derek

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

melkor_kp

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

derek

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

melkor_kp

This is the MANIFEST.**** 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
‍‍‍‍‍