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?

[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.mf file what is in the root?

[melkor_kp]

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

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