Installing on linux debian, with jboss and postgree.....

[hsp]

Helio, I'm very glad with the possibility to test Alfresco.
But I'm in trouble with the installation on this configuration.
I've had followed the instructions about postgree and jboss but not sucessfuly.
Coud anyone send me a step by step to do Alfresco works on the configuration on the subject above?
Please, help me, because I'm new in this environment.
If you want I can send the jboss log….
I have some question too:
Does the Alfresco run in jboss (not jboss portal)?
How can I open the source in eclipse to analize it?
How can I take the database diagram in some modeling tool?
Is the database schema created in the first time Alfresco run? Because you only tell to create a database and a user by that file db_setup.sql (that instructions doesn't work on postgree…)
waiting…..
cheers
Helio

[hsp]

Well, I did it work…..by the way, bymyself. Thanks.
These instructions will be usefull to anyone who find trouble in installation Alfresco with jboss, postgre, debian.
The following steps are needed:

Find the file 'postgres-driver.jar' and place it in the folder /opt/alfresco/jboss/server/default/lib/

Edit the file repository.properties, located in …/WEB-INF/classes/alfresco/
# Database configuration para PostgreSQL

db.driver=org.postgresql.Driver

db.name=alfresco

db.url=jdbcostgresql://localhost/alfresco

db.username=alfresco

db.password=alfresco

Edit the file WEB-INF/classes/alfresco/hibernate-context.xml
change: org.hibernate.dialect.MySQLDialect
to: org.hibernate.dialect.PostgreSQLDialect

To install postgreSql:
apt-get update
apt-get install postgre

after installed, do:
look for the file /etc/postgresql/pg_hba.conf, and uncoment the line content:
host    all         all         127.0.0.1         255.255.255.255 
ident sameuser

In the file /etc/postgresql/postgresql.conf add the line: tcpip_socket = true

To configure postgre:
a)su - postgres
b)createuser -W
   You will be asked if the user can create databases, answer yes
   You will be asked if the user can create other users, answer no
   I used a username of alfresco

c)createdb -O alfresco alfresco  (that is an O for Owner)

d) psql -d alfresco
e) \du

              List of database users
User name | User ID |         Attributes
————————————————–
alfresco        |     100 | create database
postgres  |       1 | superuser, create database

So, go to the directory where the alfresco.sh is, and run: ./alfresco.sh start

http://localhost:8080/portal

user and password: admin.

It must be enough.

Now I'm trying to deploy it to jboss 4 (no portal).

[kevinr]

Glad to hear you have got it working, we haven't yet tried Postgres internally so that's great to hear it works ok on that database.

Yes Alfresco works in JBoss (with a WAR file - very similar to TomCat as it uses TomCat internally as it's Servlet container) or JBossPortal.

Thanks,

Kevin

[hsp]

By the way…..
I'm not sure how to configure the eclipse environment to deploy the alfresco in it, to run with jboss 4. I'd tryed many times, in different ways, but without sucess.
If I create a J2EE Web Project in eclipse, where must I place the alfresco's source files?
Could someone help me with this?

We are getting to develop a web solution for company's documents repository with your alfresco as a engine. We think it is possible, and we'll feed back the community with knowledges we obtained in this period.

Tks
Helio
Curitiba - Brazil

[davidc]

Hi,

Within the source bundle, you will find that we provide the Eclipse project files that we use for development.  There are several of them, which all need to be imported into Eclipse.  You can find each of them in the sub-directories of /projects e.g. /projects/3rd-party/.project.

Hope that helps.

[ajr]

Upon trying to switch to postgres, we are getting the following error. Seems to have something to do with the dialect:

The dialect was setup correctly in the hibernate-cfg.properties

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

Here is some proof of dialect in the log file:

2006-01-11 16:00:03,871 DEBUG [org.hibernate.cfg.Configuration] dialect=org.hibernate.dialect.PostgreSQLDialect
‍‍

Here is the error:

16:00:38,799 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
16:00:38,799 ERROR [JDBCExceptionReporter] Batch entry 0 insert into node_status (change_txn_id, deleted, protocol, identifier, guid) values (1137013237154:508f4893-82e5-11da-a637-d5cdb3fd5489, 0, system, system, 5102a3d4-82e5-11da-a637-d5cdb3fd5489) was aborted.  Call getNextException to see the cause.
16:00:38,799 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: 42804
16:00:38,799 ERROR [JDBCExceptionReporter] ERROR: column "deleted" is of type bit but expression is of type boolean
16:00:38,803 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:200)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:91)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
        at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:169)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2033)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2410)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍